Cart
|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Please Help IN: SXL Structure problem
 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 
|
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
|
