cast it as a non-date column, varchar? then it will come to cf as a varchar and not a date.
not sure why this would be a problem either way? tw On Apr 4, 2005 2:21 PM, Mark W. Breneman <[EMAIL PROTECTED]> wrote: > 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:201413 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
