Hi Carlo,
> insert into list ('0,0,newblacklistentry1,com')
> values ('0,0,newblacklistentry1.com')"
> SQL error: table list has no column named 0,0,newblacklistentry1,com
Well, the error tells you the problem. You are asking SQLite to insert
a text value '0,0,newblacklistentry1.com' into a column called
'0,0,newblacklistentry1,com' in a table called list.
Does your table have a column called '0,0,newblacklistentry1,com' ?
I'm guessing not, so there's your problem.
If you're unfamiliar with the syntax required for an insert statement,
look here:
http://www.sqlite.org/lang_insert.html
If you still need help, please post the schema (ie the create table
statements) of your database and explain what you want inserted where.
Tom
BareFeet
http://www.tandb.com.au/sqlite/compare/
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
