Use "%%".

>>> "%s%%" % 'a'
'a%'

Am 22.06.2011 15:36, schrieb digistam:
> I would like to use a LIKE statment like this:
> 
> myvar = dict(page_title="%s" % name)
> pages = db.select('myDB', myvar, where="col1 like '%$page_title%'")
> 
> This doesn't seem to work, as the internal server error is:
> 
> ProgrammingError: Incorrect number of bindings supplied. The current
> statement uses 0, and there are 1 supplied.
> 
> Can anybody tell me what I do wrong here ?
> Which solution ?
> 

-- 
You received this message because you are subscribed to the Google Groups 
"web.py" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/webpy?hl=en.

Reply via email to