On Mon, Jun 13, 2011 at 10:33 AM, Edward Brekelbaum <nedb...@yahoo.com>wrote:
>
> package require sqlite3
> sqlite db test.db
> db eval {CREATE TABLE t1(x, data) }
> db eval {INSERT INTO t1 VALUES('0', 'cheese')}
> db eval {INSERT INTO t1 VALUES('four', 'bread')}
>
> set x 0
> db eval {SELECT * FROM t1 WHERE x=$x}
> # returns empty string
>
Change the schema to:
CREATE TABLE t1(x TEXT, data)
to clear this problem
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
