Bao Niu wrote:
> SELECT * FROM myTable WHERE MyDate > MyModule.ChineseDate("兔年八月十五")
You cannot use Python function directly in SQL.
You have to convert from the Python type to the corresponding SQL type.
I don't know how the type mapping works exactl, but it should probably
look like this:
db.execute("SELECT * FROM myTable WHERE MyDate > ?",
[MyModule.ChineseDate("兔年八月十五")])
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
