Microsoft JET Database Engine error '80040e14'
I got this error above when I try my script!!! Wat is missing the full error i got is this
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression ''stress stress stress. i'm going crazy liao','11/12/2004 7:33:29 AM', false)'.
/revolnip/Discussion/pm.asp, line 48
What is my missing operator??? where???
Below is my script, can someone help this is urgent!!!
<% Option Explicit
dim lngTimer
lngTimer = Timer
%>
<% Dim ERRORMSG, i, recip, content, topic, POST_HTML, POST_BB, POST_SMILIE, POST_IMG
if not intUID = 0 then Conn.Execute("UPDATE [Users] SET [LastActivePlace] = ""pm.asp?mode=" & Request("mode") & """, [LastLoggedIn]= now()+0.5, [IP] = '" & GetIP & "' WHERE [uID]=" & intUID)
dim del
del = Request("Delete")
if del <> "" then 'if user wants to delete a PM
Conn.Execute("DELETE FROM [PM] WHERE pmID = " & del & " AND Recipient = " & intUID)
response.redirect "pm.asp?Message=Deleted+A+Message+Sucsessfully "
end if
%>
<%
dim Recipient, postSubject, postContent
Recipient = Request("Recipient")
postSubject = Request("Title")
postContent = Request("Content")
if len(postSubject) > 50 then postSubject = left(postSubject, 47) & "..."
if Recipient <> "" and Request("post") = "now" and intUID <> 0 then 'would otherwise cause errors if the form hadn't been submitted - i.e. on first page load
Set rsUserFind = Conn.Execute("SELECT uID,uName FROM Users WHERE uName = '" & Recipient & "'")
if rsUserFind.eof then
ERRORMSG = "Can't find username"
else
Recipient = rsUserFind("uID")
if postSubject = "" then postSubject = "[ No Title ]"
POST_HTML = false
POST_BB = true
POST_SMILIE = true
POST_IMG = true
%>
<%
end if
end if
if Request("Post") = "now" and ERRORMSG = "" then
Conn.Execute("INSERT INTO [PM] ([Recipient],[Sender],[pmTitle],[Message],[SentDate],[Read]) VALUES (" & Recipient &_
"," & intUID & ",'" & postSubject & "','" & postContent & "','" & now()+0.5 & "', false)")response.redirect "pm.asp?Message=Sent+PM+To+" & Request("Recipient")
end if
%>
Highlighted green is where the error is.
|
