[Zope-DB] Re: Typical size of result sets
Wolfram Kraus
kraus at hagen-partner.de
Wed Jan 19 02:57:50 EST 2005
Chris Withers wrote:
> What's a qmark parameter?
>
> Chris
From the Python Database API Specification v2.0
(http://python.org/peps/pep-0249.html):
paramstyle
String constant stating the type of parameter marker
formatting expected by the interface. Possible values are
[2]:
'qmark' Question mark style,
e.g. '...WHERE name=?'
'numeric' Numeric, positional style,
e.g. '...WHERE name=:1'
'named' Named style,
e.g. '...WHERE name=:name'
'format' ANSI C printf format codes,
e.g. '...WHERE name=%s'
'pyformat' Python extended format codes,
e.g. '...WHERE name=%(name)s'
[2] Module implementors should prefer 'numeric', 'named' or
'pyformat' over the other formats because these offer more
clarity and flexibility.
HTH,
Wolfram
More information about the Zope-DB
mailing list