SSDN - keys and db content

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Steve Trythall

Subject: keys and db content
Author: Steve Trythall
Date: 21 Feb 2005 12:07 PM

I am trying to create an xsl:key into content coming from a database.

I tried:

<xsl:key name="design" match="="document('db:jdbc:datadirect:jxtr:oracle://localhost:1521;SID=CHS;schema=CHS;table=PROJECTDESIGN;user=chs;password=173A27;urltype=.xml')/PROJECTDESIGN/row"" use="@id"/>

which failed ;-(

So I then tried a variable to hold the content.

<xsl:variable name="designs" select="document('db:jdbc:datadirect:jxtr:oracle://localhost:1521;SID=CHS;schema=CHS;table=PROJECTDESIGN;user=chs;password=173A27;urltype=.xml')/PROJECTDESIGN/row"/>
<xsl:key name="design" match="$designs" use="@id"/>

This also failed. Is this possible?

Thanks

Ivan Pedruzzi

Subject: keys and db content
Author: Ivan Pedruzzi
Date: 21 Feb 2005 01:01 PM

Steve

In XSLT 1.0 xslkey match attribute supports only patterns as decribed here
http://www.w3c.org/TR/xslt#key

You can still use keys without the document function like this
<xsl:key name="design" match="="/PROJECTDESIGN/row"" use="@id"/>

as long as your main input in the scenario dialog points to
db:jdbc:datadirect:jxtr:oracle://localhost:1521;SID=CHS;schema=CHS;table=PROJECTDESIGN;user=chs;password=173A27;urltype=.xml

Hope this helps
Ivan

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.