cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Scherler, Thorsten" <>
Subject Sendmail serial email
Date Mon, 02 Dec 2002 12:58:19 GMT
Hello group,

I am still trying to send a serial email with cocoon ... and I am stucked big time

I got the sendmail logic sheet runnig (without the possiblity to attach a file or a URL).

I have my query (with esql) running.

Now I want to do the following:
The query looks for the date on which information has to be send (info.xsp:)
<xsp:page language="java" xmlns:xsp="" xmlns:esql=""
select * from info where Info_datum = #<xsp-request:get-parameter name="date"/># 
<esql:get-string column="business_name"/>
<esql:get-string column="business_name_2"/>
<esql:get-string column="business_name_3"/>
<esql:get-string column="address"/>
<esql:get-string column="zip_code"/>
<esql:get-string column="city"/>
<esql:get-string column="country"/>
<esql:get-string column="telephone_number"/>
<esql:get-date column="Info_datum"/>
<esql:get-string column="district"/>
<esql:get-string column="ADM"/>
<esql:get-string column="ADM_email"/>

Now I want to send each ADM an eMail. 
I have the following sendmail.xsp. I have to replace "empfaenger" with the <email><esql:get-string
column="ADM_email"/></email> :

<?xml version="1.0" encoding="UTF-8"?>
<xsp:page language="java" xmlns:xsp="" xmlns:xsp-request=""
<xsp-request:get-parameter name="./ADM/email"/>
   String empfaenger = 
   String text =
<xsp-request:get-parameter name="date"/>
<sendmail:subject>D 200203 V</sendmail:subject>
<!-- Modify the next line to point to your mail server -->
<xsp-request:get-parameter name="date"/>

How can I do that?

Write a xsl with Processing instruction to build the sendmail file on the fly?

I would rather like not to have to do that!

Any ideas?

> Mit freundlichem Gruss,
> Thorsten Scherler
> Marketing / Telefonmarketing
> Weidmüller GmbH & Co.
> P.O. Box 2807
> 33058 Paderborn
> Tel.:+ 49 - 5252-960-350
> Fax:+ 49 - 5252-960-116
> eMail:

Please check that your question  has not already been answered in the
FAQ before posting.     <>

To unsubscribe, e-mail:     <>
For additional commands, e-mail:   <>

View raw message