Yeah, is the field you are passing the date to a DATE or a TIMESTAMP. If using TIMESTAMP you are on Oracle 9.2 or greater. A TIMESTAMP is certainly not a DATE. So use the appropriate cf_sql_type. Also, IIRC in my experience, using bind vars with CF, I don't need to use TO_CHAR or TO_DATE in my SQL or PL/SQL. You may need to use CreateDate() in CF though, can't just pass in a string literal.
DK On 2/24/06, Deanna Schneider <[EMAIL PROTECTED]> wrote: > Try using cf_sql_timestamp instead of cf_sql_date and see if that makes a > difference. > > On 2/24/06, vishnu prasad <[EMAIL PROTECTED]> wrote: > > > > Hi Tried the code u sent , i got the below error > > "17-jan-2005" is an invalid date format. > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233361 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
