Ruby-mysql problem

Hello everyone,

I have a small problem with ruby-mysql.

lets say I have the following SQL Table:

CREATE TABLE MyTable
  oid INTEGER,
  pid INTEGER,
  body TEXT
);

when I execute a query like this:

rows = db.query("SELECT * FROM MyTable WHERE oid=2")

I get back a resultset:

rows.each { |row|
  puts row[1].class
}

I was surprised to see that row[1] is a String and NOT
a Fixnum, ie the types are lost. Is there any neat solution
to this problem?

Thanks in advance for any help!

George Moschovitis

···

--
www.navel.gr | tel: +30 2106898050 | fax: +30 2106898437

Navel does not accept liability for any errors, viruses or omissions in the contents of this message. The full corporate policy is available on our site.