>
>Put single quotes around your DATE variables.
>
>Alex
ALEX,
thanks but it still fails. I have other queries on other pages (such
as UPDATE instead of INSERT INTO) that have no problem inserting
dateTime data without single quotes, and without #CreateODBCDate(Now())#
either.... strange. In fact, in my previous post, the #temp.date#
fields are coming from a query that previously put the dateTime values
into another table, so I know that it does work. It must be something
else.
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT
INTO statement.
SQL = "INSERT INTO content(guid, type_id, client_id, user_id, logdate,
birthdate, expirationdate) VALUES('3AN1FPEA', 1, 2, 1, '{ts '2001-
04-13 11:58:03'}', '{ts '2001-01-01 00:00:00'}', '{ts '2099-12-31
23:59:59'}');"
Geoff Hoffman
[EMAIL PROTECTED]
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
