[Zope-DB] Z SQL equivelant of MySQL's SQL_CALC_FOUND_ROWS?

Chris Withers chris at simplistix.co.uk
Wed Nov 30 14:06:21 EST 2005


Charlie Clark wrote:
> You can use <dtml-var sqldelimiter> - search the archives for that.
> But that is wrong. 

Why?

> If you want to count the number of records, use count()

That doesn't work if you use offsets and limits to only return part of a 
result set...

cheers,

Chris

-- 
Simplistix - Content Management, Zope & Python Consulting
            - http://www.simplistix.co.uk



More information about the Zope-DB mailing list