i think i had a similar problem with sqllite, i moved the project to mysql and it worked fine...
On Jul 22, 11:47 am, Timuçin Kızılay <[email protected]> wrote: > I'm trying to make a query like this: > > prc_filter = 24 > > q_sometable = DBSession.query(model.Sometable) > q_sometable = q_sometable.filter((model.Sometable.qty * > model.Sometable.price)==prc_filter) > > This do not give any error and when I look at the paster log I see that > it generated a query with where part like this: > > ------------ > WHERE sometable.qty * sometable.price = ? > > 12:41:24,272 INFO [sqlalchemy.engine.base.Engine.0x...ba0c] ['24'] > > ---------- > > When I copy the quety from terminal window and run it in a sqlite tool > (SQL Database Browser) it works. > > Can anyone help? > what am I doing wrong? -- You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears?hl=en.
