Hi all - having a problem that’s driving me insane. I was working on a
project that required reading in Access MDB files, then writing them to
a mySQL DB. I got it working, but the DB had a bunch of worthless data
from my previous testing - so I dropped the table to start fresh. Once I
dropped it, the float values from the Access read are being written to
the DB as integers. If I print the values I have assigned just before
the write, they come up correctly as floats. However, once in the DB -
they are only 8 bytes. I am baffled… the DB schema lists the fields as
floats. Code below.
dbh.select_all(‘select * from steel’) do |row|
@record = Report.new
Report.content_columns.each do |col|
@record[col.name] = row.shift
end
@record.save
end
Any advice appreciated.