xsl issue for newbie

Greenhorn

Posts: 2

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi there,
I'm trying to render certain data into the browser. In particular:
1. To render all products in stock (which include those already available and will be available 2 days after placing the order) - displaying full product dtls (all elements)
2. To render all products having a delivery charge of less than 3 dollars.
Here's my xml:

<?xml version="1.0" encoding="iso-8859-1"?>
<?xml-stylesheet type="text/xsl" href="productsInStock.xsl"?>
<Products>                     
<Product>      
      <ProductID>9747</ProductID>
      <ProductName>Network Adapter</ProductName>
      <Description>3Com Wireless Card</Description>
      <AverageCustomerRating>2</AverageCustomerRating>
      
      <Hardware>yes</Hardware>
      <Software>no</Software>
      <Price>30 pounds</Price>
      
      <Stock>
         <InStock>1</InStock>
 <LeadTime>3</LeadTime>
      </Stock>
  <Delivery>
    <FirstClass>4</FirstClass>
<SecondClass>2</SecondClass>
  </Delivery>
</Product>
<Product>
      <ProductID>9748</ProductID>
      <ProductName>Graphic Card</ProductName>
      <Description>64MB Dual Purpose</Description>
      <AverageCustomerRating>8</AverageCustomerRating>
      
      <Hardware>yes</Hardware>
      <Software>no</Software>
      <Price>20 pounds</Price>
      
      <Stock>
         <InStock>3</InStock>
 <LeadTime>7 working days</LeadTime>         
      </stock>
   <Delivery>
    <FirstClass>4</FirstClass>
<SecondClass>2</SecondClass>
  </Delivery>
</Product>
<Product>
      <ProductID>5612</ProductID>
      <ProductName>XML parser</ProductName>
      <Description>Windows XP Platform</Description>
      <AverageCustomerRating>1</AverageCustomerRating>
      
      <Hardware>no</Hardware>
      <Software>yes</Software>
      <Price>200 pounds</Price>
      
      <Stock>
 <InStock>8</InStock>
 <LeadTime>12 working days</LeadTime>         
      </Stock>
   <Delivery>
    <FirstClass>8</FirstClass>
<SecondClass>3</SecondClass>
  </Delivery>
</Product>
<Product>
      <ProductID>5689</ProductID>
      <ProductName>Simulation tools</ProductName>
      <Description>CAD 3D Modelling</Description>
      <AverageCustomerRating>9</AverageCustomerRating>
      
      <Hardware>no</Hardware>
      <Software>yes</Software>
      <Price>1200 pounds</Price>
      
      <Stock>
 <InStock>0</InStock>
 <LeadTime>5 working days</LeadTime>          
      </Stock>
   <Delivery>
    <FirstClass>9</FirstClass>
<SecondClass>5</SecondClass>
  </Delivery>
</Product>
</Products>

Here's my attempt at no.1:

<?xml version="1.0" encoding="ISO-8859-1"?><xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><xsl:template match="/">
  <html>
  <body>
    <h2>Products In Stock</h2>
    <table border="1">
    <tr bgcolor="#9acd32">
      <th align="left">Product Number</th>
  <th align="left">Product Name</th>
  <th align="left">Description</th>
  <th align="left">Average Customer Rating</th>
  <th align="left">Price</th>
  <th align="left">In Stock</th>
  <th align="left">Lead Time</th>
    </tr>
    <xsl:for-each select="//Product">
<xsl:if test = "InStock >=2 AND LeadTime <=2">
    <tr>
      <td><xsl:value-of select="ProductID"/></td>
      <td><xsl:value-of select="ProductName"/></td>
  <td><xsl:value-of select="Description"/></td>
  <td><xsl:value-of select="AverageCustomerRating"/></td>
  <td><xsl:value-of select="Price"/></td>
  <td><xsl:value-of select="InStock"/></td>
  <td><xsl:value-of select="LeadTime"/></td>
    </tr>
</xsl:if>
    </xsl:for-each>
    </table>
  </body>
  </html>
</xsl:template></xsl:stylesheet>

I know the syntax is wrong for the if statement - how should it be done?
And no.2 attempt:

<?xml version="1.0" encoding="ISO-8859-1"?><xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><xsl:template match="/">
  <html>
  <body>
    <h2>Products In Stock</h2>
    <table border="1">
    <tr bgcolor="#9acd32">
      <th align="left">Product Number</th>
  <th align="left">Product Name</th>
  <th align="left">Description</th>
  <th align="left">Average Customer Rating</th>
  <th align="left">Price</th>
  <th align="left">In Stock</th>
  <th align="left">Lead Time</th>
    </tr>
    <xsl:for-each select="Product/Product">
<xsl:if test = "Delivery <=3">
    <tr>
      <td><xsl:value-of select="ProductID"/></td>
      <td><xsl:value-of select="ProductName"/></td>
  <td><xsl:value-of select="Description"/></td>
  <td><xsl:value-of select="AverageCustomerRating"/></td>
  <td><xsl:value-of select="Price"/></td>
  <td><xsl:value-of select="InStock"/></td>
  <td><xsl:value-of select="LeadTime"/></td>
    </tr>
</xsl:if>
    </xsl:for-each>
    </table>
  </body>
  </html>
</xsl:template></xsl:stylesheet>

At the moment for the above xsl file, I dont get any results displayed. Where am I going wrong?
At the moment I have to change the file name in the xml doc to select the relevant xsl document - but is there a smart way to be able to create a singe xml document that links to multiple xsl files?

Lasse Koskela

author

Posts: 11962

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Some quick tips:
1) You need to encode the "<" and ">" within your if statements as "<" and ">"
2) You're referring to "InStock" and "LeadTime" when you should be referring to "Stock/InStock" and "Stock/LeadTime"
3) You've got a typo in "Product/Product"

Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]

Lasse Koskela

author

Posts: 11962

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

4) If the LeadTime elements have values like "3 working days", you can't do a numeric comparison with "<" etc. Instead, you need to use a string function like substring-before(Stock/LeadTime, ' '), which strips away everything except the number you want to compare with something.
There's a decent XPath/XSL function reference at w3schools.com

Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]

Rob Patterson

Greenhorn

Posts: 2

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thanks Lasse,
I used a 'when' instead of the 'if; fixed the typos and it seems to work now. Just got to find a decent parser to use now.
Thanks for your help.

my overalls have superpowers - they repel people who think fashion is important. Tiny ad:

ScroogeXHTML - fast RTF to HTML and XHTML conversion

https://coderanch.com/t/749563/ScroogeXHTML-fast-RTF-HTML-XHTML