I've reproduced this locally in one of my own applications. The bug is in the handling of ORDER BY clauses. If you have setAsc("someAlias"), the node that is created does not have a fieldName key, only a fieldAlias key. This comes from a gw.getAll("someAlias") call. I'm still trying to dig into the root cause but maybe that information will be enough to get someone else there faster than me...

On 6/12/06, Joshua Scott <[EMAIL PROTECTED]> wrote:
All,
 
After doing some more testing here are the details of the bug I am having with the Reactor Blog sample app. I am on MySQL5.
 
When I log in to add an entry I get the following error:
 
Message Error Executing Database Query.
Detail Column not found: Unknown column 'category.name' in 'order clause'



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

Reply via email to