[xsl] Please Help IN: SXL Structure problem

["test s" <stesting@xxxxxxxxxxx>]

Hi
I hoave this input Data

<?xml version="1.0" encoding="UTF-8" ?><FMPXMLRESULT 
xmlns="http://www.filemaker.com/fmpxmlresult";><ERRORCODE>0</ERRORCODE><PRODUCT 
BUILD="06/13/2002" NAME="FileMaker Pro" VERSION="6.0v1"/>
<DATABASE DATEFORMAT="d/M/yyyy" LAYOUT="" NAME="RespiteOptionsDatabase.fp5" 
RECORDS="195" TIMEFORMAT="h:mm:ss a"/>
<METADATA><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="person_id" 
TYPE="NUMBER"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="users::FIRST NAME" 
TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="users::SURNAME" 
TYPE="TEXT"/><FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Holiday Destination" 
TYPE="TEXT"/></METADATA>
<RESULTSET FOUND="2"><ROW MODID="1" 
RECORDID="35020"><COL><DATA>1</DATA></COL><COL><DATA>Jim</DATA></COL><COL><DATA>A</DATA></COL><COL><DATA>Holiday1</DATA></COL></ROW><ROW 
MODID="1" 
RECORDID="35020"><COL><DATA>1</DATA></COL><COL><DATA>Jim</DATA></COL><COL><DATA>A</DATA></COL><COL><DATA>Holiday2</DATA></COL></ROW><ROW 
MODID="2" 
RECORDID="35020"><COL><DATA>1</DATA></COL><COL><DATA>STEVEN</DATA></COL><COL><DATA>B</DATA></COL><COL><DATA>Holiday3</DATA></COL></ROW><ROW 
MODID="2" 
RECORDID="35020"><COL><DATA>1</DATA></COL><COL><DATA>STEVEN</DATA></COL><COL><DATA>B</DATA></COL><COL><DATA>Holiday4</DATA></COL></ROW></RESULTSET></FMPXMLRESULT>


I created a XSL Style sheet to transform it to:

<?xml version="1.0" encoding="UTF-8"?>

<UserProgram xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; 
xsi:noNamespaceSchemaLocation="C:\xmldocs\csdaschema.xsd">

<Users>
<User RecordId="1">
<PersonID>1</PersonID>
<FirstName>JIM</FirstName>
<LastName>A</LastName>
<HolidayDestinations>
	<HolidayDestinations>Holiday1</HolidayDestinations>
	<HolidayDestinations>Holiday2</HolidayDestinations>
</HolidayDestinations>
</User>
<User RecordId="2">
<PersonID>2</PersonID>
<FirstName>STEVEN</FirstName>
<LastName>B</LastName>
<HolidayDestinations>
	<HolidayDestinations>Holiday3</HolidayDestinations>
	<HolidayDestinations>Holiday4</HolidayDestinations>
</HolidayDestinations>
</User>
</UserProgram>



But the problem the out put are not showwing the holidayDestination the 
output data are comming up as:

<?xml version="1.0" encoding="UTF-8"?>

<UserProgram xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; 
xsi:noNamespaceSchemaLocation="C:\xmldocs\csdaschema.xsd">

<Users>

<User RecordId="1">

<PersonID>1</PersonID>

<FirstName>JIM</FirstName>

<LastName>A</LastName>

<HolidayDestinations/>

</User>

<User RecordId="2">

<PersonID>2</PersonID>

<FirstName>STEVEN</FirstName>

<LastName>B</LastName>

<HolidayDestinations/>

</User>

</UserProgram>



Does any one know anything about this problem, thanks in advance for your 
help



_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail


XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list