reactor  

[Reactor for CF] Field not found if aliased when joining

bayo
Fri, 05 Jan 2007 12:42:40 -0800

Is this a bug?

It seems when you do a join, you cannot order on a
field that has been aliased.  When I try to do so,
neither the field's original name nor it's alias is
found by Reactor in the object the field belongs.  But
the error is only thrown if I attempt to order by
either name.  Otherwise, the query returns a recordset
with the correct field name.

Anyone encountered this before?

Thanks.
B.



-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
reactor@doughughes.net
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

  • [Reactor for CF] Field not found if aliased when joining bayo