I typically use CF_SQL_TIMESTAMP or I use CF_SQL_VARCHAR and create the
datetime string myself ('mm-dd-yyyy HH:MM:SS'). Either will work, but
CF_SQL_DATE definitely does not work with the Merant JDBC drivers. This
is on SQL 2000. I haven't tested it with the Microsoft JDBC drivers
though. Perhaps they will handle it better?
Jeff Garza
-----Original Message-----
From: bryan.hogan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 7:39 PM
To: CF-Talk
Subject: Re: <cfqueryparam> and datetime values
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
