After pulling my hair out all morning over this one... enough is enough... 
OK, Another one for thi list I think!

I am using ESQL to retrieve some data from a mysql database. On sucess I 
want to call an xsl template, passing it the esql result as a parameter. I 
have thge following code which works fine in that it calls displays the 
template ok, but the perameter doesn't include the esql result:

<xsp:logic> 
if ( <param:userId /> and <param:email /> ) { 
        ... conection details ...
<esql:results> 
        <esql:row-results> 
                <xsp:content> 
                        <xsl:call-template name="
displayPasswordRecoveryResult"> 
                                <xsl:with-param name="password"> 
                                        <esql:get-string column="password" 
/> 
                                </xsl:with-param> 
                        </xsl:call-template> 
                </xsp:content> 
</esql:row-results> 
</esql:results> 
</esql:execute-query> 
</esql:connection>
...

I tried a slightly different route - setting up a xsl:variable to hold the 
result of the esql query, but when I encaplulated the esql stuff inside an 
xsl:variable tag, the variable just contained the node contents 
(consisting of the text() from the esql bit) rather than the result of the 
query.

How can I get either of these routes to work correctly?

thanks

-- 
Tom David Kirkpatrick
Virus Bulletin Web Developer, Virus Bulletin

Tel: +44 1235 555139
Web: www.virusbtn.com


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to