|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Kindly help ASAP!XSL output from XML:Is XSL tied to XSD
Hi: Do you know if we need to comment you reference line to XSD file in the XML to get output using XSL transformations?
I am sleepless with my assignment that nees to be done this friday and am unable to fix it at all...here is my XML and XSL file:I am trying to output some child elements / @ out of Customer and Product elelmtns but had to design them alternately in xml for schema to validate against the xml fiiles. My qs is does schema interfere with xsl ? Can you kindly help me pleaseeeeeee by ths Thursday ? <Bank xmlns='http://xml.XMLCourse.edu/targetNS' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://xml.XMLCourse.edu/targetNS HW3Schema.xsd'> <Customer Code="001" Name="Arup Ray" City="Kolkata"> <!--<Account Code="001"/> <Account Code="002"/>--> <SSN>001-44-8888</SSN> <Gender>Male</Gender> <State>WB</State> <Country>India</Country> <AccBal>35000.00</AccBal> <Dep>250.00</Dep> <Dep>375.00</Dep> <Wdl>50.00</Wdl> <Wdl>25.00</Wdl> <localCurrency>INR</localCurrency> <exchangeRate>45</exchangeRate> </Customer> <Product ID="001" Name="Checking"> <MinBal>500.00</MinBal> <Int>.20</Int> <Fees>2.00</Fees> </Product> <Customer Code="003" Name="Paula Smith" City="Boston"> <!-- <Account Code="003"/> <Account Code="004"/>--> <SSN>001-22-1111</SSN> <Gender>Female</Gender> <State>MA</State> <Country>USA</Country> <AccBal>15000.00</AccBal> <Dep>100.00</Dep> <Dep>50.00</Dep> <Wdl>20.00</Wdl> <Wdl>40.00</Wdl> </Customer> <Product ID="002" Name="Savings"> <MinBal>5000.00</MinBal> <Int>.20</Int> <Fees>3.00</Fees> </Product> <Customer Code="002" Name="Robin Kidman" City="Cambridge"> <!--<Account Code="002"/> <Account Code="001"/>--> <!--Customer can have 0 or more accounts--> <SSN>001-55-7777</SSN> <Gender>Female</Gender> <State>BH</State> <Country>UK</Country> <AccBal>8000.00</AccBal> <Dep>250.00</Dep> <Wdl>50.00</Wdl> <localCurrency>GBP</localCurrency> <exchangeRate>1.5</exchangeRate> </Customer> <Product ID="003" Name="CD"> <MinBal>10000.00</MinBal> <Int>.20</Int> <Fees>4.00</Fees> </Product> <Customer Code="002" Name="Chris Shaw" City="Atlanta" > <!--<Account Code="002"/> <Account Code="003/> --> <SSN>001-11-5234</SSN> <Gender>Male</Gender> <State>GA</State> <Country>USA</Country> <AccBal>40000.00</AccBal> <Dep>300.00</Dep> <Wdl>100.00</Wdl> </Customer> <Product ID="004" Name="IRA"> <MinBal>20000.00</MinBal> <Int>.20</Int> <Fees>5.00</Fees> </Product> </Bank> *************************** <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:template match="/"> <html> <body> <h3>Display International Customers</h3> <table border="1"> <tr bgcolor="#9acd32"> <th>Country</th> <th>USD Balance</th> </tr> </table> </body> </html> <!-- DISPLAY ALL INTERNATIONAL CUSTOMERS--> <!--<xsl:for-each select="Customers/Customer[@Country='India']"> --> <!-- <xsl:for-each select="Customer[(Country='India')]" > --> <!-- <xsl:variable name="Bal" select="AccBal"/> --> <!-- <xsl:variable name="ER" select="exchangeRate"/>--> <!-- <xsl:variable name="Value" select="($Bal * $ER)"/> Bank/Customer[position() mod 2 = 1]--> <xsl:if test="Customer[position()= 1]" > <!--<xsl:if test="position() mod 2 = 1">--> <tr> <!--<td><xsl:value-of select="@Name"/></td> <td><xsl:value-of select="@City"/></td>--> <td><xsl:value-of select="Country"/></td> <td><xsl:value-of select="AccBal"/></td> </tr> </xsl:if> </xsl:template> </xsl:stylesheet> <!--Display Month end Balances for all customers:ON THE FLY DATA <table border="1"> <tr><i>Display Month-end Balances for all customers</i></tr> <tr bgcolor="salmon"> <th>Code</th> <th>Balance</th> <th>Deposits</th> <th>Withdrawals</th> <th>MonthEnd</th> </tr> <apply-templates select="Customer" /> Month End Calculations <xsl:for-each select="Customer"> <xsl:variable name="Deposits" select="sum(Dep)"/> <xsl:variable name="Wdl" select="sum(Wdl)"/> <xsl:variable name="Monthly" select="($Balance + $Deposits) - ($Wdl)"/> <tr> <td><xsl:value-of select="@Code"/></td> <td><xsl:value-of select="AccBal"/></td> <td><xsl:value-of select="sum(Dep)"/></td> <td><xsl:value-of select= "sum(Wdl)"/></td> <td><xsl:value-of select= "$Monthly"/></td> </tr> </xsl:for-each> </table> </body> </html> </xsl:template> </xsl:stylesheet>--> |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > XML Programming > Kindly help ASAP!XSL output from XML:Is XSL tied to XSD |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|