I am taking advantage of a relationship, so my lookup rolls like this:
Where ClassA has a has_many :ClassB...
@class_a = ClassA.find(key)
@class_bs = @class_a.class_bs.apply_scopes(
:search => [params[:search], :id, :x_id,
'xxxxxxxxxx_types.name'],
:order_by => @order
).paginate(...)
Does this help at all? During the display process, rails/hobo
performs additional look ups to process fields="xxxxxxxxxx_type.name",
for example.
On Mar 16, 1:47 pm, Matt Jones <[email protected]> wrote:
> 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.
