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 )

Reply via email to