Hove you tried inserting #now()# or do a <cfset
newdate="#CreateODBCDate(Now())#"> then insert '#newdate#'?? I have
sometimes had trouble with inserts if i try to manipulate the variable
within the insert insead of doing it before. Let me know?
Alex
----- Original Message -----
From: "Geoff Hoffman" <[EMAIL PROTECTED]>
To: "SQL" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, April 13, 2001 12:59 PM
Subject: Re: INSERT INTO (access mdb table) PROBLEM
> >
> >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
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
