2009/7/28 cocozz <[email protected]>: > > Of course ! > > Look at the end: > > " > class Shopcategory0 < ActiveRecord::Base > set_table_name "shopcategories_0" > > has_many :shopcategory1s, :foreign_key => :parentcategory_id > end > > class Shopcategory1 < ActiveRecord::Base > set_table_name "shopcategories_1" > > belongs_to :shopcategory0, :foreign_key => :shopcategory_id > end > > class Shopcategory0sController < ApplicationController > def show > �...@shopcategory = Shopcategory0.all (:joins > => :shopcategory1s) > end > end > > --------------------- > That's the SQL result: > --------------------- > > Shopcategory0 Load (0.1ms) SELECT `shopcategories_0`.* FROM > `shopcategories_0` INNER JOIN `shopcategories_1` ON > shopcategories_1.parentcategory_id = shopcategories_0.id > > --------------------- > And this is what I search (notice the end): > --------------------- > > Shopcategory0 Load (0.1ms) SELECT `shopcategories_0`.* FROM > `shopcategories_0` INNER JOIN `shopcategories_1` ON > shopcategories_1.parentcategory_id = shopcategories_0.shopcategory_id > " > > On Jul 28, 8:05 pm, Eric <[email protected]> wrote: >> On Jul 28, 10:34 am, cocozz <[email protected]> wrote: >> >> >> >> > class Shopcategory0 < ActiveRecord::Base >> > set_table_name "shopcategories_0" >> >> > has_many :shopcategory1s, :foreign_key => :parentcategory_id >> > end >> >> > class Shopcategory1 < ActiveRecord::Base >> > set_table_name "shopcategories_1" >> >> > belongs_to :shopcategory0, :foreign_key => :shopcategory_id >> > end >> >> > class Shopcategory0sController < ApplicationController >> > def show >> > @shopcategory = Shopcategory0.all (:joins >> > => :shopcategory1s) >> > end >> > end >> >> > --------------------- >> > That's the SQL result: >> > --------------------- >> >> > Shopcategory0 Load (0.1ms) SELECT `shopcategories_0`.* FROM >> > `shopcategories_0` INNER JOIN `shopcategories_1` ON >> > shopcategories_1.parentcategory_id = shopcategories_0.id >> >> > --------------------- >> > And this is what I search (notice the end): >> > --------------------- >> >> > Shopcategory0 Load (0.1ms) SELECT `shopcategories_0`.* FROM >> > `shopcategories_0` INNER JOIN `shopcategories_1` ON >> > shopcategories_1.parentcategory_id = shopcategories_0.shopcategory_id >> >> > I suppose there is a way to do that...I'll appreciate your help !!! >> >> Is there a question in there? >>
I too have difficulty seeing what is the question you are asking. Do you mean you are trying to generate that particular query? What does 'notice the end' mean? If so why are you trying to generate some particular sql. Generally you should think about what you want to achieve at a higher level and let Rails worry about the query. Colin --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
