Hi all, This is not really a sqlite specific question, but I was wondering if there might be a sqlite specific answer. I prepare the following statement:
"SELECT col1 FROM table1 WHERE col2=:val" col2 is a textual string, and may sometimes be NULL. If I bind a string to :val it works fine. If I bind a null-pointer the comparison fails since it should be using ISNULL. Is there a way to do this correctly with a single statement? I know I can have 2 statments and test the string pointer at runtime to determine which one to run, but that seems awkward. -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
