hi guys,

thanks for everyones help. I was trying to fish some values (email
addresses) from database based on the value of someone's username in an
acl_users folder.  I got it working, I think part of the problem is that
ZSQL Methods seem to be real picky about their params. For example "theName"
doesn't work as a param but "theName:string" does.

Anyway, here's my code

tom



dtml_method
---------------------------------------------
<dtml-in "theOTHERintranet.acl_users.getUserNames()">

<dtml-let uName="_['sequence-item']">

<dtml-in "get_email(theName=uName)">
       <a href="mailto:<dtml-var Email>"><dtml-var UserName></a><br>
</dtml-in>

</dtml-let>
   
</dtml-in>
-----------------------------------------------


sql_method "get_email"
--------------------------------------------

params :theName:string

select UserName, Email from tblUsers
where 
UserName = '<dtml-var theName>';




_______________________________________________
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