homepage

➜

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.

In-reply-to
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>

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)

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)

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