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+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.