|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] repeating/portal fields in filemaker FMPXMLRESULT?
Hi, I'm looking for a general solution to a problem I anticipate facing many
times over. I've checked the archives with no success, but maybe I don't
know the magic keywords for this problem.
The problem is this - consider this XML fragment:
<resultset>
<row>
<col><data>fred</data></col>
<col> <!-- zero or more children -->
<data>2005-06</data>
<data>2005-07</data>
<data>2005-08</data>
<col>
<col> <!-- same number of children as col[2] -->
<data>open</data>
<data>draft</data>
<data>closed</data>
<col>
</row>
<row>
<col><data>wilma</data></col>
<col>
<data>2005-06</data>
<data>2006-01</data>
<col>
<col>
<data>open</data>
<data>closed</data>
<col>
</row>
</resultset>
The first <col/> always only has one <data/> child. The second and third
<col/> may have zero to many <data/> children, but will always have the same
count (ie. if col#2 has 3 children, col#3 will have 3 children).
The problem I'm facing is that I want to transform this to look more like
this:
<whatever>
<record>
<name>fred</name>
<!-- zero or more entry children -->
<entry><!-- with exactly the same child elems -->
<month>2005-06</month>
<status>open</status>
</entry>
<entry>
<month>2005-07</month>
<status>draft</status>
</entry>
<entry>
<month>2005-08</month>
<status>closed</status>
</entry>
</record>
<record>
<name>wilma</name>
<entry>
<month>2005-06</month>
<status>open</status>
</entry>
<entry>
<month>2006-01</month>
<status>closed</status>
</entry>
</record>
<whatever>
The approach I've considered has been to use <xsl:for-each select="row"> to
cycle over each row, and then <xsl:for-each select="col[2]/data"> to cycle
over each <data/> in the second column ... but how do I then reference the
corresponding nth child of col[3]? Should I not use nested xsl:for-each to
tackle this problem, but instead some other method?
e.
ps. keywords for the archive, if I ever need to come searching again
FMPXMLRESULT, Filemaker, repeating fields, portal fields, </data><data>
|
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
|

Cart








