Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166617
---
Hi


Since upgrading to MX 6.1 the following date lines are not working, the
error returning is

Error Executing Database Query.

[Macromedia][Oracle JDBC Driver][Oracle]ORA-01843: not a valid month


This is an example of two of the date lines I am using


<cfset formatted_date1 = dateformat(createodbcdate(startdate),
"dd/mm/yyyy")>


------------------------------------


WHERE startdate <= #createodbcdate(formatted_date)#

How do you solve this in CF6.1 by using CFQUERYPARAM ? or the to_date
function in Oracle ?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to