Matt Wilson wrote:
Normally python programmers would like to see named arguments in
dictionary substation format:
d = { 'blob': 'a\0b', 'id': 2 }
cursor.execute("UPDATE t1 SET value=%(bigblob)s WHERE rowid=%(id)d", d)
I'd be willing to extend the lexer/parser of SQLite to accept this kind
of thing. The only problem here is that '%' is already used to mean the
remainder-after-integer-division operator, like in C. Could another
character be used instead? "@" perhaps? Or maybe two "%%" instead of
just '%'?
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565