Regarding:
   Is there a way to use a prepared statement and bind a (variable)
array of integers?

    Like in:
    SELECT .... FROM table WHERE someinteger IN ( 2,18,19,340,1,72, 15
... )

    Becomes:
    SELECT .... FROM table WHERE someinteger IN ( ? )


I don't know that you can bind these, but
do I remember correctly that these integers are selected by human users?
If so, I guess the savings in time would be unmeasurably small, right?
Or do your users type the string directly were you aiming to reduce sql
injections?

_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to