Guy Davis wrote:

1) Given a ZSQL method that takes one arguement (a primary key) how can I pass that information on from where I call the ZSQL method with <dtml-in> i.e. In a DTML method, what comes just before this line if I know that login is davis. <dtml-in getUserSQL size=1 start=query_start>

<dtml-in expr="getUser(login='davis')"> ..do stuff.. </dtml-in>

I have tried: <dtml-let login="_.string.lower('davis')">

<dtml-call "REQUEST.set('login', 'davis')"> This works the first time I call getUserSQL, but breaks the second time with a different login as it appears I can only set the login variable once.

2) Since you can't have <dtml-sendmail mailto="<dtml... get emails from database. (nested <dtml> statements), how does one iteratively declare a list variable and then add to it. Then my mailto="_.string.join(listvar, ', ')" will work.

You need to build a comma-separated list of email addresses and pass it to the sendmail snippet in your code: <dtml-sendmail> To:<dtml-var my_comma_sep_list> MY BODY </dtml-sendmail> You can build the string by using a REQUEST variable. <dtml-var expr="REQUEST.set('my_comma_sep_list', '')> <dtml-in mySQLQueryThatGetsABunchOfEmailAddresses> <dtml-call expr="my_comma_sep_list.append(email_address)"> </dtml-in> It gets more complicated because you need to make sure the email address is "OK" before you append it, otherwise SMTP will choke on it when Zope tries to dump it off (messages will be sent to no one). You can do this by using the monster regular expression on the last page of Jeffrey Friedl's "Mastering Regular Expressions".

It seems the majority of my problems are due to thinking in C,C++ or Java where one can simply declare a variable and then work with it. I haven't figured out how to do that in DTML. Any help you can offer is appreciated.

You might be better off doing all this in an External Method. -- Chris McDonough - Digital Creations, Inc. Publishers of Zope - http://www.zope.org

Chris McDonough already responded to this, but he didn't provide a way to create a list of emails, as opposed to a comma-separated string for use with your string.join(). Guy Davis wrote:

2) Since you can't have <dtml-sendmail mailto="<dtml... get emails from database. (nested <dtml> statements), how does one iteratively declare a list variable and then add to it. Then my mailto="_.string.join(listvar, ', ')" will work.

It seems the majority of my problems are due to thinking in C,C++ or Java where one can simply declare a variable and then work with it. I haven't figured out how to do that in DTML. Any help you can offer is appreciated.

Why can't you get emails from a database? I don't understand. Creating a list is easy in Pythonish DTML: <dtml-call "REQUEST.set('emails', [])"> Appending to the list is easy, too: <dtml-call "emails.append('mew')"> HTH, Ben