Perhaps a stupid question...but have you double-checked the SQL data type of the column in question? Is it, perhaps, a varchar instead of a datetime?
On Wed, May 12, 2010 at 9:34 AM, Mike Kear <[email protected]> wrote: > > Ok here's a puzzle. I changed my insert query, and now it's changed the > way the date is stored. Does anyone know if this is a bug? > > For example if I have this in the insert query: > > <cfqueryparam value="#PLUTotal.getdateentered()#" > cfsqltype="CF_SQL_TIMESTAMP" />, > > then the date is stored in the American format of '2010-31-03 00:00:00' > > But if i get rid of the CFQUERYPARAM and have the same info inserted as > follows; > > #createodbcdate(PLUTotal.getdateentered())#, > > then the date shows in a query as ''2010-03-31 00:00:00' > > So . the solution for my issue is to do away with CFQUERYPARAM at least for > date fields in insert/update queries. But why would that make this > difference? > > Cheers > Mike Kear > Windsor, NSW, Australia > Adobe Certified Advanced ColdFusion Developer > AFP Webworks > http://afpwebworks.com > ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333604 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
