[Rails] Re: Command line can't find sqlite3

Barney,

I think you have to enter the sqlite shell if you want to run those
types of commands (e.g., select * etc...).

Run sqlite on the "development" db, try this:

$ cd [app_name]
$ cd db/ # your development.sqlite3 file should be here...
$ sqlite development.sqlite3 # now the sqlite shell should boot

Now you can run your SQL commands:

$ sqlite> select * from orders limit 1

See generally http://www.sqlite.org/sqlite.html

-Rodrigo

On Jul 12, 1:05 pm, Barney <bsper...@gmail.com> wrote:
> Hello,
>      I'm using the newest "Agile Web Development With Rails" book and
> the Ruby command line call near the end of p. 267 is:
> sqlite3 -line db/development.sqlite3 "select * from orders limit 1"
> and this, (with my own table, which has data which was verified by
> looking at the WEBRick output in a browser) gives the error:
> sqlite3 is not recognized as an internal or external command, operable
> program or batch file.
> But, sqlite3 is installed and working (by Web verification) and also
> the rails console works and shows me the column_names, etc.  Also,
> sqlite3.dll exists in c:\ruby192\bin\ and that path is in my
> environment PATH variable.  I'm using Windows XP.
>      What am I forgetting to do?
>           Thanks,
>             Barney

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.