It's not clear to me how ActiveRecord is supposed to be used to update a batch of records w/o actually loading them.
IOW I want to execute an UPDATE statement something like this:
UPDATE database.table SET rcrd_status='N' WHERE rcrd_status='Y' AND foreign_id='abcdefg';
find_by_sql seems to be the only way to talk to the db directly, but this process has nothing to do with finding.
Also, is there a way to retrieve db & tbl names so they don't have to be hard coded into such a query?
-- gw (www.railsdev.ws)