Re: [sqlite] Binding parameters to prepared statements

2009-08-25 Thread John Elrick
>> Although quotes can be used, they are not needed when the table and >> field names contain all valid characters. I simply saw no value in >> adding them, and they did seem to unnecessarily complicate the text. >> >> > It also says on http://www.sqlite.org/lang_keywords.html that

Re: [sqlite] Binding parameters to prepared statements

2009-08-25 Thread Jay A. Kreibich
On Tue, Aug 25, 2009 at 11:19:17AM -0400, Angus March scratched on the wall: > It also says on http://www.sqlite.org/lang_keywords.html that in > case you use a name that one day becomes a keyword you should always use > quotes. It is also quite specific about which quotes to use: single-q

Re: [sqlite] Binding parameters to prepared statements

2009-08-25 Thread Angus March
John Elrick wrote: > Angus March wrote: > >> John Elrick wrote: >> >> >>> Angus March wrote: >>> >>> >>> I'm trying to make a prepared statement and bind parameters to it, but the documentation is very confusing. This is the statement I'm trying to prepare:

Re: [sqlite] Binding parameters to prepared statements

2009-08-25 Thread John Elrick
Angus March wrote: > John Elrick wrote: > >> Angus March wrote: >> >> >>> I'm trying to make a prepared statement and bind parameters to it, but >>> the documentation is very confusing. This is the statement I'm trying to >>> prepare: >>> UPDATE 'KEYS' SET 'IVAndKey'=:VVV WHERE "ItemID"=

Re: [sqlite] Binding parameters to prepared statements

2009-08-25 Thread Angus March
John Elrick wrote: > Angus March wrote: > >> I'm trying to make a prepared statement and bind parameters to it, but >> the documentation is very confusing. This is the statement I'm trying to >> prepare: >> UPDATE 'KEYS' SET 'IVAndKey'=:VVV WHERE "ItemID"=?NNN >> Where IVAndKey is a BLOB and Ite

Re: [sqlite] Binding parameters to prepared statements

2009-08-25 Thread Angus March
Pavel Ivanov wrote: >> UPDATE 'KEYS' SET 'IVAndKey'=:VVV WHERE "ItemID"=?NNN >> Where IVAndKey is a BLOB and ItemID is an INTEGER and the primary key >> for the table. I'm told that there is a syntax error near "NNN". >> > > You have actually used some number instead NNN and wrote it here just

Re: [sqlite] Binding parameters to prepared statements

2009-08-25 Thread John Elrick
Angus March wrote: > I'm trying to make a prepared statement and bind parameters to it, but > the documentation is very confusing. This is the statement I'm trying to > prepare: > UPDATE 'KEYS' SET 'IVAndKey'=:VVV WHERE "ItemID"=?NNN > Where IVAndKey is a BLOB and ItemID is an INTEGER and the prima

Re: [sqlite] Binding parameters to prepared statements

2009-08-25 Thread Pavel Ivanov
> UPDATE 'KEYS' SET 'IVAndKey'=:VVV WHERE "ItemID"=?NNN > Where IVAndKey is a BLOB and ItemID is an INTEGER and the primary key > for the table. I'm told that there is a syntax error near "NNN". You have actually used some number instead NNN and wrote it here just for abstract example, haven't you

[sqlite] Binding parameters to prepared statements

2009-08-25 Thread Angus March
I'm trying to make a prepared statement and bind parameters to it, but the documentation is very confusing. This is the statement I'm trying to prepare: UPDATE 'KEYS' SET 'IVAndKey'=:VVV WHERE "ItemID"=?NNN Where IVAndKey is a BLOB and ItemID is an INTEGER and the primary key for the table. I'm tol