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

This program gives what you want:

#!/usr/bin/ruby

require "sqlite3"

query = "select * from moz_bookmarks"
db = SQLite3::Database.new("test.sqlite")
db.results_as_hash = true
rows = db.execute(query)
rows.each do |row|
	#p row
	#puts row.class
	#p row.methods
	puts row['title']
end


The commented bits will help you with debugging in the future. They enable
you to see what kind of objects you are dealing with.

The answer to selecting rows by column name is to use
db.results_as_hash as above. This was easily discovered via google.

Go here: http://sqlite-ruby.rubyforge.org/
Click on the 'FAQ' link.

Les