Ruby SQL: undefined method `[]'

Question

I think I'm being stupid.

rc = Mysql.new('CENSORED_HOST','username','password','db')
release = rc.query('select * from wp_ribcage_releases where release_id = 1 limit 1')

puts release["release_title"]

rc.close

And I am getting the following error:

ribcage-connect.rb:17: undefined method `[]' for #<Mysql::Result:0x1011ee900> (NoMethodError)

I'm new to this and I am sure I am basically doing something very stupid. Thanks a lot.

EDIT

The kind people below have got me a but further, now I have:

rc = Mysql.new('server','user','pword','db')

release = rc.query('select * from wp_ribcage_releases where release_id = 1 limit 1')

row = release.fetch_row
puts row['release_title']

rc.close

And now I get the error:

ribcage-connect.rb:12:in `[]': can't convert String into Integer (TypeError)
    from ribcage-connect.rb:12

sled · Accepted Answer · 2010-09-08 00:21:48Z

2

the rc.query(...) returns a result set you can iterate. You can't directly access it.

Look at:

http://www.kitebird.com/articles/ruby-mysql.html#TOC_7

Since you have only one row (because of LIMIT 1) you can do:

row = release.fetch_hash
puts row['release_title']

If you have multiple rows:

while row = release.fetch_hash do
 puts row["release_title"]
end

edited Sep 8, 2010 at 0:21

answered Sep 7, 2010 at 18:43

sled

14.6k3 gold badges46 silver badges70 bronze badges

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

3 Comments

Alex Over a year ago

I not getting this problem - release = rc.query('select * from wp_ribcage_releases where release_id = 1 limit 1') release = release.fetch_row puts release['release_artist'] = can't convert String into Integer (TypeError) from ribcage-connect.rb:12

Vinko Vrsalovic Over a year ago

@The Warm Jets: It's fetch_hash if you want to use column names. fetch_row will use column indexes. Also, you should use a different variable instead of overwriting release, for clarity.

Vinko Vrsalovic Over a year ago

@sled: You have a bug in your first sample, it should be fetch_hash

Vinko Vrsalovic · Accepted Answer · 2010-09-07 18:41:29Z

0

That error means you cannot index directly (use []) the Result object.

It should instead be (for this single row case):

row = release.fetch_hash
puts row["release_title"]

For more information: go here

answered Sep 7, 2010 at 18:41

Vinko Vrsalovic

342k55 gold badges341 silver badges374 bronze badges

Collectives™ on Stack Overflow

Ruby SQL: undefined method `[]'

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related