Greg Stein <gst...@gmail.com> writes: > I understand, and would suggest an alternative if I had one right now. I > feel the same as you about "not that rock, another".
I have an alternative, but I'm not going to claim it's better. Use sqlite3_create_function to define a function foo that takes two parameters, a string and a blob. Implemenent foo to handle the blob as an apr_hash_t and lookup the string in the hash. Then the static statement looks like: "... AND foo(changelist, ?3) ..." and the code only needs to bind a single blob parameter. -- Philip
