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:333603 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
