I am trying to make a prepared statement that has a parameter such as
"1, 893, 121212". obviously it is text (a string) but it cannot be
quoted or the result will be:
SELECT id, data FROM val WHERE id IN ("1, 893, 121212");I understand normally I would need the quotes, such as: SELECT id, name, val FROM obj WHERE name = ? I am not sure if this is happening. From a few tests, it seems to be what is going on. How does one use WHERE x IN (?) with a prepared statement? What is the correct way to do this? Thanks for your time. Best regards, Simon _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
