6 Jan
2004
6 Jan
'04
3:21 p.m.
On Tue, 6 Jan 2004 09:50:55 -0500 (EST) Asad Habib <ahabib@engin.umich.edu> wrote:
Hello. Does anyone know if there is a way to determine how many rows where retrieved by a select statement? Is there a variable that keeps track of this in Zope that I can access? Any help would be greatly appreciated. Thanks.
SELECT count(*) FROM mytable WHERE myconstraints; or given a resultset from a zsql method: len(results) However the latter may have an upper limit set by the zsql method or the query itself (using the SQL LIMIT keyword) and so may not actually return the full count. -Casey