Has_many with nullable foreign_key?

Rails
1

Is there a way to use has_many and have it operate like such?

select * from pages where site_id = #{id} or site_id is null

I know there’s finder_sql, but then I’ll lose the find_in_collection
goodness.

Thanks,
Joe

2

something like:

@pages = Page.find :all, :conditions => [“site_id = ? OR site_id is
NULL”,id]

:conditions takes a string for the SQL WHERE condition. The array i use
there, handles the espacing of the “id” value to prevent SQL injection,
and then replaces “?” with the escaped value of id…