[sqlalchemy] SqlAlchemy limiting returned rows prematurely

2009-06-26 Thread Mike Driscoll
Hi, I am having an issue with what is getting returned from my SA query. Here's my code: beginDate = "1/1/2007" endDate = "12/31/2007" qry = session.query(CheckHistory.CHK_DOC_NO, CheckHistory.EMP_ID, CheckHistory.CHECK_DATE, CheckHis

[sqlalchemy] sqlalchemy limiting

2006-12-05 Thread dischdennis
At startup of a zope application I am mapping the complete resultset for all users. Now I would like to restrict the resultset depending on the logged user before showing in table view because it takes a long time in table view when having 1 rows mapped. How is it possible to restrict on the