On 11/15/2013 8:33 AM, L. Wood wrote:
But are there never quotes around the ?1, ?2, etc. even in SELECT statements? For example:SELECT * FROM table WHERE col1=?1 AND col2=?2; Is this correct or should there be '' around the ?1 or ?2 parameters?
'?1' (with quotes) is a string literal consisting of two characters, ? and 1. ?1 (without quotes) is a parameter placeholder. Both are syntactically valid, but have completely different meaning.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
