Not every DB supports every CFQueryParam cfsqltype. For instance, I used to use _DATE in MS SQL Server, but then one day it started throwing errors on SQL Server 2005. If you look in the documentation, it will show you how everything maps. _TIMESTAMP is supported by MS SQL Server.
As far as CreateODBCDate() and CreateODBCDateTime()... Not sure how important they are. If you use CFQueryParam, I believe the tag will format things properly for you. I guess you could use CreateODBCDate() if you wanted to pass a Date/time object with zerod out time. But then again, I don't know if there is any advantage to doing that over just formatting the value you pass to the tag. I imagine that CreateODBCDate() type functions are used mainly for databases that do not allow data binding and therefore do not allow CFQueryParam?? More of a backwards compatability thing... But I might be talking out of you know where. ...................... Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -----Original Message----- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Friday, September 22, 2006 4:52 PM To: CF-Talk Subject: Best use for createODBCdate(), cfqueryparam CF_SQL_DATE vs. CF_SQL_TIMESTAMP I was wondering if someone can point out the main differences (advantages/disadvantages of each) between #createODBCdate()#, <cfqueryparam cfsqltype="CF_SQL_DATE"., and <cfqueryparam cfsqltype="CF_SQL_TIMESTAMP". when used on inserts and updates. Thanks in advance. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253926 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4