Would like to use ActiveRecord find for multiple table lookups with sort
order on parent table.
Example: Item table belongs to Category and Section tables. Category and
Section tables have only 2 attributes: id, text field (category and
section). Item has many attributes in addition to category_id &
1. Sort items by category or section TEXT field not the id fields.
2. Be able to update the Item attributes but not category or
A. Use find_by_sql?
B. Use find and ":include" option.
C. Use ":from" option to refer to an SQL view of the joined tables?
i. Then switch to an updatable Item form?
D. Use some other approach?
Sugar Creek, Missouri
The "Show Me" state.