I am trying to implement a "forgot password" page using XSP. This seems like
it should be a no brainer. I want to query my user database using <esql:*>
and retrieve the users email address and password then mail it to the user
using <mail:*>. However, to do so, it would seem that I need to get the data
that esql returns into a variable. When I try to do this, the code generator
gets confused. Can this be done? If so, what am I doing wrong?
The relevant snippit of xsp is as follows. I have tried various permutations
of this code with xsp:logic and esql:rowresults used and not used but the
results all fail to generate java that compiles.
<esql:execute-query>
<esql:query>
SELECT firstname, lastname, password FROM user, userdetail
WHERE user.user = '<xsp:expr>user</xsp:expr>'
AND user.user = userdetail.user
</esql:query>
<esql:results>
<esql:rowresults>
<xsp:logic>
<!--PROBLEM IS HERE! -->
firstname = <esql:get-string column="firstname"/> ;
lastname = <esql:get-string column="lastname"/> ;
password = <esql:get-string column="password"/> ;
<!-- body of mail message built up here ...
<--snip-->
-->
</xsp:logic>
</esql:rowresults>
<mail:send-mail>
<mail:charset>ISO-8859-1</mail:charset>
<mail:smtphost>smtp.somehost.com</mail:smtphost>
<mail:from>[EMAIL PROTECTED]</mail:from>
<mail:to><xsp:expr>user</xsp:expr></mail:to>
<mail:subject>Message from XXXXX</mail:subject>
<mail:body><xsp:expr>body</xsp:expr></mail:body>
<mail:on-success>
<passwordSent><xsp:expr>user</xsp:expr></passwordSent>
</mail:on-success>
<mail:on-error>
<ERROR>An error occurred while sending mail:
<mail:error-message/></ERROR>
</mail:on-error>
</mail:send-mail>
</esql:results>
<esql:no-results>
---------------------------------------------------------
Sal Mangano
Into Technology Inc.
www.into-technology.com
Use XSLT? Try the XSLT Cookbook
http://www.oreilly.com/catalog/xsltckbk/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
