RE: [Reactor for CF] Two newly discovered bugs (Trac issues 26 & 27)

[Doug Hughes]

I just committed a fix which addresses a number of alias-related bugs in oo queries.  These were related to the recent rewrite of OO queries.   You can now, sort, filter and join aliased columns correctly.   Doug   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christopher Bradford Sent: Friday, June 16, 2006 1:03 AM To: reactor@reactorframework.com Subject: [Reactor for CF] Two newly discovered bugs (Trac issues 26 & 27)   Just an FYI for the list:   I reported two new bugs with OO queries. The first is that OO query joins are attempting to join on column aliases (which doesn't work even if the aliased column is also selected, let alone when it's not); the second is that returnObjectField/s on an OO query with a join are returning columns with the same names or aliases from all tables in the join, not just the tables specified in the returnObjectField/s call. In MSSQL, this causes the values from the last specified table to be returned, instead of the ones intended. Christopher Bradford Alive! LLP -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --