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, '[c2]': 2}
cur.execute("""INSERT INTO merge ([c1],[c2]) VALUES ( :[c1], :[c2]
)""",recdct)
Nothing says that parameter names must match column names. You could
name your parameters :c1 and :c2, or :x and :y, or :foo and :bar.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users