>> 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
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
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:
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"=
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
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
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
> 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
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
Hello,
I am trying to use parameters in a simple sql query for sqlite. I have
tried:
var $this_main_detail_id ="34115441312108";
var tbl = $('notes');
while(tbl.rows.length > 0)
tbl.deleteRow(-1);
//var sql = "SELECT main_detail_id FROM main_detail WHERE
main_
10 matches
Mail list logo
