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

Sa slin@iastate.edu
Wed, 12 Jul 2000 17:03:49 -0500


This is a multi-part message in MIME format.

------=_NextPart_000_0085_01BFEC23.25E2E320
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 =3D <dtml-sqlvar usr_email type=3Dstring>" 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!

Sa

------=_NextPart_000_0085_01BFEC23.25E2E320
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>

<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 face=3DArial size=3D2>Hi, I stuck on a =
problem: I am=20
creating a registration form. I need to check if the person info has =
already in=20
database. I created a Z SQL method which I used &quot;select usr_email =
from=20
info(table name) where usr_email =3D &lt;dtml-sqlvar usr_email=20
type=3Dstring&gt;&quot; I want to call this method from my dtml method =
and see if=20
it returns &quot;null&quot;. But I'm not sure how to implement this. In =
Java, it=20
has ResultSet which I can check if it returns null. I'm not sure how to=20
accomplish this in Zope. I could not find relevant document. If you know =
this,=20
could you give me a hand? Thanks!</FONT></DIV>
<DIV><FONT color=3D#000000 face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000000 face=3DArial =
size=3D2>Sa</FONT></DIV></BODY></HTML>

------=_NextPart_000_0085_01BFEC23.25E2E320--