============================================================
From: BareFeet <[EMAIL PROTECTED]>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Tuesday, May 20, 2008 8:37:37 AM
Subject: Re: [sqlite] Help with syntax
Well those original instructions are correct, as long as you unsmarten
the the quotes, so it reads:
sqlite /var/local/database/dblist "insert into list
(owner,behavior,entry) values(0,0,'newblacklistentry.com') "
============================================================
Barefoot,
Got the following message:
# sqlite /var/local/database/dblist "insert into list (owner,behavior,entry)
values(0,0,'newblacklistentry.com') "
SQL error: table list has no column named owner
I put values inside the brackets based on the instructions given me:
The value for behavior is 0 for blacklist and 1 for whitelist. Owner is always
0 (for system) in your tests.
I typed in:
sqlite /var/local/database/dblist "insert into list (0,0,newblacklistentry.com)
values(0,0,'newblacklistentry.com') "
And I get:
SQL error: near "0": syntax error
Carlo
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
