Forums

This topic is locked

Missing Expression

Posted 04 Jul 2003 00:49:04
1
has voted
04 Jul 2003 00:49:04 Serge Khachatour posted:
Can someone please help me <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
&lt;%
If (CStr(Request("MM_insert") = "CreateMsg" Then
set cmdInsertMsg = Server.CreateObject("ADODB.Command"
cmdInsertMsg.ActiveConnection = MM_connect_STRING
cmdInsertMsg.CommandText = "INSERT INTO SCOTT.MESSAGES (MESSAGEID, MOBILENUM, SUBJECT, MESSAGE, SENDDATE) VALUES (" & hdnMsgID & ", " & hdnMobileNum & ", " & txtSubject & ", " & txtMessage & ", TO_DATE(" & hdnDateTime & ", 'MM/DD/YYYY'))"
cmdInsertMsg.CommandType = 1
cmdInsertMsg.CommandTimeout = 0
cmdInsertMsg.Prepared = true
cmdInsertMsg.Execute()
Response.Redirect("ControlPanel.asp"
End If
%&gt;
When i run this, I get MISSING EXPRESSION

Reply to this topic