> Well, considering that the SQL standard says that a date is formatted as > 10 positions in the format yyyy-mm-dd I would not call it is magic.
Deep in my misty memory I was taught that when using CF and Oracle, dates needed to be formatted as DD-MMM-YYYY. Looking at it now, it's probably the third-party driver that allowed us to send dates in that format as strings and would automagically convert them to dates. With CF5 and the Oracle driver that came with it doesn't do that. At least, that's my theory du jour. I thought, however, that CFQUERYPARAM would take any date object in the value. Formatting shouldn't have anything to do with it. At least that's how it appears to work in CF5. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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.
