Never mind. It's not AS related though the problem started to happen after AS is used.
Thanks, ZhangInSeattle On Feb 6, 8:20 pm, ZhangInSeattle <[email protected]> wrote: > Hi, > > I have a model like this: > > class State < ActiveRecord::Base > has_and_belongs_to_many :adjacencies, > :join_table => > "adjacencies", > :class_name => "State", > :association_foreign_key > => "adjacency_id", > :conditions => { :status > => 'active'} > ... > end > > From the mongrel console, I found a SQL statement AS generated is like > this: > > SELECT count(DISTINCT "states".id) AS count_all > FROM "states" > LEFT OUTER JOIN "adjacencies" ON "adjacencies".state_id = > "states".id > LEFT OUTER JOIN "states" adjacencies_states ON > "adjacencies_states".id = "adjacencies".adjacency_id AND states.status > = 'active' > > Actually I think the part "AND states.status = 'active'" should be > "AND adjacencies_states.status = 'active'". > > Since I'm new to AS (I just installed it 4 hours ago), can anybody > confirm this is a bug or how I can work around this issue. > > Thanks a lot! > > ZhangInSeattle --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "ActiveScaffold : Ruby on Rails plugin" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/activescaffold?hl=en -~----------~----~----~----~------~----~------~--~---
