[Zope] Finding out how many rows is selected in database

[Thomas B. Passin]

Use some variation on this:
Assume the query method is called "query1"

<!-- Execute the query -->
<dtml-let results=query1>
   <!-- display the number of rows -->
    There are <dtml-var "_.len(results)"> rows in the results.
</dtml-let>

In your case, you would probably want to assign the number of rows to a
variable - maybe with dtml-let - and use  it in a dtml-if element.

Cheers,

Tom P



Gitte Wange
Subject: [Zope] Finding out how many rows is selected in database


> How do I do subject ?
>
> I need to do one thing if any rows is returned and another if there is
> no records in the database