vad är det MySQL inte gillar i denna sql?
<!-- #include virtual="/include/dbconn.asp" -->
<!-- #include virtual="/include/functions.asp" -->
<%
Dim objConn, SQL, bSQL, updateSQL
Dim userID,varSender, varReciever,varHeadline,varMessage, varDatum
Dim txtSender, txtReciever, txtHeadline,txtMessage, txtDatum
varSender = FriendlySQL(Request.Form ("txtSender"))
varReciever = FriendlySQL(Request.Form ("txtReciever"))
varName=request("toUser")
varMailID = FriendlySQL(Request.Form ("txtMailID"))
varDatum = FriendlySQL(Request.Form ("txtDatum"))
varHeadline = FriendlySQL(Request.Form ("txtHeadline"))
varTime = Time()
varString = Session("username") & " skrev: <br>"
varMessage = FriendlySQL(Request.Form("txtMessage"))
varMessage1 = varString & varMessage
SET objConn = connect()
SQL = "INSERT INTO tblUsers_imail"
SQL = SQL & "(sender, reciever, Headline,message, mailDate,mailTime, mailRead) "
SQL = SQL & "VALUES('"& varSender &"','"& varReciever &"','"&varHeadline &"','"&varMessage &"','"& varDatum &"#,'& varTime &"', 1)"
bSQL = "INSERT INTO tblUsers_imail_backup"
bSQL = bSQL & "(sender, reciever, Headline,message, mailDate,mailTime, mailRead) "
bSQL = bSQL & "VALUES('"& varSender &"','"& varReciever &"','"&varHeadline &"','"&varMessage &"','"& varDatum &"','"& varTime &"',1)"
cSQL = "INSERT INTO tblUsers_imail_reply"
cSQL = cSQL & "(sender, reciever, Headline,message, mailDate,mailTime, mailRead) "
cSQL = cSQL & "VALUES('"& varSender &"','"& varReciever &"','"&varHeadline &"','"&varMessage &"','"& varDatum &"','"& varTime &"', 1)"
'response.write SQL
'response.end
objConn.Execute(SQL)
objConn.Execute(bSQL)
objConn.Execute(cSQL)
response.redirect "mail-sent.asp?toUser="&varName&"&userID="&varReciever&""
%>