You just hijacked someone else's thread. That is really disrespectful toward the original poster as his question hasn't even been answered yet, but is already "polluted" with a different conversation.
Starting a new thread is free. Please start a new thread for a new issue. On Fri, Mar 19, 2010 at 1:20 PM, Vance E. Neff <ven...@intouchmi.com> wrote: > Question about binding: > > I know how to prepare an INSERT state, for example: > INSERT into table1 values (?, ?, ?); > and in the wrapper I am using I can specify the index # (1, 2 or 3) of > the column and the value in order to set the values. > > The question is: > How to do this with an update statement? Is there a way to specify the > index of the columns used in the where clause? Such as: > UPDATE table1 set (?, ?, ?) WHERE col1=? and col2=?; > > I've never used binding before but have known it is a good idea in order > to avoid injection of bad stuff. > > Vance > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
