Hi Phil,
I have the same kind of action to perform, I do it by including the sendmail
section inside the esql:row-results. Maybe there're other ways to do it, but
here's a snippet that works for me :
<esql:connection>
<esql:pool>dvdadmin</esql:pool>
<esql:execute-query>
<esql:query>SELECT * FROM users WHERE
email='<xsp-request:get-parameter name="email"/>'</esql:query>
<esql:results>
<table>
<esql:row-results>
<xsp:logic>
String smtphost = <util:get-sitemap-parameter name="smtphost"/> ;
String msg ="Voici votre login : \n";
String userId = <esql:get-string column="user_id"/>;
String pass = <esql:get-string column="pass"/>;
String email = <esql:get-string column="email"/>;
String msg2 ="\n Voici votre password : \n";
</xsp:logic>
<mail:send-mail>
<mail:charset>ISO-8859-1</mail:charset>
<mail:smtphost><xsp:expr>smtphost</xsp:expr></mail:smtphost>
<mail:from>[EMAIL PROTECTED]</mail:from>
<mail:to><xsp:expr>email</xsp:expr></mail:to>
<mail:subject>Votre profil DVD à la carte</mail:subject>
<mail:body><xsp:expr>msg</xsp:expr><xsp:expr>userId</xsp:expr><xsp:expr>msg2
</xsp:expr><xsp:expr>pass</xsp:expr></mail:body>
</mail:send-mail>
</esql:row-results>
</table>
</esql:results>
<esql:no-results>
<p class="titre-2">Cette adresse n'est pas enregistrée.</p>
</esql:no-results>
</esql:execute-query>
</esql:connection>
HTH,
Julien
----- Original Message -----
From: "Philippe Guillard" <[EMAIL PROTECTED]>
To: "users cocoon" <[EMAIL PROTECTED]>
Sent: Wednesday, March 17, 2004 9:21 AM
Subject: ESQL result pushed in sendmail in same XSP page?
> Hi all,
> I make the serverpage generator treat ESQL and sendmail in the same
> .xsp, and i'd like to pass the parameter i get from my ESQL statement in
> the sendmail generation.
>
> Question :
> - I'd like to know if this is possible?
> - If not, what solution could avoid this situation
> (XSP Action for ESQL before sendmail generation?)
>
> Regards,
>
> Phil
>
> My Sample : below i get the user's password first with ESQL then
> sendmail it to the user, here the error is "yourpassword cannot be
> resolved":
>
> <?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:esql="http://apache.org/cocoon/SQL/v2";
>
> xmlns:sendmail="http://apache.org/cocoon/sendmail/1.0";>
> <page>
> <title>title</title>
> <esql:connection>
> <esql:pool>mypool</esql:pool>
> <esql:execute-query>,
> <esql:query>select password from USER where
> email=<esql:parameter><xsp-request:get-parameter
> name="email"/></esql:parameter></esql:query>
> <esql:results>
> <esql:row-results>
> <xsp:logic>
> String yourpassword = new String(<esql:get-string
> column="password"/>);
> </xsp:logic>
> </esql:row-results>
> </esql:results>
> <esql:no-results>
> </esql:no-results>
> </esql:execute-query>
> </esql:connection>
> <sendmail:send-mail>
> <sendmail:smtphost>localhost</sendmail:smtphost>
> <sendmail:from>[EMAIL PROTECTED]</sendmail:from>
> <sendmail:to><xsp-request:get-parameter
> name="email"/></sendmail:to>
> <sendmail:subject><xsp:expr>subject</xsp:expr></sendmail:subject>
>
> <sendmail:body><xsp:expr>yourpassword</xsp:expr></sendmail:body>
> </sendmail:send-mail>
> </page>
> </xsp:page>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
