Hi Everybody, I am trying to access the elements of a different table within another tables layout file. Here is basically what I am trying to do: <% if table1.ITEM_ID == table2.ID %> <td><%=h table1.ITEM_ID %></td> <% end %> But it gives me an error for table2. Here is the error I get: "undefined local variable or method" I''m very new to RoR and would appreciate any help. Thanks, Roshini --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Hi I''m new to rails too. but have you assign value to table2 in your controller? (@table2 something). burlight On Apr 2, 11:32 am, "Roshini" <roshi...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hi Everybody, > > I am trying to access the elements of a different table within another > tables layout file. Here is basically what I am trying to do: > > <% if table1.ITEM_ID == table2.ID %> > <td><%=h table1.ITEM_ID %></td> > <% end %> > > But it gives me an error for table2. Here is the error I get: > "undefined local variable or method" > > I''m very new to RoR and would appreciate any help. > > Thanks, > Roshini--~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Well for now, I have it in a for loop that goes through the entire table2 db to match and see if the same ID exists in both tables. But, everytime I make any reference to table2 even in the for loop, it throws the same error ""undefined local variable or method" On Apr 2, 4:01 am, "burlight" <ratanac...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hi > I''m new to rails too. > but have you assign value to table2 in your controller? (@table2 > something). > > burlight > > On Apr 2, 11:32 am, "Roshini" <roshi...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > Hi Everybody, > > > I am trying to access the elements of a different table within another > > tables layout file. Here is basically what I am trying to do: > > > <% if table1.ITEM_ID == table2.ID %> > > <td><%=h table1.ITEM_ID %></td> > > <% end %> > > > But it gives me an error for table2. Here is the error I get: > > "undefined local variable or method" > > > I''m very new to RoR and would appreciate any help. > > > Thanks, > > Roshini--~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Hi, you should be able to easily retrieve values from other tables. For example, if you have have the following: Example models: class User < ActiveRecord::Base def self.list User.find( :all ) end end class Car < ActiveRecord::Base def self.list Car.find( :all ) end end Example controllers: def CarController < ApplicationController def list @cars = Car.list end end class UserController < ApplicationController def list @users = User.list end end Now. in your views, you can easily reference both the @users and @cars instance variables within your views. Please remember that each model represents an OO view of the underlying table (i.e. cars and users tables). Again, this is just an example and you can customize it to do whatever you like. For example, you might want to get a subset of the available users or retrieve a user by an attribute. If this is the case, then you can easily define the appropriate method(s) within the controller and/or the model to achieve this goal. Well, I hope that this helps and I wish you the best of luck. -Conrad On 4/2/07, Roshini <roshinic-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > Well for now, I have it in a for loop that goes through the entire > table2 db to match and see if the same ID exists in both tables. But, > everytime I make any reference to table2 even in the for loop, it > throws the same error ""undefined local variable or method" > > On Apr 2, 4:01 am, "burlight" <ratanac...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > Hi > > I''m new to rails too. > > but have you assign value to table2 in your controller? (@table2 > > something). > > > > burlight > > > > On Apr 2, 11:32 am, "Roshini" <roshi...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > Hi Everybody, > > > > > I am trying to access the elements of a different table within another > > > tables layout file. Here is basically what I am trying to do: > > > > > <% if table1.ITEM_ID == table2.ID %> > > > <td><%=h table1.ITEM_ID %></td> > > > <% end %> > > > > > But it gives me an error for table2. Here is the error I get: > > > "undefined local variable or method" > > > > > I''m very new to RoR and would appreciate any help. > > > > > Thanks, > > > Roshini > > > > >--~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Okay....but how would I access the @cars in the UserController? On Apr 3, 12:10 am, "Conrad Taylor" <conra...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Hi, you should be able to easily retrieve values from other tables. > For example, if you have have the following: > > Example models: > > class User < ActiveRecord::Base > > def self.list > > User.find( :all ) > > end > > end > > class Car < ActiveRecord::Base > > def self.list > > Car.find( :all ) > > end > > end > > Example controllers: > > def CarController < ApplicationController > > def list > > @cars = Car.list > > end > > end > > class UserController < ApplicationController > > def list > > @users = User.list > > end > > end > > Now. in your views, you can easily reference both the @users and @cars > instance variables within your views. Please remember that each model > represents an OO view of the underlying table (i.e. cars and users > tables). Again, this is just an example and you can customize it to > do whatever you like. For example, you might want to get a subset of > the available users or retrieve a user by an attribute. If this is > the case, then you can easily define the appropriate method(s) within > the controller and/or the model to achieve this goal. Well, I hope > that this helps and I wish you the best of luck. > > -Conrad > > On 4/2/07, Roshini <roshi...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > Well for now, I have it in a for loop that goes through the entire > > table2 db to match and see if the same ID exists in both tables. But, > > everytime I make any reference to table2 even in the for loop, it > > throws the same error ""undefined local variable or method" > > > On Apr 2, 4:01 am, "burlight" <ratanac...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > Hi > > > I''m new to rails too. > > > but have you assign value to table2 in your controller? (@table2 > > > something). > > > > burlight > > > > On Apr 2, 11:32 am, "Roshini" <roshi...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > Hi Everybody, > > > > > I am trying to access the elements of a different table within another > > > > tables layout file. Here is basically what I am trying to do: > > > > > <% if table1.ITEM_ID == table2.ID %> > > > > <td><%=h table1.ITEM_ID %></td> > > > > <% end %> > > > > > But it gives me an error for table2. Here is the error I get: > > > > "undefined local variable or method" > > > > > I''m very new to RoR and would appreciate any help. > > > > > Thanks, > > > > Roshini--~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
you have to poulate the @cars variable in the UserController, just like you did with @users: def UserController < ApplicationController def list @cars = Car.list @users = User.list end end simple as that. the above is only pseudo code obviously, as you did not give any code example what you do in your controller to find your desired dataset. On 3 Apr., 10:24, "Roshini" <roshi...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Okay....but how would I access the @cars in the UserController? > > On Apr 3, 12:10 am, "Conrad Taylor" <conra...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > Hi, you should be able to easily retrieve values from other tables. > > For example, if you have have the following: > > > Example models: > > > class User < ActiveRecord::Base > > > def self.list > > > User.find( :all ) > > > end > > > end > > > class Car < ActiveRecord::Base > > > def self.list > > > Car.find( :all ) > > > end > > > end > > > Example controllers: > > > def CarController < ApplicationController > > > def list > > > @cars = Car.list > > > end > > > end > > > class UserController < ApplicationController > > > def list > > > @users = User.list > > > end > > > end > > > Now. in your views, you can easily reference both the @users and @cars > > instance variables within your views. Please remember that each model > > represents an OO view of the underlying table (i.e. cars and users > > tables). Again, this is just an example and you can customize it to > > do whatever you like. For example, you might want to get a subset of > > the available users or retrieve a user by an attribute. If this is > > the case, then you can easily define the appropriate method(s) within > > the controller and/or the model to achieve this goal. Well, I hope > > that this helps and I wish you the best of luck. > > > -Conrad > > > On 4/2/07, Roshini <roshi...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > Well for now, I have it in a for loop that goes through the entire > > > table2 db to match and see if the same ID exists in both tables. But, > > > everytime I make any reference to table2 even in the for loop, it > > > throws the same error ""undefined local variable or method" > > > > On Apr 2, 4:01 am, "burlight" <ratanac...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > Hi > > > > I''m new to rails too. > > > > but have you assign value to table2 in your controller? (@table2 > > > > something). > > > > > burlight > > > > > On Apr 2, 11:32 am, "Roshini" <roshi...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > > Hi Everybody, > > > > > > I am trying to access the elements of a different table within another > > > > > tables layout file. Here is basically what I am trying to do: > > > > > > <% if table1.ITEM_ID == table2.ID %> > > > > > <td><%=h table1.ITEM_ID %></td> > > > > > <% end %> > > > > > > But it gives me an error for table2. Here is the error I get: > > > > > "undefined local variable or method" > > > > > > I''m very new to RoR and would appreciate any help. > > > > > > Thanks, > > > > > Roshini- Zitierten Text ausblenden - > > - Zitierten Text anzeigen ---~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---