[Zope] list of users tied to database

[tom smith]

I'm trying to create a list of users' emails. There is a table called
"tblUsers" and a field called "Email".

I have created a sql method called "get_email(UserName)" which works fine.



<dtml-in "theOTHERintranet.acl_users.getUserNames()">
  <dtml-in "get_email('UserName=<dtml-var sequence-item>')">
                 <dtml-var Email><br>
             </dtml-in>
        </dtml-in>

any ideas anyone?

thanks

tom