Ho modificato cosi
for each fileKey in Upload.UploadedFiles.keys
Response.write "foto" &fileKey & " " & Upload.UploadedFiles(fileKey).FileName




SaveFiles = SaveFiles & Upload.UploadedFiles(fileKey).FileName & " (" & Upload.UploadedFiles(fileKey).Length & "B) "


strsql=strsql & filekey & "='" & Upload.UploadedFiles(fileKey).FileName

strsql= strsql & " ', "

next


Set OBJCON = Server.CreateObject("ADODB.Connection")
OBJCON.Open "coppola"
query = "UPDATE foto SET " & strsql & " WHERE id =" & testo1
Response.write query
Set Teresa = OBJCON.Execute(query)
OBJCON.Close





mi da errore di sintassi
ecco il response della query ma dov'è l'errore

UPDATE foto SET attach1='6.jpg', attach2='conca1g.jpg', attach3='conca1gg.jpg', attach4='conca7p.jpg', attach5='conca9g.jpg', attach6='conca3g.jpg', WHERE id =1