[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

ESQL result inside xsl

Subject: ESQL result inside xsl
From: tom.kirkpatrick@xxxxxxxxxxxx
Date: Tue, 3 May 2005 11:21:46 +0100
esql
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 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?

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

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

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.