From: BG Scott <redmine@...>
Date: 2009-08-07T01:24:27+09:00
Subject: [ruby-core:24798] [Bug #1902] Apparent problem with sqlite3-ruby

Bug #1902: Apparent problem with sqlite3-ruby
http://redmine.ruby-lang.org/issues/show/1902

Author: BG Scott
Status: Open, Priority: Normal
ruby -v: 1.8.6 (2008-08-11 patchlevel 287)

Running ruby 1.8.6 (2008-08-11 patchlevel 287) [universal-darwin9.0] on Max OS X. When I run this script:

#! /usr/bin/ruby -w

require 'sqlite3'

p = SQLite3::Database.new("development.sqlite3")
p.execute( "select * from posts" ) do |row|
  puts row
end
p.close

the following error message is displayed: 

$ fetchDb
./fetchDb:3:in `require': no such file to load -- sqlite3 (LoadError)
	from ./fetchDb:3

When the same script is entered via irb, it works properly. What's going on?  I'm new to Ruby, Rails, and sqlite3.


----------------------------------------
http://redmine.ruby-lang.org