I think you might need to do something like:
tag = 'HTTP'
entrys = web.select(tbx+'entrys', where='tags like $tag',
vars={'tag':'%'+tag+'%'})
Otherwise it's adding in the single quote's around the text between
the percent symbols.
-d
On Oct 15, 8:11 am, "大郎" <[EMAIL PROTECTED]> wrote:
> entrys = web.select(tbx+'entrys', where='tags like \'%%$tag%%\'',
> vars=locals())
>
> i use like above, return the sql:
>
> SELECT * FROM venus_entrys WHERE tags like '%'HTTP'%'
>
> '%'HTTP'%'
>
> it happend an error.
>
> On 10/15/07, Anand <[EMAIL PROTECTED]> wrote:
>
>
>
>
>
> > On 14-Oct-07, at 4:32 PM, Ken wrote:
>
> > > # code.py
> > > entrys = web.select(tbx+'entrys', where='tags like \'%$tag%\'',
> > > vars=locals())
> > > ...
>
> > use %% to protect %.
>
> --
> 每个人都有一片属于自己的森林, 迷失的人迷失了, 相逢的还会再相逢...
> Gtalk: iexper(at)gmail.com
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
