From: Vladimir <asodu@...>
Date: 2003-02-27T17:17:22+09:00
Subject: dbi-error

Hi, All
I need help
How I should work with fields date and time types ?

table dailyc
structure :
  field       type
  ----------------
  date_label  date
  time_label  time
  pipe3       float
  pipe4       float
  pipes_sum   float

  ruby 1.8.0-preview1 (version 1.6.8 working same in this case)
  ruby-dbi-0.0.18

 I'd like, most of all, to ask about that Michael Neumann, DBI Creator. :-))

------------------- code ---------------------------------------------------
require 'dbi'

rows = []
dbh = DBI.connect('dbi:mysql:webdb:localhost','root','dbmaster')
sql = 'select date_label, time_label  pipe3, pipe4, pipes_sum from dailyc'
sth = dbh.prepare(sql)
sth.execute
while row = sth.fetch
  print row.join("\t")
  print "\n"
end
dbh.commit
dbh.disconnect
puts "Press Enter"
STDIN.getc
puts "Fetching Data Ok!"
----------------------------------------------------------------------
ERROR:
/usr/lib/ruby/site_ruby/1.8/dbi/sql.rb:59:in `gm': no implicit conversion
 from nil to integer (TypeError)
        from /usr/lib/ruby/site_ruby/1.8/dbi/sql.rb:59:in `as_timestamp'
        from /usr/lib/ruby/site_ruby/1.8/dbi/sql.rb:51:in `as_time'
        from /usr/lib/ruby/site_ruby/1.8/dbi/sql.rb:79:in `send'
        from /usr/lib/ruby/site_ruby/1.8/dbi/sql.rb:79:in `coerce'
        from /usr/lib/ruby/site_ruby/1.8/DBD/Mysql/Mysql.rb:377:in
`fill_array'
        from /usr/lib/ruby/site_ruby/1.8/DBD/Mysql/Mysql.rb:374:in
`each_with_index'
        from /usr/lib/ruby/site_ruby/1.8/DBD/Mysql/Mysql.rb:374:in `each'
        from /usr/lib/ruby/site_ruby/1.8/DBD/Mysql/Mysql.rb:374:in
`each_with_index'
        from /usr/lib/ruby/site_ruby/1.8/DBD/Mysql/Mysql.rb:374:in
`fill_array'
        from /usr/lib/ruby/site_ruby/1.8/DBD/Mysql/Mysql.rb:384:in `fetch'
        from /usr/lib/ruby/site_ruby/1.8/dbi/dbi.rb:786:in `fetch'
        from /usr/lib/ruby/site_ruby/1.8/dbi/dbi.rb:811:in `each'
        from ./testDAILYC.rb:15:in `collect'
        from ./testDAILYC.rb:15
        from ./testDAILYC.rb:14:in `execute'
        from ./testDAILYC.rb:14


----------------------------------------------------------------------
require 'dbi'

rows = []
dbh = DBI.connect('dbi:mysql:webdb:localhost','root','dbmaster')
sql = 'select date_label,  pipe3, pipe4, pipes_sum from dailyc'  # without
time_label !!!!
sth = dbh.prepare(sql)
sth.execute
while row = sth.fetch
  print row.join("\t")
  print "\n"
end
dbh.commit
dbh.disconnect
puts "Press Enter"
STDIN.getc
puts "Fetching Data Ok!"
----------------------------------------------------------------------
Now all Ok, like this

2002-10-24	42.669	105.639	148.308
...................................
2002-10-28	33.418	82.759	116.178
2002-10-28	33.789	83.7		117.488
2002-10-28	34.063	84.373	118.436
Press Enter
Fetching Data Ok!
Bye...
-----------------------------------------------------------------------
Help me Please !!!
Thanks for advance
Vladimir