Return-Path: 
 <cocoon-users-return-43294-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 51173 invoked by uid 500); 2 Dec 2002 14:49:00 -0000
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-users-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-users-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-users@xml.apache.org>
Reply-To: cocoon-users@xml.apache.org
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 51121 invoked from network); 2 Dec 2002 14:48:59 -0000
content-class: urn:content-classes:message
Subject: AW: Sendmail serial email
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Date: Mon, 2 Dec 2002 15:49:29 +0100
X-MimeOLE: Produced By Microsoft Exchange V6.0.6344.0
Message-ID: <3671ACD9D9D5C648A6181F8048DC9A5D7C6C28@srvde016.weidmueller.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Sendmail serial email
Thread-Index: AcKaAn0AVfwlVCfHRRGVQR8tD+vH7gADxthw
From: "Scherler, Thorsten" <Thorsten.Scherler@weidmueller.de>
To: <cocoon-users@xml.apache.org>
X-OriginalArrivalTime: 02 Dec 2002 14:49:29.0719 (UTC)
 FILETIME=[049B9870:01C29A12]
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Hello group,

I don't know why I don't get any answers on that topic, but it is quit =
frustrating.

http://www.javaworld.com/javaworld/jw-09-2002/jw-0920-cocoon-p2.html#side=
bar1

There you can find how to nested a esql with sendmail.

It is working!

Now I just suffering how to attach a pdf.

...but I don't think I will get any answers on that,or?

:-(

-----Urspr=FCngliche Nachricht-----
Von: Scherler, Thorsten=20
Gesendet: Montag, 2. Dezember 2002 13:58
An: Cocoon-Dev (E-Mail); Cocoon-Users (E-Mail)
Betreff: Sendmail serial email


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=3D"java" xmlns:xsp=3D"http://apache.org/xsp" =
xmlns:esql=3D"http://apache.org/cocoon/SQL/v2" =
xmlns:xsp-request=3D"http://apache.org/xsp/request/2.0">
<dataset>
<esql:connection>
<esql:pool>IDC2</esql:pool>
<esql:execute-query>
<esql:query>
select * from info where Info_datum =3D #<xsp-request:get-parameter =
name=3D"date"/>#=20
<address>
<bname1>
<esql:get-string column=3D"business_name"/>
</bname1>
<bname2>
<esql:get-string column=3D"business_name_2"/>
</bname2>
<bname3>
<esql:get-string column=3D"business_name_3"/>
</bname3>
<street>
<esql:get-string column=3D"address"/>
</street>
<ZIP>
<esql:get-string column=3D"zip_code"/>
</ZIP>
<City>
<esql:get-string column=3D"city"/>
</City>
<country>
<esql:get-string column=3D"country"/>
</country>
<telephone_number>
<esql:get-string column=3D"telephone_number"/>
</telephone_number>
</address>
<aktion>
<Info_datum>
<esql:get-date column=3D"Info_datum"/>
</Info_datum>
</aktion>
<WD>
<district>
<esql:get-string column=3D"district"/>
</district>
<ADM>
<name>
<esql:get-string column=3D"ADM"/>
</name>
<email>
<esql:get-string column=3D"ADM_email"/>
</email>
</ADM>
</WD>
</client>
</esql:row-results>
</esql:results>
<esql:no-results/>
<esql:error-results/>
</esql:execute-query>
</esql:connection>
</dataset>
</xsp:page>

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

<?xml version=3D"1.0" encoding=3D"UTF-8"?>
<xsp:page language=3D"java" xmlns:xsp=3D"http://apache.org/xsp" =
xmlns:xsp-request=3D"http://apache.org/xsp/request/2.0" =
xmlns:sendmail=3D"http://apache.org/cocoon/sendmail/1.0">
<page>
<xsp:expr>
<xsp-request:get-parameter name=3D"./ADM/email"/>
</xsp:expr>
<xsp:logic>  =20
   String empfaenger =3D=20
   "thorsten.scherler@weidmueller.de\n";
  </xsp:logic>
<xsp:logic>
   String text =3D
   "\n"+
   "something\n"+
   "\n"+
   "more:\n"+
   empfaenger;
   </xsp:logic>
<xsp-request:get-parameter name=3D"date"/>
<sendmail:send-mail>
<sendmail:charset>ISO-8859-1</sendmail:charset>
<sendmail:from>user@mydomain.com</sendmail:from>
<sendmail:to>
<xsp:expr>empfaenger</xsp:expr>
</sendmail:to>
<sendmail:cc>
<xsp:expr>empfaenger</xsp:expr>
</sendmail:cc>
<sendmail:subject>D 200203 V</sendmail:subject>
<!-- Modify the next line to point to your mail server -->
<sendmail:smtphost>mail.weidmueller.com</sendmail:smtphost>
<sendmail:body>
<xsp:expr>text</xsp:expr>
<xsp-request:get-parameter name=3D"date"/>
</sendmail:body>
</sendmail:send-mail>
<send>ok</send>
</page>
</xsp:page>

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,
>=20
> Thorsten Scherler
> Marketing / Telefonmarketing
>=20
> Weidm=FCller GmbH & Co.
> P.O. Box 2807
> 33058 Paderborn
> Tel.:+ 49 - 5252-960-350
> Fax:+ 49 - 5252-960-116
> eMail: thorsten.scherler@weidmueller.de
> http://www.weidmueller.de
>=20
>=20

---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>