saxon with sql extension and attribute template values

Play the video

Subject: saxon with sql extension and attribute template values
From: Georges Schmitz <georges.schmitz@xxxxxxxxx>
Date: Tue, 26 Jun 2007 18:05:55 +0200

I'm using saxon8-9-0-3j in combination with the sql extension. But using it in a more dynamic way (providing the sql select components by variables or parameters) doesn't work. In the documentation Michael Kay declares the query attributes as being "attribute value templates", but I just get expected results, when I use literal values. It doesn't work either with an xsl:attribute declaration (see "row-tag").

<xsl:variable name="table" as="xs:string">tc_ad</xsl:variable> <xsl:variable name="cols" as="xs:string">id,nationalidnr,subject</xsl:variable> <sql:query connection="$connection" table="{$table}" column="{$cols}" column-tag="col" > <xsl:attribute name="row-tag"> <xsl:value-of select="$table"/> </xsl:attribute> </sql:query>

So what am I missing, or is the sql extension really just a show case (Michael Kay warns the user at the beginning of the description that it is not "production-quality")?

Thanks,
Georges

Current Thread
saxon with sql extension and attribute template values Georges Schmitz - 26 Jun 2007 16:06:12 -0000 <= Michael Kay - 26 Jun 2007 16:20:41 -0000 Michael Kay - 26 Jun 2007 17:33:58 -0000

<- Previous	Index	Next ->
Re: xsl attribute question pl, Abel Braaksma	Thread	RE: saxon with sql extension , Michael Kay
Re: Sorting by document order, Florent Georges	Date	Re: <quote>XSL is NOT easy</q, Wendell Piez
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

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

Download The World's Best XML IDE!

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

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >