On Mar 16, 2011, at 4:35 PM, Tuishimi wrote:
> Hi Matt, not working for me. Is this a rails 3.0 thing with hobo, or
> should an older version work as well?
>
> I get basically the same error I was getting before. I will paste it
> here but I have to obfuscate the names a bit...
>
> OCIError: ORA-00904: "XXXXXXXXXX_TYPES"."NAME": invalid identifier:
> select * from (SELECT * FROM "XXXXXXXXXX_VALUE_DETAILS" WHERE
> ("XXXXXXXXXX_VALUE_DETAILS".XXXXXXXXXX_value_file_id = 10005) ORDER
> BY XXXXXXXXXX_types.name ASC) where rownum <= 20
>
It looks like the table you're trying to sort by isn't getting :included to the
query; can you post the chunk of your controller that's generating this SQL?
I *believe* this should work on Rails 3, but the code I sent was lifted from a
Hobo 1.0 app.
--Matt Jones
--
You received this message because you are subscribed to the Google Groups "Hobo
Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/hobousers?hl=en.
