... or the equivalent raw sql
results=db.executesql("SELECT * FROM autos WHERE num LIKE %%%s%%;"
%n)
On Apr 5, 4:45 pm, DenesL <[email protected]> wrote:
> I believe you want
>
> results=db(db.autos.num.contains(n)).select()
>
> On Apr 5, 3:58 pm, cyber <[email protected]> wrote:
>
>
>
>
>
>
>
> > I need a hint!
>
> > It seems that LIKE operator doesn't work.Or... I'm not so clever
> > human...
>
> > Say, how can I deal with rawsql query? I need to find all records but
> > I know only some part of exact value. The code:
>
> > n=request.vars.num ### it returns only number
> > results=db.executesql("SELECT * FROM autos WHERE num LIKE %s;" %(n))
> > ### select
> > return dict(results=results) ### it returns rows with exact n values
> > only
>
> > ... how can I find all records (not only n) including missed nums and
> > chars?
