On Mon, Jun 13, 2011 at 10:33 AM, Edward Brekelbaum <[email protected]>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
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
