Re: Z SQL equivelant of MySQL's SQL_CALC_FOUND_ROWS?

Chris Withers <[email protected]>
Newsgroups gmane.comp.web.zope.database
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.