Howdy, I'm trying to prepare statements using the ?n and/or :N: notation mentioned in the documentation and the sqlite3.h header. However, trying something like "INSERT INTO foo VALUES( ?1 )" results in SQLITE_ERROR, with the error string being 'near "1": syntax error'. Similar results with :1:, I get 'unrecognized token: ";"'. Am I doing something wrong, or are numbered (and named, I guess) parameters somewhat broken?
Thanks in advance,
- Vlad

