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
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_Documentationfile=0317.htm
..
Ben Nadel
Certified Advanced ColdFusion Developer
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 is where you can see what DB's support which CF_SQL_
: RE: Best use for createODBCdate(), cfqueryparam CF_SQL_DATE vs.
CF_SQL_TIMESTAMP
Thanks Ben. I've been using both createOBDC... and cfqueryparam... on
mySQL/JDBC and have not encountered a problem- which actually lead to
this thread. If both are OK, then which is better. Thanks for
mentioning
4 matches
Mail list logo
