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



Reply via email to