Hi all!
Mi name is Mauricio Olivera and I'm writting from Argentina.-
I have a problema with a query join and its Select.ยด I'm trying to do this:
$DB[:mentor_questions].select_all(
*:mentor_questions.*
:mentor_questions__created.as('date'),:mentors.*,:users__username.as('username'),:business_types__name.as('business_type_name')
*
).join(
:mentors, :mentors__id=>:mentor_questions__mentor_id
).join(
:users, :users__id => :mentor_questions__user_id
).join(
:business_types,
:business_types__id=>:users__business_type_id
).grep(
[:users__username,:mentor_questions__created,:business_types__name,:mentors__first_name,:mentors__last_name,:mentors__skills],"%#{params[:search]}%",:case_insensitive=>true
).paginate(page,$row_by_pages) || Hash.new()
The problem is what .* and .as('') return error as " it isn't a method of
sequel"
Can someone helpe me or help me about this problem?
Thanks
Mauricio
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/groups/opt_out.
