[DB-SIG] Escaping Placeholders

M.-A. Lemburg mal at egenix.com
Tue Jul 6 21:56:32 CEST 2004

Peter L. Buschman wrote:
> I know there must be an obvious answer to this question, but what is the 
> standard mechanism
> for escaping placeholders in dbapi execute method calls?
> Eg., when using the qmark paramstyle and I want to include a literal 
> question-mark, do I use \?, '?', ??,

Depends on where you want to use it. Having the ? inside a
string literal is no problem at all and doesn't require
escaping, e.g. 'questions?'. I don't know where else you'd
want to use a literal question mark in the SQL that should
not be interpreted as parameter marker.

Do you have examples ?

> or something else entirely? Ditto for format, named, etc., in any 
> situations where literal text in the query
> might be mistaken for a placeholder.

Marc-Andre Lemburg

Professional Python Services directly from the Source  (#1, Jul 06 2004)
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::

More information about the DB-SIG mailing list