On 5/21/07, Mike Chabot <[EMAIL PROTECTED]> wrote: > Perhaps CreateOdbcDate() is what you are after.
I don't agree with this. CreateODBCDate() is only necessary if you're not using cfqueryparam The correct, safe and secure solution is to use <cfqueryparam cfsqltype="cf_sql_date" value="05/22/2007"> or <cfqueryparam cfsqltype="cf_sql_date" value="#CreateDate(2007,05,22)#"> If the data type is actually a timestamp or datetime but you still want all times to be midnight... then use <cfqueryparam cfsqltype="cf_sql_timestamp" value="#CreateDateTime(2007,05,22,0,0,0)#"> Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by AdobeĀ® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278847 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4