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
-~----------~----~----~----~------~----~------~--~---

Reply via email to