Has anyone else noticed that CFMX7 now casts a date column as date time in queries? Or is it just a Monday and I have not recovered from the weekend? When I run a query to get one record <cfquery name="getbuilds" datasource="#database#"> SELECT StartDate, RecordId, RecordDate FROM BuildsData where recordid = 1 </cfquery> The query returns #getbuilds.StartDate# = 2005-01-26 00:00:00.0 <cfset foo = querysetcell(getbuilds,'StartDate',DateFormat(getbuilds.StartDate, "mm/dd/yyyy"))> Even after the querysetcell #getbuilds.StartDate# = 2005-01-26 00:00:00.0 Can anyone tell me how / if I can make CFMX7 return non typed columns? The funny thing is, this was a feature I was hoping MM would add. I just did not know it would cause problems with my legacy code. MB Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com <http://www.vividmedia.com/> 608.270.9770
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201411 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