hi there guys!
im trying to do this, i have a table on screen on which, i display a persons application history. they may have multiple historys. there is a button on the screen that allows you to cycle through different people by using a recordset. however i cannont get the table to work. the XML is as follows:
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="ApplicationDetailsApplicant.xsl"?>
<details>
<ApplicationDetailsApplicant>
<SequenceID>1</SequenceID>
<ID>3676.000000</ID>
<ApplicationType>Shotgun</ApplicationType>
<CertificateNumberLabel/>
<Status>46.003000</Status>
<Reason/>
<DateReceived>01/05/2001</DateReceived>
<DateAccepted/>
<DateAppliedFor/>
<Comments>1057</Comments>
<AppealLodged>false</AppealLodged>
<AppealUpheld>false</AppealUpheld>
<AppliedForCoterminous>false</AppliedForCoterminous>
<NameLabel>Willy Jackson-Brown</NameLabel>
<DateOfBirthLabel/>
<AddressLabel>132, Any Old Way, Edinburgh, Lothian</AddressLabel>
<StatusBox>
<SharedBy person="1">
<StatusDateLabel >12/03/2002</StatusDateLabel>
<StatusLabel>Application Received</StatusLabel>
<StatusReasonLabel/>
<UserLabel>guest</UserLabel>
</SharedBy>
<SharedBy person="1">
<StatusDateLabel>12/03/2002</StatusDateLabel>
<StatusLabel>Application Received</StatusLabel>
<StatusReasonLabel/>
<UserLabel>guest</UserLabel>
</SharedBy>
</StatusBox>
</ApplicationDetailsApplicant>
<ApplicationDetailsApplicant>
<SequenceID>2</SequenceID>
<ID>3673.000000</ID>
<ApplicationType>Firearm</ApplicationType>
<CertificateNumberLabel/>
<Status>46.003000</Status>
<Reason/>
<DateReceived>12/12/2001</DateReceived>
<DateAccepted>15/02/2002</DateAccepted>
<DateAppliedFor/>
<Comments/>
<AppealLodged>false</AppealLodged>
<AppealUpheld>false</AppealUpheld>
<AppliedForCoterminous/>
<NameLabel>Willy Jackson-Brown</NameLabel>
<DateOfBirthLabel/>
<AddressLabel>132, Any Old Way, Edinburgh, Lothian</AddressLabel>
<StatusBox>
<SharedBy>
<StatusDateLabel>15/02/2002</StatusDateLabel>
<StatusLabel>Approved</StatusLabel>
<StatusReasonLabel/>
<UserLabel>guest</UserLabel>
</SharedBy>
<SharedBy>
<StatusDateLabel>15/02/2002</StatusDateLabel>
<StatusLabel>Application Received</StatusLabel>
<StatusReasonLabel/>
<UserLabel>iplanet</UserLabel>
</SharedBy>
</StatusBox>
</ApplicationDetailsApplicant>
</details>
the folowing is an excert of the XSL:
<xml ID = "xmlData">
<details>
<xsl:for-each select="details/ApplicationDetailsApplicant">
<ApplicationDetailsApplicant>
<SequenceID><xsl:value-of select="SequenceID"></xsl:value-of></SequenceID>
<NameLabel><xsl:value-of select="NameLabel"></xsl:value-of></NameLabel>
<AddressLabel><xsl:value-of select="AddressLabel"></xsl:value-of></AddressLabel>
<DateOfBirthLabel><xsl:value-of select="DateOfBirthLabel"></xsl:value-of></DateOfBirthLabel>
<CertificateLabel><xsl:value-of select="CertificateLabel"></xsl:value-of></CertificateLabel>
<CertificateNumberLabel><xsl:value-of select="CertificateNumberLabel"></xsl:value-of></CertificateNumberLabel>
<ApplicationType><xsl:value-of select="ApplicationType"></xsl:value-of></ApplicationType>
<ID><xsl:value-of select="ID"></xsl:value-of> </ID>
<ApplicationForCoterminous><xsl:value-of select="ApplicationForCoterminous"></xsl:value-of></ApplicationForCoterminous>
<Status><xsl:value-of select="Status"></xsl:value-of></Status>
<Reason><xsl:value-of select="Reason"></xsl:value-of></Reason>
<DateReceived> <xsl:value-of select="DateReceived"></xsl:value-of></DateReceived>
<DateAccepted><xsl:value-of select="DateAccepted"></xsl:value-of></DateAccepted>
<DateAppliedFor><xsl:value-of select="DateAppliedFor"></xsl:value-of></DateAppliedFor>
<Comments><xsl:value-of select="Comments"></xsl:value-of></Comments>
<AppealLodged><xsl:value-of select="AppealLodged"></xsl:value-of></AppealLodged>
<AppealUpheld><xsl:value-of select="AppealUpheld"></xsl:value-of></AppealUpheld>
<xsl:for-each select="StatusBox/SharedBy">
<StatusDateLabel><xsl:value-of select="StatusDateLabel"></xsl:value-of></StatusDateLabel>
<StatusLabel><xsl:value-of select="StatusLabel"></xsl:value-of></StatusLabel>
<StatusReasonLabel><xsl:value-of select="StatusReasonLabel"></xsl:value-of></StatusReasonLabel>
<UserLabel><xsl:value-of select="UserLabel"></xsl:value-of></UserLabel>
</xsl:for-each>
</ApplicationDetailsApplicant>
</xsl:for-each>
</details>
</xml>
<xsl:element name="table">
<xsl:attribute name="border">1</xsl:attribute>
<xsl:attribute name="width">75%</xsl:attribute>
<xsl:attribute name="align">center</xsl:attribute>
<tr>
<td height="63">
<div align="center">
<xsl:element name="table">
<xsl:attribute name="border">0</xsl:attribute>
<xsl:attribute name="width">75%</xsl:attribute>
<xsl:attribute name="bordercolor">#CCCCCC</xsl:attribute>
<xsl:attribute name="align">center</xsl:attribute>
<xsl:attribute name="height">100%</xsl:attribute>
<tr>
</tr>
<tr>
<td height="29" width="17%"><b>Name:</b></td>
<td height="29" width="39%">
<font size ="3">
<div align="left" name="Name" datasrc= "#xmlData" datafld="NameLabel"></div>
</font>
</td>
<td height="29" width="20%"><b>Date of Birth:</b></td>
<td height="29" width="24%"> <font size="3"> <div name="DateOfBirth" datasrc= "#xmlData" datafld="DateOfBirthLabel"></div>
</font></td>
</tr>
<tr>
<td width="17%"><b>Address:</b></td>
<td height="29" width="24%" colspan="2">
<div name="Address" datasrc= "#xmlData" datafld="AddressLabel"></div>
</td>
</tr>
<tr>
<td height="29" width="24%"><b>Certificate Number:</b> </td>
<td>
<div name="Certnum" datasrc= "#xmlData" datafld="CertificateNumberLabel"></div>
</td>
</tr>
</xsl:element>
</div>
</td>
</tr>
</xsl:element>
</center>
<input type="hidden" name="id" datasrc= "#xmlData" datafld="ID" size="5">
<xsl:attribute name="value"><xsl:value-of select="ID"/></xsl:attribute>
</input>
<form name="ApplicationForm" method="get" action="
<center>
<xsl:attribute name="method">get</xsl:attribute>
<div id="StatusLayer">
<xsl:element name="table">
<xsl:attribute name="border">0</xsl:attribute>
<xsl:attribute name="width">75%</xsl:attribute>
<tr>
<td>
<xsl:apply-templates select="//header" />
</td>
</tr>
<tr/>
<tr>
<td>
<xsl:element name="table">
<xsl:attribute name="border">0</xsl:attribute>
<xsl:attribute name="width">100%</xsl:attribute>
<tr>
<td width="25%">
<p>
<b>Date</b>
</p>
</td>
<td width="25%">
<p>
<b>Status</b>
</p>
</td>
<td width="25%">
<p>
<b>Reason</b>
</p>
</td>
<td>
<p>
<b>User</b>
</p>
</td>
</tr>
</xsl:element>
</td>
</tr>
<tr>
<table border="1" width="75%" height="67" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
<td width ="100%">
<DIV STYLE="overflow: auto; width: 780px; height: 70;
border-left: 1px gray solid; border-bottom: 1px gray solid;
padding:0px; margin: 0px">
<table border="0" width="100%" height="67" cellspacing="0" cellpadding="0">
<xsl:attribute name="style">font-family: monospace; font-size: 12</xsl:attribute>
<tr>
<td width="25%"><span datasrc= "#xmlData" datafld="StatusDateLabel"></span></td>
<td width="25%"><span datasrc= "#xmlData" datafld="StatusLabel"></span></td>
<td width="25%"><span datasrc= "#xmlData" datafld="StatusReasonLabel"></span></td>
<td width="25%"><span datasrc= "#xmlData" datafld="UserLabel"></span></td>
</tr>
</table>
i am trying to input the status history into the table enclosed in the DIV tag.
thankyou to anyone who takes the time to help
Kenneth Birney
User Interface Programmer
Scottish Police
Kenneth Birney
User Interface Programmer
Scottish Police
im trying to do this, i have a table on screen on which, i display a persons application history. they may have multiple historys. there is a button on the screen that allows you to cycle through different people by using a recordset. however i cannont get the table to work. the XML is as follows:
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="ApplicationDetailsApplicant.xsl"?>
<details>
<ApplicationDetailsApplicant>
<SequenceID>1</SequenceID>
<ID>3676.000000</ID>
<ApplicationType>Shotgun</ApplicationType>
<CertificateNumberLabel/>
<Status>46.003000</Status>
<Reason/>
<DateReceived>01/05/2001</DateReceived>
<DateAccepted/>
<DateAppliedFor/>
<Comments>1057</Comments>
<AppealLodged>false</AppealLodged>
<AppealUpheld>false</AppealUpheld>
<AppliedForCoterminous>false</AppliedForCoterminous>
<NameLabel>Willy Jackson-Brown</NameLabel>
<DateOfBirthLabel/>
<AddressLabel>132, Any Old Way, Edinburgh, Lothian</AddressLabel>
<StatusBox>
<SharedBy person="1">
<StatusDateLabel >12/03/2002</StatusDateLabel>
<StatusLabel>Application Received</StatusLabel>
<StatusReasonLabel/>
<UserLabel>guest</UserLabel>
</SharedBy>
<SharedBy person="1">
<StatusDateLabel>12/03/2002</StatusDateLabel>
<StatusLabel>Application Received</StatusLabel>
<StatusReasonLabel/>
<UserLabel>guest</UserLabel>
</SharedBy>
</StatusBox>
</ApplicationDetailsApplicant>
<ApplicationDetailsApplicant>
<SequenceID>2</SequenceID>
<ID>3673.000000</ID>
<ApplicationType>Firearm</ApplicationType>
<CertificateNumberLabel/>
<Status>46.003000</Status>
<Reason/>
<DateReceived>12/12/2001</DateReceived>
<DateAccepted>15/02/2002</DateAccepted>
<DateAppliedFor/>
<Comments/>
<AppealLodged>false</AppealLodged>
<AppealUpheld>false</AppealUpheld>
<AppliedForCoterminous/>
<NameLabel>Willy Jackson-Brown</NameLabel>
<DateOfBirthLabel/>
<AddressLabel>132, Any Old Way, Edinburgh, Lothian</AddressLabel>
<StatusBox>
<SharedBy>
<StatusDateLabel>15/02/2002</StatusDateLabel>
<StatusLabel>Approved</StatusLabel>
<StatusReasonLabel/>
<UserLabel>guest</UserLabel>
</SharedBy>
<SharedBy>
<StatusDateLabel>15/02/2002</StatusDateLabel>
<StatusLabel>Application Received</StatusLabel>
<StatusReasonLabel/>
<UserLabel>iplanet</UserLabel>
</SharedBy>
</StatusBox>
</ApplicationDetailsApplicant>
</details>
the folowing is an excert of the XSL:
<xml ID = "xmlData">
<details>
<xsl:for-each select="details/ApplicationDetailsApplicant">
<ApplicationDetailsApplicant>
<SequenceID><xsl:value-of select="SequenceID"></xsl:value-of></SequenceID>
<NameLabel><xsl:value-of select="NameLabel"></xsl:value-of></NameLabel>
<AddressLabel><xsl:value-of select="AddressLabel"></xsl:value-of></AddressLabel>
<DateOfBirthLabel><xsl:value-of select="DateOfBirthLabel"></xsl:value-of></DateOfBirthLabel>
<CertificateLabel><xsl:value-of select="CertificateLabel"></xsl:value-of></CertificateLabel>
<CertificateNumberLabel><xsl:value-of select="CertificateNumberLabel"></xsl:value-of></CertificateNumberLabel>
<ApplicationType><xsl:value-of select="ApplicationType"></xsl:value-of></ApplicationType>
<ID><xsl:value-of select="ID"></xsl:value-of> </ID>
<ApplicationForCoterminous><xsl:value-of select="ApplicationForCoterminous"></xsl:value-of></ApplicationForCoterminous>
<Status><xsl:value-of select="Status"></xsl:value-of></Status>
<Reason><xsl:value-of select="Reason"></xsl:value-of></Reason>
<DateReceived> <xsl:value-of select="DateReceived"></xsl:value-of></DateReceived>
<DateAccepted><xsl:value-of select="DateAccepted"></xsl:value-of></DateAccepted>
<DateAppliedFor><xsl:value-of select="DateAppliedFor"></xsl:value-of></DateAppliedFor>
<Comments><xsl:value-of select="Comments"></xsl:value-of></Comments>
<AppealLodged><xsl:value-of select="AppealLodged"></xsl:value-of></AppealLodged>
<AppealUpheld><xsl:value-of select="AppealUpheld"></xsl:value-of></AppealUpheld>
<xsl:for-each select="StatusBox/SharedBy">
<StatusDateLabel><xsl:value-of select="StatusDateLabel"></xsl:value-of></StatusDateLabel>
<StatusLabel><xsl:value-of select="StatusLabel"></xsl:value-of></StatusLabel>
<StatusReasonLabel><xsl:value-of select="StatusReasonLabel"></xsl:value-of></StatusReasonLabel>
<UserLabel><xsl:value-of select="UserLabel"></xsl:value-of></UserLabel>
</xsl:for-each>
</ApplicationDetailsApplicant>
</xsl:for-each>
</details>
</xml>
<xsl:element name="table">
<xsl:attribute name="border">1</xsl:attribute>
<xsl:attribute name="width">75%</xsl:attribute>
<xsl:attribute name="align">center</xsl:attribute>
<tr>
<td height="63">
<div align="center">
<xsl:element name="table">
<xsl:attribute name="border">0</xsl:attribute>
<xsl:attribute name="width">75%</xsl:attribute>
<xsl:attribute name="bordercolor">#CCCCCC</xsl:attribute>
<xsl:attribute name="align">center</xsl:attribute>
<xsl:attribute name="height">100%</xsl:attribute>
<tr>
</tr>
<tr>
<td height="29" width="17%"><b>Name:</b></td>
<td height="29" width="39%">
<font size ="3">
<div align="left" name="Name" datasrc= "#xmlData" datafld="NameLabel"></div>
</font>
</td>
<td height="29" width="20%"><b>Date of Birth:</b></td>
<td height="29" width="24%"> <font size="3"> <div name="DateOfBirth" datasrc= "#xmlData" datafld="DateOfBirthLabel"></div>
</font></td>
</tr>
<tr>
<td width="17%"><b>Address:</b></td>
<td height="29" width="24%" colspan="2">
<div name="Address" datasrc= "#xmlData" datafld="AddressLabel"></div>
</td>
</tr>
<tr>
<td height="29" width="24%"><b>Certificate Number:</b> </td>
<td>
<div name="Certnum" datasrc= "#xmlData" datafld="CertificateNumberLabel"></div>
</td>
</tr>
</xsl:element>
</div>
</td>
</tr>
</xsl:element>
</center>
<input type="hidden" name="id" datasrc= "#xmlData" datafld="ID" size="5">
<xsl:attribute name="value"><xsl:value-of select="ID"/></xsl:attribute>
</input>
<form name="ApplicationForm" method="get" action="
<center>
<xsl:attribute name="method">get</xsl:attribute>
<div id="StatusLayer">
<xsl:element name="table">
<xsl:attribute name="border">0</xsl:attribute>
<xsl:attribute name="width">75%</xsl:attribute>
<tr>
<td>
<xsl:apply-templates select="//header" />
</td>
</tr>
<tr/>
<tr>
<td>
<xsl:element name="table">
<xsl:attribute name="border">0</xsl:attribute>
<xsl:attribute name="width">100%</xsl:attribute>
<tr>
<td width="25%">
<p>
<b>Date</b>
</p>
</td>
<td width="25%">
<p>
<b>Status</b>
</p>
</td>
<td width="25%">
<p>
<b>Reason</b>
</p>
</td>
<td>
<p>
<b>User</b>
</p>
</td>
</tr>
</xsl:element>
</td>
</tr>
<tr>
<table border="1" width="75%" height="67" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
<td width ="100%">
<DIV STYLE="overflow: auto; width: 780px; height: 70;
border-left: 1px gray solid; border-bottom: 1px gray solid;
padding:0px; margin: 0px">
<table border="0" width="100%" height="67" cellspacing="0" cellpadding="0">
<xsl:attribute name="style">font-family: monospace; font-size: 12</xsl:attribute>
<tr>
<td width="25%"><span datasrc= "#xmlData" datafld="StatusDateLabel"></span></td>
<td width="25%"><span datasrc= "#xmlData" datafld="StatusLabel"></span></td>
<td width="25%"><span datasrc= "#xmlData" datafld="StatusReasonLabel"></span></td>
<td width="25%"><span datasrc= "#xmlData" datafld="UserLabel"></span></td>
</tr>
</table>
i am trying to input the status history into the table enclosed in the DIV tag.
thankyou to anyone who takes the time to help
Kenneth Birney
User Interface Programmer
Scottish Police
Kenneth Birney
User Interface Programmer
Scottish Police