Displaying 1 result from an estimated 1 matches for "sites_stock_groups".
2006 Apr 04
1
has_many fails where find_by_sql succeeds
...Base
has_and_belongs_to_many :sites
has_many :sites_not_using_this_stock_group,
:class_name => "Site",
:finder_sql => ''select sites.* from sites
where id not in
(select site_id from sites_stock_groups
where stock_group_id = #{id})
order by id asc''
<snip>
def sites_not_using_this_stock_group
Site.find_by_sql(["select sites.* from sites
where id not in...