Right, my understanding is that cfqueryparam will take care of making sure the db gets the date as it expects it. If I'm not wrong, you should just ditch the CreateObdcDateTime call.
Dominic 2009/10/27 Claude Schneegans <schneeg...@internetique.com> > > >>wrap dateformat() around the dateadd() function. > > NO. createOdbcDate expects a date value as a parameter. > One should never submit a formated date to this function, > the date will be de-formated anyway, with the risk that the format is > not compatible > (ie: european date format). > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327761 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
