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
