Why don't you just let SQL Server insert the time automatically on insert?
"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Matt Robertson To: CF-Talk Sent: Sun Dec 31 22:48:58 2006 Subject: Re: CFLocaleDateFormatException... WTF? I forgot to mention that CreateODBCDateTime(now()) doesn't do the trick either. Just tried your idea and got this: The cause of this output exception was that: coldfusion.runtime.locale.CFLocaleDateFormatException: "{d ''2006-12-31''}" is an invalid date format. I have found a solution but it makes ZERO sense: Give up on cfqueryparam and do a raw insertion. If I do that the db will accept both #now()# and #CreateODBCDateTime(now())# with similarly corrrect results in a Sql Server datetime field. Which points to cfqueryparam, which in turn points to java/jdbc? How can this happen? While its not the end of the world to do without cfqueryparam in this instance, I really don't like to 'go bare' like this. Especially for something so apparently bizarre. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com On 12/31/06, Claude Schneegans <[EMAIL PROTECTED]> wrote: > How about > > <cfqueryparam value="#createODBCDate(now())#" cfsqltype="CF_SQL_DATE"> > > -- > _______________________________________ > REUSE CODE! Use custom tags; > See http://www.contentbox.com/claude/customtags/tagstore.cfm > (Please send any spam to this address: [EMAIL PROTECTED]) > Thanks. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 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:265446 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
