Menu

#11 selecting field of TIME type gives error

open
nobody
None
5
2003-04-04
2003-04-04
Anonymous
No

"SELECT date,length,number FROM table" from mysql
database, where 'length' is TIME type, gives the
following error:

/usr/lib/ruby/site_ruby/1.6/dbi/sql.rb:59:in `gm': no
implicit conversion from nil (TypeError)
from
/usr/lib/ruby/site_ruby/1.6/dbi/sql.rb:59:in `as_timestamp'
from
/usr/lib/ruby/site_ruby/1.6/dbi/sql.rb:51:in `as_time'
from
/usr/lib/ruby/site_ruby/1.6/dbi/sql.rb:79:in `send'
from
/usr/lib/ruby/site_ruby/1.6/dbi/sql.rb:79:in `coerce'
from
/usr/lib/ruby/site_ruby/1.6/DBD/Mysql/Mysql.rb:377:in
`fill_array'
from
/usr/lib/ruby/site_ruby/1.6/DBD/Mysql/Mysql.rb:374:in
`each_with_index'
from
/usr/lib/ruby/site_ruby/1.6/DBD/Mysql/Mysql.rb:374:in
`each'
from
/usr/lib/ruby/site_ruby/1.6/DBD/Mysql/Mysql.rb:374:in
`each_with_index'
from
/usr/lib/ruby/site_ruby/1.6/DBD/Mysql/Mysql.rb:374:in
`fill_array'
from
/usr/lib/ruby/site_ruby/1.6/DBD/Mysql/Mysql.rb:384:in
`fetch'
from
/usr/lib/ruby/site_ruby/1.6/dbi/dbi.rb:794:in `fetch'

Discussion


Log in to post a comment.