codice:
<%
Dim gg,mm,aa,hh,mn,ss
gg = Day(Date())
mm = Month(Date())
aa = Year(Date())
hh = Hour(Time())
mn = Minute(Time())
ss = Second(Time())
codicearticolo = "BBA"&ss&""&mm&""&gg&"X"&hh&""&ss&""&mn
Dim SQL
SQL="INSERT INTO catalogo (codicearticolo, articolo, codice, categoria,sottocat,spazio1,spazio2,spazio3,spazio4,spazio5,catalogo,online) VALUES ('"&codicearticolo&"', '"&Replace(Request.Form("articolo"), "'", "''")&"', '"&Replace(Request.Form("codice"), "'", "''")&"', '"&Replace(Request.Form("categoria"), "'", "''")&"', '"&Replace(Request.Form("sottocat"), "'", "''")&"', '"&Replace(Request.Form("spazio1"), "'", "''")&"', '"&Replace(Request.Form("spazio2"), "'", "''")&"', '"&Replace(Request.Form("spazio3"), "'", "''")&"', '"&Replace(Request.Form("spazio4"), "'", "''")&"', '"&Replace(Request.Form("spazio5"), "'", "''")&"', '"&Replace(Request.Form("catalogo"), "'", "''")&"', '"&Request.Form("online")&"');"
conn.Execute(SQL)
Dim oUpload
Set oUpload= new cUpload
With oUpload
.EnabledAspUpload = False
.EnabledImageSize = TRUE
.EnabledLog = False
.AutoRename = True
.Overwrite = False
.SetPath "/public/"
.Load
.UploadOnly "Images"
While Not .Eof
if lcase(oUpload.Files("ext"))<>"jpg" then
response.write "file vietato"
else
If .Files("Height")>=500 or .Files("Width")>=500 then
Response.write ("Le dimensioni dell'immagine " &_
.GetFileName() &" non sono corrette (" &_
.Files("Height") &"x" & .Files("Width") &"): File non caricato
" )
else
.Save
Dim imm(2)
imm(0) = "immagine1"
imm(1) = "immagine2"
for ii = 0 to Ubound(imm)
SQL2="UPDATE catalogo SET "&imm(ii) &"='"&.GetFileName() &"' where codicearticolo = '"&codicearticolo&"'"
conn.Execute(SQL2)
conn.Close
Set conn = Nothing
end if
end if
.MoveNext
Wend
End With
Set oUpload = Nothing
Response.Redirect("home.asp?page=b")
%>