I was under the impression that the notation was just ? (no ending number) and :AAA (no ending colon). Using it like that works fine for me.
On Wed, 22 Sep 2004 22:20:46 -0700, Vladimir Vukicevic <[EMAIL PROTECTED]> wrote: > 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 > -- Cory Nelson http://www.int64.org
