Thanks for pointing me in the right direction, my solution now is
this:
myvar = dict(page_title="%s" % name)
pages = db.select('myDB', myvar, where="col1 LIKE '%%%s%%'" % name)
which works fine!
On Jun 22, 3:50 pm, René 'Necoro' Neumann <[email protected]> wrote:
> 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.
