Message 158698 - Python tracker

➜

This issue tracker has been migrated to GitHub, and is currently read-only.
For more information, see the GitHub FAQs in the Python's Developer Guide.

Author	rhettinger
Recipients	rhettinger
Date	2012-04-19.05:14:54
SpamBayes Score	-1.0
Marked as misclassified	Yes
Message-id	<1334812495.3.0.737876206598.issue14619@psf.upfronthosting.co.za>
In-reply-to

Content
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)

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)

History
Date	User	Action	Args
2012-04-19 05:14:55	rhettinger	set	recipients: + rhettinger
2012-04-19 05:14:55	rhettinger	set	messageid: <1334812495.3.0.737876206598.issue14619@psf.upfronthosting.co.za>
2012-04-19 05:14:54	rhettinger	link	issue14619 messages
2012-04-19 05:14:54	rhettinger	create