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. Is this the appropriate
syntax? ([c1],[c2]) VALUES ( :[c1], :[c2] )
>>> recdct
{'[c1]': 1, '[c2]': 2}
>>> cur.execute("""INSERT INTO merge ([c1],[c2]) VALUES ( :[c1], :[c2]
>>> )""",recdct)
Traceback (most recent call last):
File "<pyshell#91>", line 1, in <module>
cur.execute("""INSERT INTO merge ([c1],[c2]) VALUES ( :[c1], :
[c2] )""",recdct)
OperationalError: unrecognized token: ":"
>>>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
