CFMX7 Now casts query columns as datetime?

2005-04-04 Thread Mark W. Breneman
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 SELECTStartDate, RecordId, RecordDate FROM BuildsData where recordid = 1 The query returns

Re: CFMX7 Now casts query columns as datetime?

2005-04-04 Thread Tony Weeg
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 > quer

Re: CFMX7 Now casts query columns as datetime?

2005-04-04 Thread Jim Davis
>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 an

RE: CFMX7 Now casts query columns as datetime?

2005-04-04 Thread Mark W. Breneman
. 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

RE: CFMX7 Now casts query columns as datetime?

2005-04-04 Thread Mark W. Breneman
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 CFM

Re: CFMX7 Now casts query columns as datetime?

2005-04-04 Thread Tony Weeg
MAIL 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 prob

RE: CFMX7 Now casts query columns as datetime?

2005-04-04 Thread Mark W. Breneman
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

Re: CFMX7 Now casts query columns as datetime?

2005-04-04 Thread S . Isaac Dealey
> 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 > > SELECTStartDate, RecordId, RecordDate > FROM BuildsData > where recordid = 1 > > T

Re: CFMX7 Now casts query columns as datetime?

2005-04-04 Thread Sean Corfield
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