Re: [sqlite] SQLITE Binding Issue when using [] brackets

2012-04-02 Thread Igor Tandetnik
On 4/1/2012 4:23 PM, ap wrote: http://sqlite.org/c3ref/bind_blob.html Brackets are recommended for attribute names in some cases, it seems the binding for :VVV does not permit :[VVV]. Is this the case? This is the case. Parameter names must be proper identifiers. recdct {'[c1]': 1,

Re: [sqlite] SQLITE Binding Issue when using [] brackets

2012-04-02 Thread Simon Davies
On 1 April 2012 21:23, ap wrote: > > http://sqlite.org/c3ref/bind_blob.html > > Brackets are recommended for attribute names in some cases, it seems the > binding for :VVV does not permit :[VVV]. Is this the case? Square brackets are a quoting mechanism for identifiers

[sqlite] SQLITE Binding Issue when using [] brackets

2012-04-02 Thread ap
http://sqlite.org/c3ref/bind_blob.html Brackets are recommended for attribute names in some cases, it seems the binding for :VVV does not permit :[VVV]. Is this the case? I prefer the dictionary binding if possible. Normally no issues, however when I introduce brackets there may be an issue.