[Rails-deploy] Re: sqlite3 on my live server - question about command line

2008-02-10 Thread Pat Allan
On 10/02/2008, at 3:27 PM, Dave Amos wrote: Shawn Balestracci wrote: The database is stored in its own file (named in your database.yml) To access it, on the commandline: sqlite3 filename on the server and directory where it is located (or use the full path). The database will most

[Rails-deploy] Re: sqlite3 on my live server - question about command line

2008-02-10 Thread Dave Amos
Okay, that made sense to me, and it worked! I've been inserting data like crazy, thanks! I do have a bit of a follow up question, though. Does sqlite3 handle booleans differently than MySQL? It seems to choke when I query based on a boolean. For example: In my controller, I have this:

[Rails-deploy] Re: sqlite3 on my live server - question about command line

2008-02-10 Thread Shawn Balestracci
Yes, it uses 1 and 0 instead.. change your query to this: @gameweek = Gameweek.find(:first, :conditions = [ current = ? and league_id = ?,true, @league.id ]) On Feb 10, 2008 9:52 AM, Dave Amos [EMAIL PROTECTED] wrote: Okay, that made sense to me, and it worked! I've been inserting data

[Rails-deploy] Re: sqlite3 on my live server - question about command line

2008-02-09 Thread Shawn Balestracci
The database is stored in its own file (named in your database.yml) To access it, on the commandline: sqlite3 filename on the server and directory where it is located (or use the full path). The database will most likely be in the RAILS_ROOT directory of your application. On Feb 9, 2008