codice:
<%
If Request.querystring("mode") = "postdb" then
strUserName = Session("userName")
strHeading = Request.Form("txtHeading")
strContent = Request.Form("txtContent")
inizio = Request.Form("inizio")
fine = Request.Form("fine")
tipoNews = Request.Form("tipoNews")
userAdmin = Session("userAdmin")
strHeading = fieldReplace(strHeading)
strContent = fieldReplace(strContent)
dim imgOk
if userAdmin = 2 then
Attiva = 0
else
Attiva = 1
end if
if Session("FileDoc") <> "" then
strSQL = "INSERT INTO tblnews (heading,content,postedby,[Timestamp], [idUser], [img], [LinkDocumentazione], [attiva], [inizio], [fine], [tipo])VALUES('" & strHeading & "','" & strContent & "','" & strUserName & "','" & date() & "'," & Session("userID") & ", 1," & "'" & Session("Filedoc") & "'," & Attiva & ", #" & inizio & "#,#" & fine & "#," & tipoNews & ")"
else
strSQL = "INSERT INTO tblnews (heading,content,postedby,[Timestamp], [idUser], [img], [attiva], [inizio], [fine], [tipo])VALUES('" & strHeading & "','" & strContent & "','" & strUserName & "','" & date() & "'," & Session("userID") & ", 1," & Attiva & ", #" & inizio & "#,#" & fine & "#," & tipoNews & ")"
end if
response.write(strsql)
adoCon.BeginTrans
adoCon.Execute(strSQL)
Set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT @@IDENTITY As NewId;"
rs.Open strSQL, adoCon
AdoCon.CommitTrans
'Allego immagine se necessario...
if Session("FileUp") <> "" then
if Session("imgServer") = "pc" then
Set FSO = CreateObject("Scripting.FileSystemObject")
Upload1 = True
DimensioneFile1 = len(ContenutoFile)
EstensioneFile1 = right(ContenutoFile,3)
NomeFile1 = NomeFile
Set textStream = FSO.CreateTextFile("e:\users\utente\miosito.it\imgNews\" & rs("NewId") & ".jpg", True, False)
textStream.Write Session("FileUp")
textStream.Close
Session("FileUp") = ""
end if
if Session("imgServer") = "server" then
Set FSO = CreateObject("Scripting.FileSystemObject")
FSOsorgente = Cstr(Session("FileUp"))
FSODestinazione = "e:\users\utente\miosito.it\imgNews\" & rs("NewId") & ".jpg"
'Response.Write("da: " & FSOsorgente & " a: " & Cstr(FSODestinazione))
FSO.CopyFile Cstr(FSOsorgente), Cstr(FSODestinazione), true
end if
Session("imgServer") = "none"
Session("FileUp") = ""
dim estensioneImmagineUP
Set textStream = Nothing
Set FSO = Nothing
end if
Set adoCon = Nothing
Set rs = nothing
Response.Redirect"news.asp?mode=listnews"
End If
If Request.querystring("mode") = "delete" then
strID = Clng(request.querystring("ID"))
strSQL = "DELETE FROM tblnews WHERE ID =" & strID
adoCon.Execute(strSQL)
Set adoCon = Nothing
Response.Redirect"news.asp?mode=listnews"
End If
%>