I have a very simple find call...
@assets = Asset.find(:all, :group => 'asset_type_id', :order => "name")
I have 3 Asset objects in my database, all of which have asset_type_id
equal to 1. Why does this query only return 1 object?
Get a good MySQL book to figure out what's happening. The :group =>
'asset_type_id' call generates the SQL clause "GROUP BY
asset_type_id". Use this when you want a SUMMARY of all the fields
with a particular value of asset_type_id. So for each value of
asset_type_id, you get ONE record. Usually you'll also want a COUNT,
SUM, AVERAGE, or other summary function returned with this record.