You could always do something like this first:
"select Count(usr_email) from info(table name) where usr_email =
<dtml-sqlvar usr_email type=string>"
Then check the result will be either 1 or 0.
That's asking for trouble 'cos Zope ain't gonna like an id such as
'Count(usr_email)', it's a great idea though :-)
Here's how you might need to rephrase it to make Zope happy:
"select Count(usr_email) as usremail from info(table name) where
usr_email = <dtml-sqlvar usr_email type=string>"
HTH,
Chris
_______________________________________________
Zope maillist - [EMAIL PROTECTED]
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 )