# Eruby dbi select problem

**URL:** <https://www.ruby-forum.com/t/eruby-dbi-select-problem/126724>\
**Category:** Ruby\
**Created:** [January 21, 2008, 6:28pm UTC](https://www.ruby-forum.com/t/eruby-dbi-select-problem/126724 "2008-01-21T18:28:35Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![woodzer](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/f08c70/32.png) [@woodzer](https://www.ruby-forum.com/u/woodzer)\
**Post date:** [January 21, 2008, 6:28pm UTC](https://www.ruby-forum.com/t/eruby-dbi-select-problem/126724/1 "2008-01-21T18:28:35Z")

</div>

Hi  
I’m using eruby/mod\_ruby on Apache 2.2 and I’m having a problem doing a  
select against a table (mysql 5)

sth = dbh.execute(“select type,site,amount from logger order by id  
desc”)

The select returns the results from type,site but not amount. Amount is  
a decimal field. Ruby just throws the following internal server error.  
If I remove amount it works fine. Any idea what I’m doing wrong?

[Mon Jan 21 12:19:14 2008] [error] mod\_ruby:  
/usr/lib/ruby/1.8/DBD/Mysql/Mysql.rb:649:in `column_info': undefined method`[]’ for nil:NilClass (NoMethodError)

Thanks