Denes, you opened my eyes to me again. *************************************************** I tried to use %%s%% and there was an error message. So, the only one character % separated me from the correct result!
And say what way is more preferable to use: db.select() or db.executesql() ? By the way, thank you very much! *************************************************** On 5 апр, 23:48, DenesL <[email protected]> wrote: > ... 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?
