Ti ringrazio Maximum, ma non riesco ad inserirlo in questo codice, va in errore, puoi aiutarmi?:
codice:
function SaveFiles
Dim Upload, fileName, fileSize, ks, i, fileKey
Set Upload = New FreeASPUpload
Upload.Save(uploadsDirVar)
If Err.Number<>0 then Exit function
SaveFiles = ""
ks = Upload.UploadedFiles.keys
if (UBound(ks) <> -1) then
SaveFiles = ""
for each fileKey in Upload.UploadedFiles.keys
SaveFiles = (SaveFiles & Upload.UploadedFiles(fileKey).FileName)
SaveFiless = Upload.UploadedFiles(fileKey).FileName & " (" & Upload.UploadedFiles(fileKey).Length & " Bytes) "
set fso = server.createObject("scripting.fileSystemObject")
if fso.fileExists(file) then
set file = fso.openTextFile(file)
i = 1
while not file.atEndOfStream
if i > 1 then
tempLine = file.readLine
'tempLine = replace(tempLine,"'","`")
tempLine = replace(tempLine,"""","")
if not left(tempLine,6) = "Nome" then
elTempLine = split(tempLine,",")
tempDate = eltempLine(3)
if not isDate(tempDate) then tempDate = "01/12/2004"
' Query di controllo esistenza record
sql = "SELECT ......"
Set objRs = Server.CreateObject("ADODB.Recordset")
objRs.Open sql, objconn, 3, 3
if not objRs.bof and not objRs.eof then
response.write "record già esistente
"
objRs.close
set objRs = nothing
else
'Query di registrazione valori
strSQL = "INSERT INTO ....."
objconn.execute strSQL
end if
end if
end if
i = i + 1
wend
set file = nothing
set fso = nothing
end if
objconn.close
set objconn = nothing
next
Response.write("Registrazione eseguita correttamente.")
else
SaveFiles = "KO."
end if
end function