CFMX7 Now casts query columns as datetime?
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# SELECTStartDate, 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/)) 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
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# SELECTStartDate, 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/)) 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
Re: CFMX7 Now casts query columns as datetime?
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? I'm not positive, but I would guess that's how your database driver is returning them, not CF. Perhaps it was a change in drivers between 6.1 and 7 but CF itself doesn't really have anything to do with this (although I could be wrong). Jim Davis ~| 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:201415 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
RE: CFMX7 Now casts query columns as datetime?
I can verify that it is CF that is doing this. In CFMX (6) you could set any query cell to any value. In CFMX 7 it looks that CFMX uses typed columns. You can not use querysetcell to format a date in the mm/dd/ format, if the query is returning a date column. Anyone else see this? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Monday, April 04, 2005 1:52 PM To: CF-Talk Subject: Re: CFMX7 Now casts query columns as datetime? 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? I'm not positive, but I would guess that's how your database driver is returning them, not CF. Perhaps it was a change in drivers between 6.1 and 7 but CF itself doesn't really have anything to do with this (although I could be wrong). Jim Davis ~| 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:201420 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
RE: CFMX7 Now casts query columns as datetime?
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# SELECTStartDate, 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/)) 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 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201423 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
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# SELECTStartDate, 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/)) 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
RE: CFMX7 Now casts query columns as datetime?
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# SELECTStartDate, 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/)) 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
Re: CFMX7 Now casts query columns as datetime?
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# SELECTStartDate, 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/)) 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/, 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
Re: CFMX7 Now casts query columns as datetime?
On Apr 4, 2005 12:20 PM, Mark W. Breneman [EMAIL PROTECTED] wrote: I can verify that it is CF that is doing this. In CFMX (6) you could set any query cell to any value. In CFMX 7 it looks that CFMX uses typed columns. Yes, one of the changes in CFMX 7 is to make more use of query metadata so I expect that is what's causing this - the query now 'knows' that the column is a date and won't let you mess with it. That's why Tony's suggestion works (it tells CF the column type is varchar instead). -- Sean A Corfield -- http://corfield.org/ Team Fusebox -- http://fusebox.org/ Got Gmail? -- I have 50, yes 50, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:201456 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
