I tend to agree unless you are developing an application that the database platform may vary. Then I would use the
<CFQUERYPARAM CFSQLTYPE="CF_SQL_TIMESTAMP" VALUE="#CreateODBCDateTime(Now())#"> -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 23, 2007 7:33 PM To: CF-Talk Subject: RE: Inserting current date into a data table > Fair enough, although I believe that this is true only if the query is > used in a loop. No, bind parameters can provide performance benefits if the query is rerun later. > In this particular instance, though, I would use the sqlserver > function getdate() instead of a CF expression anyway. Each to their > own. I agree, that's the best recommendation if you don't mind a little T-SQL dependency. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:267406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
