Hi all,
Can anyone find the syntax error in this query I'm trying to run? Here is the query followed by the error I'm getting. (the gbdate field in the database has a field type of date/time):
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:65).
Can anyone find the syntax error in this query I'm trying to run? Here is the query followed by the error I'm getting. (the gbdate field in the database has a field type of date/time):
Code:
<cfquery name="addcomments" datasource="mydb" dbtype="ODBC">
INSERT INTO guestbook (gbname, gbemail, gbhomepage, gbcity, gbstate, gbcountry, memocomments, gbdate)
VALUES ('#form.gbname#', '#form.gbemail#', '#form.gbhomepage#', '#form.gbcity#', '#form.gbstate#', '#form.gbcountry#', '#form.memcomments#', #CreateODBCDateTime(Now())#
</cfquery>ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:65).