OH! And probably more relevant is that ClassB has various belongs_to relationships, which is what I am trying to get at, actually... those tables that hold those relationships.
On Mar 16, 1:56 pm, Tuishimi <[email protected]> wrote: > 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- Hide quoted text - > > - Show quoted text - -- 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.
