R
ree
For some reason I can't pin point, it is just bugging me like hell.
<%
dim strQuery
strQuery = "UPDATE Gifts SET"
strQuery = strQuery & " GuestSelected = " & cint(guestID)
strQuery = strQuery & ", DateSelected = " & Now()
strQuery = strQuery & " WHERE GiftID = " & selectGiftID' &
";"
Line 47 -> conn.Execute(strQuery)
%>
Error message
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression '21/10/2003 12:19:31 AM'.
/selectGift.asp, line 47
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Page:
POST 8 bytes to /selectGift.asp
POST Data:
GiftID=5
Time:
Tuesday, 21 October 2003, 12:19:31 AM
Thanks
<%
dim strQuery
strQuery = "UPDATE Gifts SET"
strQuery = strQuery & " GuestSelected = " & cint(guestID)
strQuery = strQuery & ", DateSelected = " & Now()
strQuery = strQuery & " WHERE GiftID = " & selectGiftID' &
";"
Line 47 -> conn.Execute(strQuery)
%>
Error message
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression '21/10/2003 12:19:31 AM'.
/selectGift.asp, line 47
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Page:
POST 8 bytes to /selectGift.asp
POST Data:
GiftID=5
Time:
Tuesday, 21 October 2003, 12:19:31 AM
Thanks