|
From: SourceForge.net <no...@so...> - 2006-03-15 17:52:36
|
Patches item #1450564, was opened at 2006-03-15 09:52 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540674&aid=1450564&group_id=74338 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: Limit keyword does not with orderBy Initial Comment: When performing a select query over a table, the limit keyword will not be used if orderBy is specified. For example, class Test(SQLObject): total IntCol(notNull=True) # create SQL connection and stuff ... res = Test.select(orderBy='total', limit=10) The results will contain every row from Test, since the resultant SQL query is similar to "SELECT id, total FROM test ORDER BY total" No LIMIT attribute is ever specified. Looking at the code, this is because limit will only work when used with the start or end keyword. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540674&aid=1450564&group_id=74338 |
