A
Andreu
I'm using Ruby 1.9.1 and sqlite3 with sqlite3-Ruby (1.2.5)
Doing the following query:
pc1 = db.execute("select count(*) from mytab where(n2=n1)")
I get say: pc1 = [["123"]]
and when using:
pc1 = db.get_first_row("select count(*) from mytab where(n2=n1)")
I get say: pc1 = ["123"]
What I really want is the numeric value alone without the
square brackets, quotes, and the like, as several queries are
'chained' and this gets really annoying.
Ruby 1.8.7 doesn't exibit that behaviour and work as expected.
Am I missing something ?
Thanks, Andreu.
Doing the following query:
pc1 = db.execute("select count(*) from mytab where(n2=n1)")
I get say: pc1 = [["123"]]
and when using:
pc1 = db.get_first_row("select count(*) from mytab where(n2=n1)")
I get say: pc1 = ["123"]
What I really want is the numeric value alone without the
square brackets, quotes, and the like, as several queries are
'chained' and this gets really annoying.
Ruby 1.8.7 doesn't exibit that behaviour and work as expected.
Am I missing something ?
Thanks, Andreu.