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

RE: saxon with sql extension and attribute template v

Subject: RE: saxon with sql extension and attribute template values
From: "Michael Kay" <mike@xxxxxxxxxxxx>
Date: Tue, 26 Jun 2007 17:19:26 +0100
RE:  saxon with sql extension and attribute template  v
connection is an AVT so it should be connection="{$connection}".

xsl:attribute creates an attribute node in the result tree - never an
attribute for the containing instruction in the stylesheet. 

row-tag and column-tag are not AVTs, they must be supplied as literal
values. Those attributes that *are* AVTs are described as such in the
documentation:

http://www.saxonica.com/documentation/sql-extension/query.html

The SQL extension to Saxon was all user-contributed, the reason I say it's
not production-quality is that I don't have the resources to do the
extensive testing needed to do it justice. (I have accepted user-contributed
code in this area that was accompanied by very little test material,
something that I wouldn't do for the mainstream product).

Michael Kay
http://www.saxonica.com/

> -----Original Message-----
> From: Georges Schmitz [mailto:georges.schmitz@xxxxxxxxx] 
> Sent: 26 June 2007 17:06
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject:  saxon with sql extension and attribute template values
> 
> 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

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.