> 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.St > artDate, > "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. I thought it had been this way since at least CF5... With the advent of Query of Query they needed some way to identify the type of data in columns for aggregation like sum() and max(). Though in general, I've always interpreted the contents of a query as being authoritative, unformatted values. So for instance, I would never want a query to contain a date in the format "mm/dd/yyyy", and even if it coincidentally did hold the data in the desired format, would never display the query value without first formatting it. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/author/?id=4806 http://www.fusiontap.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:201432 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
