From: Leslie Viljoen <leslieviljoen@...>
Date: 2008-06-21T18:18:44+09:00
Subject: Re: sqlite3-ruby problem accessing row values

On 6/20/08, The Doobs <thedoobs@gmail.com> wrote:
> 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

Perhaps it would help if you uploaded places.sqlite somewhere (like
Mediafire) so we can try the program. Otherwise, even the schema would
help

Les