[Zope-DB] Z SQL equivelant of MySQL's SQL_CALC_FOUND_ROWS?
charlie at egenix.com
Tue Nov 29 16:32:03 EST 2005
On 2005-11-29 at 20:20:10 [+0100], Kevin Monceaux <Kevin at RawFedDogs.net>
> Zope Enthusiasts,
> I'm new to Zope so forgive me if the answer to this question is obvious. If
> one performs a select with a limit clause is it possible to determine how
> many results would have been returned if there was no limit? For example,
> if I wanted to select the first picture in a photo album but wanted to know
> the total number of pictures in the album, how would I do that via Z SQL?
> With MySQL it can be done this way:
> SELECT SQL_CALC_FOUND_ROWS, * from Pictures where AlbumID = 25 LIMIT 1;
> SELECT FOUND_ROWS() as Count;
> According to the "Z SQL Methods User's Manual" multiple SQL statements can
> be included in a Z SQL method but that no more than one select statement can
> be included. The above MySQL technique requires two select statements.
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()
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