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