--- On Fri, 3/19/10, Vance E. Neff <ven...@intouchmi.com> wrote:
<snip> > 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 > You count the question marks from left to right. > UPDATE table1 set (<1>, <2>, <3>) WHERE col1=<4> and col2=<5>; You can also put the index number you want to use after the ? so they can be in any order you want. > UPDATE table1 set (?3, ?4, ?5) WHERE col1=?1 and col2=?2; Which comes in handy if you need to use a value in more than one spot. As far as I know "set (?, ?, ?)" is incorrect SQL. David _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users