SSDN - XSLT Does Not Retrieve Enough Records

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

Minollo I.

Subject: XSLT Does Not Retrieve Enough Records
Author: Minollo I.
Date: 03 Jan 2007 07:02 PM

Can you also attach (or email stylus-field-report@progress.com) the XML you are using as input? And also point us to a record that you can see is not transformed the way you would expect?

Minollo I.

Subject: XSLT Does Not Retrieve Enough Records
Author: Minollo I.
Date: 03 Jan 2007 08:23 PM

You are not looping on the repeating element in the input document (qryWMGforXMLExport); you need to add a <xsl:for-each select="dataroot/qryWMGforXMLExport"> at some level to make sure that everything inside will be repeated for all occurrences of that element; of course, once in the context of the xsl:for-each, the XPath expressions will be in the context of that specific element; so, for example, you will do <xsl:value-of select="MessageThreadID"/>, not <xsl:value-of select="dataroot/qryWMGforXMLExport/MessageThreadID"/>

Minollo I.

Subject: XSLT Does Not Retrieve Enough Records
Author: Minollo I.
Date: 03 Jan 2007 11:09 PM
Originally Posted: 03 Jan 2007 10:38 PM

See if this one makes things more clear.

Ellen Christon

Subject: XSLT Does Not Retrieve Enough Records
Author: Ellen Christon
Date: 03 Jan 2007 11:09 PM
Originally Posted: 03 Jan 2007 10:59 PM

Hmmm... Is this the right file type? I can't seem to open it on my machine...

Ellen Christon

Subject: XSLT Does Not Retrieve Enough Records
Author: Ellen Christon
Date: 03 Jan 2007 11:04 PM

P.S.- I truly appreciate the help. :O)

Minollo I.

Subject: XSLT Does Not Retrieve Enough Records
Author: Minollo I.
Date: 03 Jan 2007 11:10 PM

Try now; attachment should work this time.

Minollo I.

Subject: XSLT Does Not Retrieve Enough Records
Author: Minollo I.
Date: 03 Jan 2007 11:24 PM

Well, you put an element our of xsl:template... which any processor less "kind" than the built-in Stylus Studio one would have refused as an error; I put that element back to be a child of xsl:template, and I added a <Record> one to show you better the repetition of the generated structure.

Ellen Christon

Subject: XSLT Does Not Retrieve Enough Records
Author: Ellen Christon
Date: 03 Jan 2007 11:28 PM

Okay, one last question, which may be out of your scope. Please let me know if it is.

I need to add a counter as shown below and I know somehow you can do it with an xls:number function, but, as you might imagine, I can't get this to work! The count should start with 1 and increase by 1, by each grid listed. For example,

Date: 11/1 GRId: A10302B0000061658P 1
Date: 11/2 GRId: A10302B0000061658P 2
Date: 11/1 GRId: C19812B0000061658X 3
Date: 11/3 GRId: C19812B0000061658X 4

Here is how it is supposed to look in the XML:

<ReleaseTransactionsToRecordCompany>
<ReleaseId> 
<GRid>A10302B0000061658P</GRid>
<ISRC>USAT20500181</ISRC>

Minollo I.

Subject: XSLT Does Not Retrieve Enough Records
Author: Minollo I.
Date: 03 Jan 2007 11:35 PM

I'm not sure I understand exactly what you mean, but maybe you can do something like this?

...
<ReleaseId>
<xsl:comment><xsl:value-of select="position()"/></xsl:comment>
<GRid>
...

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.