[Zope] sql query

Ken Kinder kkinder@messagemedia.com
Mon, 10 Apr 2000 14:23:30 -0600


I take it you just want the number of rows returned from a query. Try
a query like this...

	select count(*) from table where [...]

Oai Luong wrote:
> 
> I have a link that when the user clicks on it queries that database
> using a method.  The database is postgres.   what is want is beside the
> link  in parenthesis displaying  how many rows are in that table.  For
> example:
> 
> Employees (45)
> Companies (46)
> 
> I think you would use a counter for this right ??  How would i approach
> this ?  The number should be dynamic so that as it increase the number
> will increase automatically.
> 
> Thanks
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )

-- 
Ken Kinder
303.381.7631