I am using Martin’s example that shows how XSLT can retrieve data from a password protected Filemaker database.

It works great and returns the XML data into a variable called xmltree.

My question is – how the heck can I transform this information into something that is formatted for display?

I have tried using the xsl:value-of select="fmrs:field[@name...", etc. But, the HTML returned contains no field data (though I can see it unstructured if I use “copy-of select=$xmltree”)

Even after many hours, I am still not able to crack this. Can anyone help?

Thanks,

George

Use

e.g. for the first record in $xmltree

Or if you need do loop through the records:

Or if you need to check if something went wrong when you called the data with document()

Something went wrong! Error .

Do something else ...

Thanks so much, Martin.

The only thing I was missing was the [1] after fmrs:record. What does the [1] signify?

Thanks again for your help.

=George

The numbers in brackets specify the position. So record[1] would be the 1st record. BTW, XML is not zero-indexed like JavaScript (thankfully).