The find's :select option is ignored when you combine it with the :include option.
On Apr 16, 8:58 pm, Scott Kulik <rails-mailing-l...@andreas-s.net> wrote: > i'm a little confused here on what's happening. > > i have two tables ITEMS and ITEM_TYPES > > ITEMS (belongs_to :item_type) > id > name > item_type_id > > ITEM_TYPES > id > name > > here is my Item.rb model code for my query: > > find(:all, > :select => 'items.name, item_types.name', > :include => :item_type, > :conditions => ['item_types.name = ? OR item_types.name = ? OR > item_types.name = ? OR item_types.name = ?', 'Material', 'Weapon', > 'Armor', 'Accessory'], > :order => 'items.name') > > currently it is selecting all fields in the ITEM table and not using the > :select that i have entered. > > if i comment out the :conditions parameter the :select works properly. > i'm sure it's something to do with the linking to the item_types table. > does anyone know how i can get the above :select working properly? > > thanks! > -- > Posted viahttp://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@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---