[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