On Sun, Oct 26, 2008 at 10:21 AM, Fernando Perez
<[EMAIL PROTECTED]> wrote:
> :joins => ['LEFT OUTER JOIN orders ON (items.order_id = orders.id AND
> orders.user_id = ?', params[:id]]
Placeholders are not supported there indeed.
You cannot work with regular AR association API calls right? For example:
# untested
user = User.find(params[:id])
items = user.orders.map(&:items).flatten.uniq
or say:
# untested
items = Item.all(
:conditions => {'users.id' => params[:id]},
:joins => {:order => :user}
)
If not, you can still extract an integer from params[:id] and safely
interpolate. That's easy with Integer() or #to_i.
-- fxn
--~--~---------~--~----~------------~-------~--~----~
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 [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---