Thanks Ray, that's what I forgot.
Humbly going back into my hole. :)
Bryan
-----Original Message-----
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 11:09 AM
To: CF-Talk
Subject: RE: CFMX 6.1 New Query Bug
This isn't a bug. I believe when you call a func on a column, the db
_itself_ renames the column. I think you are supposed to d
select foo, func(moo) as whatever
then use queryname.whatever. I'm not sure if this is specific to one db,
or maybe it's just CF, but I know whenever I do a func on a column, I
use "as".
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- CFMX 6.1 New Query Bug Bryan F. Hogan
- RE: CFMX 6.1 New Query Bug Raymond Camden
- RE: CFMX 6.1 New Query Bug Bryan F. Hogan
- RE: CFMX 6.1 New Query Bug Pascal Peters
- RE: CFMX 6.1 New Query Bug Douglas.Knudsen