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.