Tony, The application where this is used needs to be keep generic and needs to be able to accept many different types of data.
This "application" is one part of an in-house system "smartVar UDF", I wrote to really simplify the creation of the many "CRUD" (CreateReadUpdateDelete) pages I make. (I think you an I have traded mails about this in the past) So what my UDF does is it looks for the value of the input, first in a form var, then in a query var. If neither the form OR query contain a value for the input box then it is just blank. Also, since the form submits to its self then it will pull the value from the form and not the query after you submit the page. Does that help explain it it? I *think* the new CFMX7 CFinputs have some of this functionality. MB Thanks! 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 2:41 PM To: CF-Talk Subject: Re: CFMX7 Now casts query columns as datetime? 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 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:201430 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
