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
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:
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
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