First, let me just say "YES, I KNOW, I SHOULD BE USING WILL PAGINGATE
INSTEAD".
Now, with that out of the way, and assuming that I have some reason
(stubornness, laziness, whatever) to keep using paginate on this old
project in 1.2 rails...
I''m trying to set up my conditions with a "joins" parameter.
I have a
join table which follows the active record expectation for a habtm
association, which is unfortunately inconsistent pluralization wise with
a regular table name. the join table is called "events_owners", so it
is plural and that seems to screw things up with the conditions.
Here''s my code right now...
@events_for_reports_pages, @events_for_reports = paginate :events,
:joins => :events_owners,
:conditions => [ "events_owners.owner_id=?" , @owner.id
],
:order => :created_at,
:per_page => 50
Here''s the error I get back:
Mysql::Error: Unknown column ''events_ownerss.owner_id'' in
''where
clause'': SELECT count(*) AS count_all FROM events events_owners WHERE
(events_ownerss.owner_id=1)
Any ideas? I think it is because the events_owners table is pluralized,
where as a normal table isn''t, but maybe it is something else.
thanks,
jp
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---