RE: Best use for createODBCdate(), cfqueryparam CF_SQL_DATE vs. CF_SQL_TIMESTAMP

2006-09-22 Thread Ben Nadel
, as I'm sure it's a consideration when writing modular apps. > -Original Message- > From: Ben Nadel [mailto:[EMAIL PROTECTED] > Sent: Friday, September 22, 2006 2:02 PM > To: CF-Talk > Subject: RE: Best use for createODBCdate(), cfqueryparam CF_SQL_DATE vs. > CF_SQL_T

RE: Best use for createODBCdate(), cfqueryparam CF_SQL_DATE vs. CF_SQL_TIMESTAMP

2006-09-22 Thread Michael E. Carluen
writing modular apps. > -Original Message- > From: Ben Nadel [mailto:[EMAIL PROTECTED] > Sent: Friday, September 22, 2006 2:02 PM > To: CF-Talk > Subject: RE: Best use for createODBCdate(), cfqueryparam CF_SQL_DATE vs. > CF_SQL_TIMESTAMP > > PS. > > Here

RE: Best use for createODBCdate(), cfqueryparam CF_SQL_DATE vs. CF_SQL_TIMESTAMP

2006-09-22 Thread Ben Nadel
PS. Here is where you can see what DB's support which CF_SQL_ http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/comm on/html/wwhelp.htm?context=ColdFusion_Documentation&file=0317.htm .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.

RE: Best use for createODBCdate(), cfqueryparam CF_SQL_DATE vs. CF_SQL_TIMESTAMP

2006-09-22 Thread Ben Nadel
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 Create