http://www.sqlite.org/lang_expr.html#varparam
They are what are called Named Parameters. You use the sqlite3_bind_parameter_index to look up the index associated with a name ... ?nnn simply means to use index nnn for that parameter. Subsequent bare ? parameter indexes are incremented by 1 from the largest parameter index thus far used. Ie where a= ? and b = ? and c = ?1 and d=? Has 3 parameters. A and C use the same bind index and thus the same parameter. --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Igor Korot > Sent: Sunday, 28 April, 2013 13:05 > To: General Discussion of SQLite Database > Subject: [sqlite] Question about binding > > Hi, ALL, > On the page http://www.sqlite.org/c3ref/bind_blob.html it says: > > [quote] > ..... that matches one of following templates: > > > - ? > - ?NNN > - :VVV > - @VVV > - $VVV > > [/quote] > > > What is the purpose of having "NNN" and "VVV"? Are those standard? How do > I > use those templates? > > Everywhere I see an examples which uses just "?" and no other 4 templates. > > > Thank you. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
