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]

Reply via email to