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.