Re: [sqlite] Question about binding

gn 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 14:53 > > To: General Dis

Re: [sqlite] Question about binding

> Sent: Sunday, 28 April, 2013 14:53 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Question about binding > > Hi, Keith, > > On Sun, Apr 28, 2013 at 12:34 PM, Keith Medcalf > wrote: > > > > > http://www.sqlite.o

Re: [sqlite] Question about binding

ribbon.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 > > Subje

Re: [sqlite] Question about binding

-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/c

[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

Re: [sqlite] Question about binding

Thanks Pavel! Vance Pavel Ivanov wrote: >> Is there documentation that talks about about the various binding place >> holders or is this a standard SQL construct? > > Probably this will help you: http://www.sqlite.org/c3ref/bind_blob.html. > > > Pavel > > On Tue, Mar 23, 2010 at 3:48 PM, Vanc

Re: [sqlite] Question about binding

4, 2010 at 4:06 PM, Pavel Ivanov wrote: > Yes, they are the same. > > Pavel > > On Wed, Mar 24, 2010 at 4:04 PM, a1rex wrote: > >* :VVV > >* @VVV > >* $VVV > > Are above bindings the same? (Just different prefix to VVV)? > > Thank you, &

Re: [sqlite] Question about binding

eneral Discussion of SQLite Database > Sent: Wed, March 24, 2010 2:16:34 PM > Subject: Re: [sqlite] Question about binding > >> Is there documentation that talks about about the various binding place >> holders or is this a standard SQL construct? > > Probably this wil

Re: [sqlite] Question about binding

* :VVV * @VVV * $VVV Are above bindings the same? (Just different prefix to VVV)? Thank you, Samuel From: Pavel Ivanov To: General Discussion of SQLite Database Sent: Wed, March 24, 2010 2:16:34 PM Subject: Re: [sqlite] Question about binding

Re: [sqlite] Question about binding

> Is there documentation that talks about about the various binding place > holders or is this a standard SQL construct? Probably this will help you: http://www.sqlite.org/c3ref/bind_blob.html. Pavel On Tue, Mar 23, 2010 at 3:48 PM, Vance E. Neff wrote: > Thanks to all those who responded!  It

Re: [sqlite] Question about binding

Thanks to all those who responded! It was quite educational. I'm using the zentus java jdbc wrapper. It seems to only support an index # for the binding index so I'm stuck with being careful as to how I count ?s. Is there documentation that talks about about the various binding place holders o

Re: [sqlite] Question about binding

On Fri, Mar 19, 2010 at 3:56 PM, D. Richard Hipp wrote: > It doesn't get any cleaner than this. > Unfortunately, other programming languages require more complex > syntax. Except PL/SQL language which is simpler/cleaner in that it lets you use local or package level variables directly in SQL with

Re: [sqlite] Question about binding

On Mar 19, 2010, at 3:29 PM, David Bicking wrote: > > > --- On Fri, 3/19/10, Vance E. Neff wrote: > > >> 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 >> > >

Re: [sqlite] Question about binding

--- On Fri, 3/19/10, Vance E. Neff wrote: > 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

Re: [sqlite] Question about binding

On Fri, Mar 19, 2010 at 03:13:19PM -0400, Vance E. Neff scratched on the wall: > First of all, I apologize for hijacking the thread! I did not intend > to, I just screwed up! > > Second: > Question about binding: > > I know how to prepare an INSERT state, for example: > INSERT into table1 value

Re: [sqlite] Question about binding

You can do it like this: UPDATE table1 set col1 = ?, col2 = ?, col3 = ? WHERE col1=? and col2=?; And don't confuse indexes of columns and indexes of parameters. To mention indexes of parameters explicitly I'd suggest to do it like this: UPDATE table1 set col1 = ?1, col2 = ?2, col3 = ?3 WHERE col

[sqlite] Question about binding

First of all, I apologize for hijacking the thread! I did not intend to, I just screwed up! Second: 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