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><%
If (CStr(Request("MM_insert"


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
%>
When i run this, I get MISSING EXPRESSION