On 10-11-20 04:11 AM, Colin Law wrote:
On 20 November 2010 07:25, Rajinder Yadav<[email protected]> wrote:
I'm getting strange results with rails 3.0.1
In each case the query seems to return the correct row, however only one of
them gives me the correct value for the name field.
ya...@six9:$ rails console
Loading development environment (Rails 3.0.1)
irb(main):001:0> Ticket
=> Ticket(id: integer, name: string, seat: string, address: text, price:
decimal, email: string, created_at: datetime, updated_at: datetime)
irb(main):002:0> t = Ticket.where "name like ?", "Pushpa Yadav"
=> [#<Ticket id: 2, name: "Pushpa Yadav", seat: "12d", address: "12 Rosewood
Ave.,Toronto,ON", price: #<BigDecimal:34cd558,'0.1E2',9(18)>, email:
"[email protected]", created_at: "2010-11-20 06:37:21", updated_at: "2010-11-20
06:37:21">]
irb(main):003:0> t.name
=> "Ticket"
Look carefully and you will see that t is an array, containing all
rows that match, though only one in this case. so you must do
t[0].name or t.first.name or similar. I am not sure why t.name
evaluates to "Ticket" though.
irb(main):004:0> t = Ticket.find 2
=> #<Ticket id: 2, name: "Pushpa Yadav", seat: "12d", address: "12 Rosewood
Ave.,Toronto,ON", price: #<BigDecimal:3443dd0,'0.1E2',9(18)>, email:
"[email protected]", created_at: "2010-11-20 06:37:21", updated_at: "2010-11-20
06:37:21">
irb(main):005:0> t.name
=> "Pushpa Yadav"
As you have asked for a single row this time it is not an array.
Colin
Thanks Colin, that makes sense! I had it in my head I was only getting
back a single row, failed to see an array was being returned.
--
Kind Regards,
Rajinder Yadav | DevMentor.org | Do Good! ~ Share Freely
GNU/Linux: 2.6.35-22-generic
Kubuntu x86_64 10.10 | KDE 4.5.1
Ruby 1.9.2p0 | Rails 3.0.1
--
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.
