# Database Query

**URL:** <https://www.ruby-forum.com/t/database-query/131881>\
**Category:** Ruby\
**Created:** [March 14, 2008, 2:48am UTC](https://www.ruby-forum.com/t/database-query/131881 "2008-03-14T02:48:28Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![sithadmin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/858c86/32.png) [@sithadmin](https://www.ruby-forum.com/u/sithadmin)\
**Post date:** [March 14, 2008, 2:48am UTC](https://www.ruby-forum.com/t/database-query/131881/1 "2008-03-14T02:48:28Z")

</div>

Hello,  
This may sound silly, but I can’t seem to get my results out of a  
database query. I can do this fine in Ruby on Rails, but from a Ruby  
script, I can’t seem to. I know my query works because I’ve already  
tested it. My code is as follows:

require ‘mysql’  
create\_log = File.new(“comparison\_imei.html”, “w”)  
db = Mysql.connect(“localhost”, “root”, “root”, “compare\_imei”)

@num\_perfect\_matches = db.query("  
SELECT COUNT(\*) AS n  
FROM att  
JOIN bes  
ON att.att\_imei = bes.bes\_imei  
ORDER BY  
att.att\_name")

for num in @num\_perfect\_matches  
@numberofrows = num[‘n’]  
create\_log.puts @numberofrows  
end

This gives me the following error:  
compare\_imei.rb:22: undefined method `each’ for nil:NilClass  
(NoMethodError)

Is there a proper way to get data out of my query?

Thanks,

- Jeff M.