From: The Doobs <thedoobs@...>
Date: 2008-06-21T05:31:15+09:00
Subject: sqlite3-ruby problem accessing row values

I get a "can't convert String into Integer (TypeError)" error about the
print statement in the following code. The sqlite3-ruby library has been
installed successfully on my OS X 10.5 system. The code executes fine if
I replace the print statement with: print "hello".  Any suggestions? All
I want to do is iterate through each row in the return set (rows) of the
executed query and look at specific column values. I have run out of
ideas on how to fix this and would appreciate any help.  Thanks...

#!/usr/bin/ruby

require "sqlite3"

query = "select * from moz_bookmarks"
db = SQLite3::Database.new("/Users/me/Desktop/places.sqlite")
rows = db.execute(query)
rows.each do |row|
  print row['title']
end
-- 
Posted via http://www.ruby-forum.com/.