Dates aren't supposed to be in quotes. Remove the single quotes and that
should work. If its a column, like date_created, that should always have
the time it was created, then I'd just add the value to the default on
that column in the database. For mssql, you can set the default to
getdate() and it will take care of the work for you.
Judah
Richard Colman wrote:
> This yields an INCORRECT SYNTAX error:
>
> '#updatecustomer_result.sql#',
> 79 : '#session.lname#',
> 80 : '#createodbcdatetime(now())#')
> 81 : </cfquery>
> 82 :
> ------------------------------------------------------------------------
> --------
>
> SQL insert into ... '{ts '2007-01-23 14:54:41'}')
>
>
> -----Original Message-----
> From: Richard Cooper [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 23, 2007 1:39 PM
> To: CF-Talk
> Subject: Re: Inserting current date into a data table
>
> typo:
> replace this bit (date)
> with (now())
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267395
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
