Additional question...  I'm aware of the data validation done by
cfqueryparam, but does it also insulate the developer from the type of
datasource?  For instance, if developing an application for both ODBC
datasources and native connections to DBMSs like Oracle and MS SQL, does
using

mycolumn = <cfqueryparam cfsqltype="cf_sql_date"
value="#somedatevariable#">

instead of

mycolumn = #CreateODBCDate(somedatevariable)#

make the code somewhat universal?

----- Original Message -----
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, July 29, 2004 5:39 PM
Subject: cf_sql_date

> Will the following create a value with or without a 'time' portion?
>
> <cfqueryparam cfsqltype="cf_sql_date" value="#Now()#">
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to