Bryan JJ Buckley wrote:
> 2008/6/20 The Doobs <thedoobs / gmail.com>:
>> require "sqlite3"
>>
>> query = "select * from moz_bookmarks"
>> db = SQLite3::Database.new("/Users/me/Desktop/places.sqlite")
>> rows = db.execute(query)
> # Rows is an array of arrays....
>> rows.each do |row|
> # At this point, "row" is a straightforward array - you need to use
> Integer indices
>>  print row['title']
> # This fails because you cannot use a string as an integer into an 
> array. Try
> puts row[0]

Using integer indices did the trick. Thanks! I was trying to use the 
column name 'title'. By the way, the places.sqlite file is the file 
where Firefox 3 stores its bookmarks and some other stuff.  On OS X, it 
can be found in ~/Library/Application 
Support/Firefox/Profiles/*.default/.
-- 
Posted via http://www.ruby-forum.com/.