Re: Sendmail serial email

2002-12-03 Thread Thorsten Scherler
Dear Ray, dear all,

thanks for the reply!

Ray Martin wrote:

Sir,
I too experienced that no one would give any answers.  But, i am wondering
if the cocoon-users mail list server is always behaving correctly.  i am
subscribed to the cocoon-users list, but this is the first time that i have
seen your message.  i did not receive any of your previous postings on this
question.


...and I have posted a lot.



i too got sendmail to work for me slightly.  however, i was never able to
get sendmail to authenticate or to attach a file.

i gave up on sendmail.  Instead i use an action in which i have some JAVA
mail client code.  Now i can control the code exactly to meet my
requirements.  i am no longer dependent on code that has no documentation
beyond a simple tutorial - which in its own self was very interesting - just
no clues as to how to proceed with such things as authentication and file
attachment.

if i can help in any way - a code snippet? - let me know. if you are going
to continue with sendmail, i cannot help.


YES PLEASE LET ME KNOW HOW YOU DID IT. I am not married to sendmail.

You are right in saying the tutorial is not enough, because to attach 
something to mail is quite basic stuff you want to do with mail.

authentication is no point at the moment but it should be possible.


another subject - i know that you are talking about attaching a file to an
email.  but, while we are on the subject of attaching files.  if there is
ever a time when you want to attach a file to an HTTP request  (file
uploading) - cocoon does this automatically.  i was going crazy trying to
figure out how to do it - i accidentally looked in the cocoon upload
directory and there the file was - sitting right there as nice as could be -
kinda like magic.  i would like to know more about the class that was used
to parse the multipart form, but i have not been able to fidn it just yet.

good luck with sending emails,

Ray



-Original Message-
From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 9:49 AM
To: [EMAIL PROTECTED]
Subject: AW: Sendmail serial email


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.ht


ml#sidebar1


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üngliche Nachricht-
Von: Scherler, Thorsten
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=java xmlns:xsp=http://apache.org/xsp;
xmlns:esql=http://apache.org/cocoon/SQL/v2;
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
dataset
esql:connection
esql:poolIDC2/esql:pool
esql:execute-query
esql:query
select * from info where Info_datum = #xsp-request:get-parameter
name=date/#
address
bname1
esql:get-string column=business_name/
/bname1
bname2
esql:get-string column=business_name_2/
/bname2
bname3
esql:get-string column=business_name_3/
/bname3
street
esql:get-string column=address/
/street
ZIP
esql:get-string column=zip_code/
/ZIP
City
esql:get-string column=city/
/City
country
esql:get-string column=country/
/country
telephone_number
esql:get-string column=telephone_number/
/telephone_number
/address
aktion
Info_datum
esql:get-date column=Info_datum/
/Info_datum
/aktion
WD
district
esql:get-string column=district/
/district
ADM
name
esql:get-string column=ADM/
/name
email
esql:get-string column=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.
I have the following sendmail.xsp. I have to replace empfaenger
with the emailesql:get-string column=ADM_email//email :

?xml version=1.0 encoding=UTF-8?
xsp:page language=java xmlns:xsp=http://apache.org/xsp;
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
xmlns:sendmail=http://apache.org/cocoon/sendmail/1.0;
page
xsp:expr
xsp-request:get-parameter name=./ADM/email/
/xsp:expr
xsp:logic
  String empfaenger =
  [EMAIL PROTECTED]\n;
 /xsp:logic
xsp:logic
  String text =
  \n+
  something\n+
  \n+
  more:\n+
  empfaenger;
  /xsp:logic
xsp-request:get-parameter name=date/
sendmail:send-mail
sendmail:charsetISO-8859-1/sendmail:charset
sendmail:from[EMAIL PROTECTED]/sendmail:from
sendmail:to
xsp:exprempfaenger/xsp:expr
/sendmail:to
sendmail:cc
xsp:exprempfaenger/xsp:expr
/sendmail:cc
sendmail:subjectD 200203 V/sendmail:subject
!-- Modify the next line to 

[Fwd: Re: Sendmail serial email]

2002-12-03 Thread Thorsten Scherler
 text/plain; charset=us-ascii; format=flowed: Unrecognized 
---BeginMessage---
Dear Ray, dear all,

thanks for the reply!

Ray Martin wrote:

Sir,
I too experienced that no one would give any answers.  But, i am wondering
if the cocoon-users mail list server is always behaving correctly.  i am
subscribed to the cocoon-users list, but this is the first time that i have
seen your message.  i did not receive any of your previous postings on this
question.


...and I have posted a lot.



i too got sendmail to work for me slightly.  however, i was never able to
get sendmail to authenticate or to attach a file.

i gave up on sendmail.  Instead i use an action in which i have some JAVA
mail client code.  Now i can control the code exactly to meet my
requirements.  i am no longer dependent on code that has no documentation
beyond a simple tutorial - which in its own self was very interesting - just
no clues as to how to proceed with such things as authentication and file
attachment.

if i can help in any way - a code snippet? - let me know. if you are going
to continue with sendmail, i cannot help.


YES PLEASE LET ME KNOW HOW YOU DID IT. I am not married to sendmail.

You are right in saying the tutorial is not enough, because to attach 
something to mail is quite basic stuff you want to do with mail.

authentication is no point at the moment but it should be possible.


another subject - i know that you are talking about attaching a file to an
email.  but, while we are on the subject of attaching files.  if there is
ever a time when you want to attach a file to an HTTP request  (file
uploading) - cocoon does this automatically.  i was going crazy trying to
figure out how to do it - i accidentally looked in the cocoon upload
directory and there the file was - sitting right there as nice as could be -
kinda like magic.  i would like to know more about the class that was used
to parse the multipart form, but i have not been able to fidn it just yet.

good luck with sending emails,

Ray



-Original Message-
From: Scherler, Thorsten [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 9:49 AM
To: [EMAIL PROTECTED]
Subject: AW: Sendmail serial email


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.ht


ml#sidebar1


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üngliche Nachricht-
Von: Scherler, Thorsten
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=java xmlns:xsp=http://apache.org/xsp;
xmlns:esql=http://apache.org/cocoon/SQL/v2;
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
dataset
esql:connection
esql:poolIDC2/esql:pool
esql:execute-query
esql:query
select * from info where Info_datum = #xsp-request:get-parameter
name=date/#
address
bname1
esql:get-string column=business_name/
/bname1
bname2
esql:get-string column=business_name_2/
/bname2
bname3
esql:get-string column=business_name_3/
/bname3
street
esql:get-string column=address/
/street
ZIP
esql:get-string column=zip_code/
/ZIP
City
esql:get-string column=city/
/City
country
esql:get-string column=country/
/country
telephone_number
esql:get-string column=telephone_number/
/telephone_number
/address
aktion
Info_datum
esql:get-date column=Info_datum/
/Info_datum
/aktion
WD
district
esql:get-string column=district/
/district
ADM
name
esql:get-string column=ADM/
/name
email
esql:get-string column=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.
I have the following sendmail.xsp. I have to replace empfaenger
with the emailesql:get-string column=ADM_email//email :

?xml version=1.0 encoding=UTF-8?
xsp:page language=java xmlns:xsp=http://apache.org/xsp;
xmlns:xsp-request=http://apache.org/xsp/request/2.0;
xmlns:sendmail=http://apache.org/cocoon/sendmail/1.0;
page
xsp:expr
xsp-request:get-parameter name=./ADM/email/
/xsp:expr
xsp:logic
  String empfaenger =
  [EMAIL PROTECTED]\n;
 /xsp:logic
xsp:logic
  String text =
  \n+
  something\n+
  \n+
  more:\n+
  empfaenger;
  /xsp:logic
xsp-request:get-parameter name=date/
sendmail:send-mail
sendmail:charsetISO-8859-1/sendmail:charset
sendmail:from[EMAIL PROTECTED]/sendmail:from
sendmail:to
xsp:exprempfaenger/xsp:expr
/sendmail:to
sendmail:cc
xsp:exprempfaenger/xsp:expr