[Zope-DB] Z SQL equivelant of MySQL's SQL_CALC_FOUND_ROWS?
charlie at egenix.com
Thu Dec 1 04:06:29 EST 2005
On 2005-11-30 at 20:06:21 [+0100], Chris Withers <chris at simplistix.co.uk>
> Charlie Clark wrote:
> > You can use <dtml-var sqldelimiter> - search the archives for that.
> > But that is wrong.
> > 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...
SELECT count(attribute) FROM relatiin WHERE condition
only returns 1 result so it's independent of LIMIT and result sets.
Of course, ZopeDAs such as our mxODBCZopeDA can be extended to support
additional commands on the connection but that is not part of the ZSQL
specification and will vary from RDBMS to RDBMS as the initial mail noted.
Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ... http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/
2005-10-17: Released mxODBC.Zope.DA 1.0.9 http://zope.egenix.com/
::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::
More information about the Zope-DB