MySQL Forums
Forum List  »  Ruby

eruby dbi select problem
Posted by: Peter Heywood
Date: January 22, 2008 08:23AM

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

Options: ReplyQuote


Subject
Written By
Posted
eruby dbi select problem
January 22, 2008 08:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.