Displaying 1 result from an estimated 1 matches for "status_status".
Did you mean:
status_stats
2006 Jan 31
2
find_by_sql question
...rs << "crs.deleted_at IS NOT NULL" # THIS DOES NOT WORK
filters = ''WHERE '' + filters.join('' AND '') unless filters.empty?
direction = ''DESC'' unless %w{ASC DESC}.include? direction
find_by_sql %{SELECT crs.*,
status.status AS status_status
FROM crs
LEFT OUTER JOIN status on status.id = crs.status_id
#{filters.to_s unless filters.empty?}
ORDER BY crs.#{order_by} }
end
--
Posted via http://www.ruby-forum.com/.