rails select only 2 columns error

Question

script/console output:

>> User.find(:first, :select => '`email`, `pass`, `login`, `id`')
=> #<User pass: "e10adc3949ba59abbe56e057f20f883e", email: "[email protected]">
>> User.find(:first, :select => '`pass`, `login`, `id`')
=> #<User login: "ostap", pass: "e10adc3949ba59abbe56e057f20f883e">

how i can fix it? Unix hosting, Ruby 1.8.7, Rails 2.3.5, MySQL 5.1.46

in mysql console all fine...

ScottJShea · Accepted Answer · 2012-03-03 09:46:22Z

1

Try changing ":select => 'pass, login, id'" to :select => 'email, pass, login, id'; i.e. remove the backticks around the fields. I think the backticks in your argument are throwing off the select. Here is the API dock for the find command that lead me to that conclusion.

answered Mar 3, 2012 at 9:46

ScottJShea

7,12111 gold badges47 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

ostapische Over a year ago

>> User.find(:first, :select => 'email, pass, login, id') => #<User pass: "e10adc3949ba59abbe56e057f20f883e", email: "[email protected]"> >> User.find(:first) => #<User id: 1, login: "ostap"> Its doesnt work...

iltempo Over a year ago

I don't know if this is a pattern but for some suspicious reason only the first two columns are shown. No matter what you selected. Did you check if the attributes are set actually? Maybe they are not shown only.

ostapische Over a year ago

@iltempo what attributes? and how i can check this?

iltempo Over a year ago

Call User.find(:first, :select => 'email, pass, login, id').login.

ostapische Over a year ago

>> User.find(:first, :select => 'email, pass, login, id').login ActiveRecord::MissingAttributeError: missing attribute: login         from /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/attribute_methods.rb:244:in send         from /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.5/lib/active_record/attribute_methods.rb:244:in method_missing         from (irb):1

|

Collectives™ on Stack Overflow

rails select only 2 columns error

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related