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

Reply via email to