... autos.out='T' and autos.out='F' ... ?
On Apr 25, 12:34 am, cyber <[email protected]> wrote: > I used to use construction like this: > rows_count=db(db.autos.out=='T').count(), but my real query consists > of many conditions. So I decided to use executesql. > > By the way, I wrote the code: > rows_count = db.executesql("SELECT count(1) FROM autos WHERE > autos.out='T' and autos.out='F' and autos.idk='F' and autos.svh='F' > and autos.rad='F' and autos.out='F' and autos.tranzit='F'", > as_dict=False) > rows_count=rows_count[0][0] > I think this construction is more preferable for me. > > And thank you very much for the help. Your advice was very helpfull > for me. > ********************************************************** > > On 23 апр, 21:35, Vasile Ermicioi <[email protected]> wrote: > > > > > > > > > but it is nicer if you have models (you can generate them from database > > tables) > > > print db(db.autos.out=='T').count()
