Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple xml dtd and stylesheet question

Status
Not open for further replies.

X135

Technical User
Sep 2, 2007
2
AU
Hi all,
Just started my first xml relation and have got a little stuck. I have done all the code for my XML and DTD and some for my stylesheet, but just cant get the stlye sheet to work. Just wonder if someone could point me the right direction as to where I am going wrong? All I am trying to do is to show the first and last columns of each relation.
----------------------------------------------------------
dreamhome.xml

<?xml version ="1.0"?>
<?xml:stylesheet type ="text/xsl" href="dreamhome.xsl"?>
<!DOCTYPE DREAMHOME SYSTEM "dreamhome.dtd">
<dreamhome>
<branch_list>
<branch branchNo="B003">
<street>163 Main Rd</street>
<city>Sydney</city>
<postcode>2002</postcode>
</branch>
<branch branchNo="B004">
<street>32 Manse Rd</street>
<city>Melbourne</city>
<postcode>3003</postcode>
</branch>
<branch branchNo="B005">
<street>56 Clovers Dr</street>
<city>Hobart</city>
<postcode>4432</postcode>
</branch>
</branch_list>
<staff_list>
<staff staffNo="SL21">
<name>
<fName>John</fName>
<lName>White</lName>
</name>
<position>Manager</position>
<sex>M</sex>
<DOB>1-oct-45</DOB>
<salary>82000</salary>
<branchNo>B005</branchNo>
</staff>
<staff staffNo="SG37">
<name>
<fName>Ann</fName>
<lName>Beech</lName>
</name>
<position>Assistant</position>
<sex>F</sex>
<DOB>10-Nov-60</DOB>
<salary>45000</salary>
<branchNo>B003</branchNo>
</staff>
<staff staffNo="SG14">
<name>
<fName>David</fName>
<lName>Ford</lName>
</name>
<position>Supervisor</position>
<sex>M</sex>
<DOB>24-Mar-58</DOB>
<salary>61000</salary>
<branchNo>B003</branchNo>
</staff>
</staff_list>
<property_for_rent_list>
<propertyForRent propertyNo="PA14">
<property_address>
<property_street>16 Holhead St</property_street>
<property_city>Canberra</property_city>
<property_postcode>2340</property_postcode>
</property_address>
<type>house</type>
<rooms>4</rooms>
<rent>400</rent>
<staffNo>Sl21</staffNo>
<branchNo>B005</branchNo>
</propertyForRent>
<propertyForRent propertyNo="PL94">
<property_address>
<property_street>6 Manor Rd</property_street>
<property_city>Sydney</property_city>
<property_postcode>2008</property_postcode>
</property_address>
<type>flat</type>
<rooms>2</rooms>
<rent>180</rent>
<staffNo>SG14</staffNo>
<branchNo>B003</branchNo>
</propertyForRent>
<propertyForRent propertyNo="PG21">
<property_address>
<property_street>5 Novar Dr</property_street>
<property_city>Geelong</property_city>
<property_postcode>3222</property_postcode>
</property_address>
<type>house</type>
<rooms>3</rooms>
<rent>270</rent>
<staffNo>SG5</staffNo>
<branchNo>B007</branchNo>
</propertyForRent>
</property_for_rent_list>
<client_list>
<client clientNo="CR76">
<client_name>
<client_fName>John</client_fName>
<client_lName>Kay</client_lName>
</client_name>
<telNo>123456789</telNo>
<prefType>house</prefType>
</client>
<client clientNo="CR62">
<client_name>
<client_fName>Mary</client_fName>
<client_lName>Smith</client_lName>
</client_name>
<telNo>87654321</telNo>
<prefType>flat</prefType>
</client>
</client_list>
</dreamhome>
-----------------------------------------------------------
dreamhome.dtd

<!--dtd document for dreamhome.xml-->
<!ELEMENT dreamhome (branch_list, staff_list, property_for_rent_list, client_list)>
<!ELEMENT branch_list (branch)*>
<!ELEMENT staff_list (staff)*>
<!ELEMENT property_for_rent_list (propertyForRent)*>
<!ELEMENT client_list (client)*>
<!ELEMENT branch (street, city, postcode)>
<!ELEMENT staff (name, position, sex, DOB, salary)>
<!ELEMENT name (fName, lName)>
<!ELEMENT propertyForRent (property_address, type, rooms, rent)>
<!ELEMENT property_address (property_street, property_city, property_postcode)>
<!ELEMENT client (client_name, telNo, prefType)>
<!ELEMENT name (fName, lName)>
<!ELEMENT client_name (client_fName, client_lName)>
<!ELEMENT street (#PCDATA)>
<!ELEMENT city (#PCDATA)>
<!ELEMENT postcode (#PCDATA)>
<!ELEMENT fname (#PCDATA)>
<!ELEMENT lname (#PCDATA)>
<!ELEMENT position (#PCDATA)>
<!ELEMENT sex (#PCDATA)>
<!ELEMENT dob (#PCDATA)>
<!ELEMENT salary (#PCDATA)>
<!ELEMENT property_street (#PCDATA)>
<!ELEMENT property_city (#PCDATA)>
<!ELEMENT property_postcode (#PCDATA)>
<!ELEMENT property_postcode (#PCDATA)>
<!ELEMENT type (#PCDATA)>
<!ELEMENT rooms (#PCDATA)>
<!ELEMENT rent (#PCDATA)>
<!ELEMENT client_fname (#PCDATA)>
<!ELEMENT client_lname (#PCDATA)>
<!ELEMENT telNo (#PCDATA)>
<!ELEMENT prefType (#PCDATA)>
------------------------------------------------------------
dreamhome.xsl (what I have done so far, first part didnt work so havent gone any further)

<?xml version="1.0" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="<xsl:template match="/">
<html>
<body>
<h2>DreamHome</h2>
<table border="1">
<tr>
<th align="center">Branch No</th>
<th align="center">Postcode</th>
</tr>
<xsl:for-each select="branch_list/branch">
<tr>
<td>
<xsl:value-of select="@branchNo" />
</td>
<td>
<xsl:value-of select="postcode" />
</td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
------------------------------------------------------------

Thanks :)
 
[1]
><?xml:stylesheet type ="text/xsl" href="dreamhome.xsl"?>
[tt]<?xml[highlight]-[/highlight]stylesheet type ="text/xsl" href="dreamhome.xsl"?>[/tt]
[2]
><xsl:for-each select="branch_list/branch">
[tt]<xsl:for-each select="[red]dreamhome/[/red]branch_list/branch">[/tt]
[3] (not related to the display)
><!DOCTYPE DREAMHOME SYSTEM "dreamhome.dtd">
[tt]<!DOCTYPE [blue]dreamhome[/blue] SYSTEM "dreamhome.dtd">[/tt]
 
awesome! works great
sukiipoo

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top