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:inas_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:insend’
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:infill_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:ineach’
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:infill_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:infetch’
from /usr/lib/ruby/site_ruby/1.8/dbi/dbi.rb:811:in each' from ./testDAILYC.rb:15:incollect’
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