New submission from Raymond Hettinger <[email protected]>:
I suggest adding a ?? placeholder for variable length substitutions in SQL
statements:
vars = 'Knight', ('Gwain', 'Gallahad', 'Lancelot'), 30
c.execute('''SELECT * FROM loyalsubjects
WHERE rank = ?
AND name IN (??)
AND age >= ?
''', vars)
----------
components: Extension Modules
messages: 158698
nosy: rhettinger
priority: low
severity: normal
status: open
title: Enhanced variable substitution for databases
type: enhancement
versions: Python 3.4
_______________________________________
Python tracker <[email protected]>
<http://bugs.python.org/issue14619>
_______________________________________
_______________________________________________
Python-bugs-list mailing list
Unsubscribe:
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com
