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
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
>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
. 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
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
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
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
> 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
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
9 matches
Mail list logo