really? what kind of application? one that doesnt do it on the other side? basically when you hand it off from cf to "the other application" it just looks at it, and cant format it for itself?
tony On Apr 4, 2005 3:24 PM, Mark W. Breneman <[EMAIL PROTECTED]> wrote: > > Hey Tony, > > Your suggestion on casting it as a varchar works well. Thanks! > > This causes problems for me where I want to apply date formatting to a query > column. Yes, I know applying a date format in a query result is a > "different" way of doing it. But, I have application where it is required. > > Thanks again. > > Mark W. Breneman > -Cold Fusion Developer > -Network Administrator > Vivid Media > [EMAIL PROTECTED] > www.vividmedia.com > 608.270.9770 > > -----Original Message----- > From: Tony Weeg [mailto:[EMAIL PROTECTED] > Sent: Monday, April 04, 2005 1:42 PM > To: CF-Talk > Subject: Re: CFMX7 Now casts query columns as datetime? > > 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 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201426 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
