Yes, I have. I have not found a solution, but here is the setup. If one has a datetime column in sql 7.0 and use <cfqueryparam> with a date type CF returns something to the affect of the chosen option requires a non default setup of sql 7. I have not tried it yet on 2000
---------- Original Message ---------------------------------- From: Jochem van Dieten <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 06 Feb 2003 00:44:18 +0100 [EMAIL PROTECTED] wrote: > Has any one else had a problem where the time value is not recorded when > using <cfqueryparam> and a date and time value? I haven't. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
