Rails - Sep 2010 - :select with find_in_batches

How can I include a :select clause with find_in_batches. The following
throws an error " Mysql::Error: Unknown column ''users.id''
in ''field
list'': .

    Post.find_in_batches(:batch_size => 100, :select => "users.id,
users.name, categories.name, posts.id", :include =>
[:user, :category]) do |group|
    #stuff with group
    end

-- 
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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

On Sep 8, 2:30 am, badnaam
<asitkmis...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> How can I include a :select clause with find_in_batches. The following
> throws an error " Mysql::Error: Unknown column
''users.id'' in ''field
> list'': .
If you want joins use :joins rather than :include

Fred
>
>     Post.find_in_batches(:batch_size => 100, :select =>
"users.id,
> users.name, categories.name, posts.id", :include =>
> [:user, :category]) do |group|
>     #stuff with group
>     end
-- 
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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.