[Zope] how to check if the ResultSet is null?

[Christopher J. Kucera]

> Sa wrote:
> 
> Hi, I stuck on a problem: I am creating a registration form. I need to check
> if the person info has already in database. I created a Z SQL method which I
> used "select usr_email from info(table name) where usr_email = <dtml-sqlvar
> usr_email type=string>" I want to call this method from my dtml method and
> see if it returns "null". But I'm not sure how to implement this. In Java,
> it has ResultSet which I can check if it returns null. I'm not sure how to
> accomplish this in Zope. I could not find relevant document. If you know
> this, could you give me a hand? Thanks!

If your ZSQL Method is named MyMethod:

<dtml-in MyMethod>
  You've got some data
<dtml-else>
  Nothing returned from the SQL
</dtml-in>

Hope that helps . . .

-CJ