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:267394
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
