From: George Moschovitis <gm@...>
Date: 2004-07-16T00:17:17+09:00
Subject: 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.