thr3ads.net - Rails - Newb question...get info from the db [Mar 2009]

If this information is useful, please help other people find it:
Share via:

Chris Gunnels

2009-Mar-09 23:04 UTC

Newb question...get info from the db

I am using a mysql db and I want to pull some info from the db. I think
my problem is that I am trying to get the data from an object that
doesn''t exist in my MemberController. My code:
[code]
class MemberController < ApplicationController
  def index
    @login = User.find_by_login(params[:l])
    flash[:notice] = @login + ", you''ve logged in
successfully"
  end
end
[/code]

the table in the db is the User table and it has a column of login.
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

bill walton

2009-Mar-09 23:18 UTC

head link

Re: Newb question...get info from the db

Hi Chris,

On Tue, 2009-03-10 at 00:04 +0100, Chris Gunnels wrote:> I am using a mysql db and I want to pull some info from the db. I think
> my problem is 
You''ll find it easier to get help here if you''ll post the
error message
that demonstrates your problem, along with the code that the error
message tells you is causing the problem.
> that I am trying to get the data from an object that
> doesn''t exist in my MemberController. My code:
> [code]
> class MemberController < ApplicationController
>   def index
>     @login = User.find_by_login(params[:l])
>     flash[:notice] = @login + ", you''ve logged in
successfully"
>   end
> end
> [/code]
However, in this case you may well have told us the probable cause of
the problem.
> the table in the db is the User table and it has a column of login.
Rails'' default is that the table name is a plural version of the model
name.  That''s because the Model typically represents a single record
from a table.  So the table named Users holds lots of records that are
access via the User model.

HTH,
Bill


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Chris Gunnels

2009-Mar-09 23:24 UTC

head link

Re: Newb question...get info from the db

> Rails'' default is that the table name is a plural version of the
model
> name.  That''s because the Model typically represents a single
record
> from a table.  So the table named Users holds lots of records that are
> access via the User model.
Im sorry the table name is users...here is the error message:
NoMethodError in MemberController#index

undefined method `+'' for #<User:0x44d3ca4>

RAILS_ROOT: C:/Ruby/MyProjects/ipod-give-away.com
Application Trace | Framework Trace | Full Trace

C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/attribute_methods.rb:260:in
`method_missing''
app/controllers/member_controller.rb:4:in `index''

Request

Parameters:

{"l"=>"ballhogjoni"}

Show session dump

Response

Headers:

{"cookie"=>[],
 "Content-Type"=>"",
 "Cache-Control"=>"no-cache"}
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Harold

2009-Mar-09 23:48 UTC

head link

Re: Newb question...get info from the db

In that case, try:

class MemberController < ApplicationController
  def index
    @user= User.find_by_login(params[:l])
    flash[:notice] = @user.login + ", you''ve logged in
successfully"
  end
end



On Mar 9, 7:24 pm, Chris Gunnels
<rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>
wrote:> > Rails'' default is that the table name is a plural version of
the model
> > name.  That''s because the Model typically represents a single
record
> > from a table.  So the table named Users holds lots of records that are
> > access via the User model.
>
> Im sorry the table name is users...here is the error message:
> NoMethodError in MemberController#index
>
> undefined method `+'' for #<User:0x44d3ca4>
>
> RAILS_ROOT: C:/Ruby/MyProjects/ipod-give-away.com
> Application Trace | Framework Trace | Full Trace
>
>
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/attribute_methods.rb:260:in
> `method_missing''
> app/controllers/member_controller.rb:4:in `index''
>
> Request
>
> Parameters:
>
> {"l"=>"ballhogjoni"}
>
> Show session dump
>
> Response
>
> Headers:
>
> {"cookie"=>[],
>  "Content-Type"=>"",
>  "Cache-Control"=>"no-cache"}
> --
> Posted viahttp://www.ruby-forum.com/.--~--~---------~--~----~------------~-------~--~----~
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@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

bill walton

2009-Mar-09 23:54 UTC

head link

Re: Newb question...get info from the db

On Tue, 2009-03-10 at 00:24 +0100, Chris Gunnels wrote:> 
> > Rails'' default is that the table name is a plural version of
the model
> > name.  That''s because the Model typically represents a single
record
> > from a table.  So the table named Users holds lots of records that are
> > access via the User model.
> 
> Im sorry the table name is users...here is the error message:
> NoMethodError in MemberController#index
> 
> undefined method `+'' for #<User:0x44d3ca4>
> 
> RAILS_ROOT: C:/Ruby/MyProjects/ipod-give-away.com
> Application Trace | Framework Trace | Full Trace
> 
>
C:/Ruby/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/attribute_methods.rb:260:in
> `method_missing''
> app/controllers/member_controller.rb:4:in `index''
> 
> Request
> 
> Parameters:
> 
> {"l"=>"ballhogjoni"}
What does the index method in member_controller.rb look like?


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Chris Gunnels

2009-Mar-09 23:59 UTC

head link

Re: Newb question...get info from the db

Harold wrote:> In that case, try:
> 
> class MemberController < ApplicationController
>   def index
>     @user= User.find_by_login(params[:l])
>     flash[:notice] = @user.login + ", you''ve logged in
successfully"
>   end
> end
> 
> 
> 
> On Mar 9, 7:24�pm, Chris Gunnels
<rails-mailing-l...-ARtvInVfO7m5VldFQK4jKA@public.gmane.orgt>
Your changes worked...What was I doing wrong?
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
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@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Harold A. Giménez Ch.

2009-Mar-10 00:04 UTC

head link

Re: Newb question...get info from the db

OK Great...

You were calling the + method, which concatenates two string objects, on a
User object. In your original code, the @login variable did not hold a
string object, but a user object (returned by the call to
User.find_by_login( ... ).

Ruby was rightfully complaining that the + method was not defined on the
user object. @user.login returns a string, which does have the + method and
therefore you can concatenate with the rest of your string (in the flash
message).

On Mon, Mar 9, 2009 at 7:59 PM, Chris Gunnels <
rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:
>
> Harold wrote:
> > In that case, try:
> >
> > class MemberController < ApplicationController
> >   def index
> >     @user= User.find_by_login(params[:l])
> >     flash[:notice] = @user.login + ", you''ve logged in
successfully"
> >   end
> > end
> >
> >
> >
> > On Mar 9, 7:24�pm, Chris Gunnels
<rails-mailing-l...@andreas-s.net>
>
> Your changes worked...What was I doing wrong?
> --
> Posted via http://www.ruby-forum.com/.
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Chris Gunnels

2009-Mar-10 00:11 UTC

head link

Re: Newb question...get info from the db

Harold A. Giménez Ch. wrote:> OK Great...
> 
> You were calling the + method, which concatenates two string objects, on 
> a
> User object. In your original code, the @login variable did not hold a
> string object, but a user object (returned by the call to
> User.find_by_login( ... ).
> 
> Ruby was rightfully complaining that the + method was not defined on the
> user object. @user.login returns a string, which does have the + method 
> and
> therefore you can concatenate with the rest of your string (in the flash
> message).
> 
> 
> 
> On Mon, Mar 9, 2009 at 7:59 PM, Chris Gunnels <
oooo ok in PHP (what im used to programming), I was assigning @login = 
User.find_by_login(params[:l]) which would, in php, tell php the @login 
is a string and not an object. I have to get used to everything being an 
object in ruby.
-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
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@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Rails - Mar 2009 - Newb question...get info from the db

Newb question...get info from the db

Re: Newb question...get info from the db

Re: Newb question...get info from the db

Re: Newb question...get info from the db

Re: Newb question...get info from the db

Re: Newb question...get info from the db

Re: Newb question...get info from the db

Re: Newb question...get info from the db