On Sat, May 4, 2013 at 8:59 AM, Stephan Beal <[email protected]> wrote:
> Consider this SQL > snippet: > > UPDATE foo SET x=:param1, y=:param1 ... > > As i understand it (possibly incorrectly!), the bind-by-param-name API will > properly set both instances of ":param1", but as far as i can find there is > no way to programatically get both indexes: sqlite3_bind_parameter_index() > will return only the first index: > There is only one index to get. If you use the same parameter name (say ":param1") N times in the same statement, then you only have to bind it once and all N instances of that parameter take on the same value. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
