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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

please help, bit of a problem

Status
Not open for further replies.

birney29

Programmer
Oct 11, 2001
140
GB
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=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?>
<?xml-stylesheet type=&quot;text/xsl&quot; href=&quot;ApplicationDetailsApplicant.xsl&quot;?>
<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=&quot;1&quot;>
<StatusDateLabel >12/03/2002</StatusDateLabel>
<StatusLabel>Application Received</StatusLabel>
<StatusReasonLabel/>
<UserLabel>guest</UserLabel>
</SharedBy>
<SharedBy person=&quot;1&quot;>
<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 = &quot;xmlData&quot;>
<details>
<xsl:for-each select=&quot;details/ApplicationDetailsApplicant&quot;>
<ApplicationDetailsApplicant>
<SequenceID><xsl:value-of select=&quot;SequenceID&quot;></xsl:value-of></SequenceID>
<NameLabel><xsl:value-of select=&quot;NameLabel&quot;></xsl:value-of></NameLabel>
<AddressLabel><xsl:value-of select=&quot;AddressLabel&quot;></xsl:value-of></AddressLabel>
<DateOfBirthLabel><xsl:value-of select=&quot;DateOfBirthLabel&quot;></xsl:value-of></DateOfBirthLabel>
<CertificateLabel><xsl:value-of select=&quot;CertificateLabel&quot;></xsl:value-of></CertificateLabel>
<CertificateNumberLabel><xsl:value-of select=&quot;CertificateNumberLabel&quot;></xsl:value-of></CertificateNumberLabel>
<ApplicationType><xsl:value-of select=&quot;ApplicationType&quot;></xsl:value-of></ApplicationType>
<ID><xsl:value-of select=&quot;ID&quot;></xsl:value-of> </ID>
<ApplicationForCoterminous><xsl:value-of select=&quot;ApplicationForCoterminous&quot;></xsl:value-of></ApplicationForCoterminous>
<Status><xsl:value-of select=&quot;Status&quot;></xsl:value-of></Status>
<Reason><xsl:value-of select=&quot;Reason&quot;></xsl:value-of></Reason>
<DateReceived> <xsl:value-of select=&quot;DateReceived&quot;></xsl:value-of></DateReceived>
<DateAccepted><xsl:value-of select=&quot;DateAccepted&quot;></xsl:value-of></DateAccepted>
<DateAppliedFor><xsl:value-of select=&quot;DateAppliedFor&quot;></xsl:value-of></DateAppliedFor>
<Comments><xsl:value-of select=&quot;Comments&quot;></xsl:value-of></Comments>
<AppealLodged><xsl:value-of select=&quot;AppealLodged&quot;></xsl:value-of></AppealLodged>
<AppealUpheld><xsl:value-of select=&quot;AppealUpheld&quot;></xsl:value-of></AppealUpheld>
<xsl:for-each select=&quot;StatusBox/SharedBy&quot;>
<StatusDateLabel><xsl:value-of select=&quot;StatusDateLabel&quot;></xsl:value-of></StatusDateLabel>
<StatusLabel><xsl:value-of select=&quot;StatusLabel&quot;></xsl:value-of></StatusLabel>
<StatusReasonLabel><xsl:value-of select=&quot;StatusReasonLabel&quot;></xsl:value-of></StatusReasonLabel>
<UserLabel><xsl:value-of select=&quot;UserLabel&quot;></xsl:value-of></UserLabel>
</xsl:for-each>
</ApplicationDetailsApplicant>
</xsl:for-each>
</details>
</xml>

<xsl:element name=&quot;table&quot;>
<xsl:attribute name=&quot;border&quot;>1</xsl:attribute>
<xsl:attribute name=&quot;width&quot;>75%</xsl:attribute>
<xsl:attribute name=&quot;align&quot;>center</xsl:attribute>
<tr>
<td height=&quot;63&quot;>
<div align=&quot;center&quot;>
<xsl:element name=&quot;table&quot;>
<xsl:attribute name=&quot;border&quot;>0</xsl:attribute>
<xsl:attribute name=&quot;width&quot;>75%</xsl:attribute>
<xsl:attribute name=&quot;bordercolor&quot;>#CCCCCC</xsl:attribute>
<xsl:attribute name=&quot;align&quot;>center</xsl:attribute>
<xsl:attribute name=&quot;height&quot;>100%</xsl:attribute>
<tr>

</tr>
<tr>
<td height=&quot;29&quot; width=&quot;17%&quot;><b>Name:</b></td>
<td height=&quot;29&quot; width=&quot;39%&quot;>
<font size =&quot;3&quot;>
<div align=&quot;left&quot; name=&quot;Name&quot; datasrc= &quot;#xmlData&quot; datafld=&quot;NameLabel&quot;></div>
</font>
</td>

<td height=&quot;29&quot; width=&quot;20%&quot;><b>Date of Birth:</b></td>
<td height=&quot;29&quot; width=&quot;24%&quot;> <font size=&quot;3&quot;> <div name=&quot;DateOfBirth&quot; datasrc= &quot;#xmlData&quot; datafld=&quot;DateOfBirthLabel&quot;></div>
</font></td>
</tr>
<tr>
<td width=&quot;17%&quot;><b>Address:</b></td>
<td height=&quot;29&quot; width=&quot;24%&quot; colspan=&quot;2&quot;>
<div name=&quot;Address&quot; datasrc= &quot;#xmlData&quot; datafld=&quot;AddressLabel&quot;></div>
</td>
</tr>
<tr>
<td height=&quot;29&quot; width=&quot;24%&quot;><b>Certificate Number:</b> </td>
<td>
<div name=&quot;Certnum&quot; datasrc= &quot;#xmlData&quot; datafld=&quot;CertificateNumberLabel&quot;></div>
</td>


</tr>
</xsl:element>
</div>
</td>
</tr>
</xsl:element>
</center>





<input type=&quot;hidden&quot; name=&quot;id&quot; datasrc= &quot;#xmlData&quot; datafld=&quot;ID&quot; size=&quot;5&quot;>
<xsl:attribute name=&quot;value&quot;><xsl:value-of select=&quot;ID&quot;/></xsl:attribute>
</input>



<form name=&quot;ApplicationForm&quot; method=&quot;get&quot; action=&quot;
<center>
<xsl:attribute name=&quot;method&quot;>get</xsl:attribute>



<div id=&quot;StatusLayer&quot;>
<xsl:element name=&quot;table&quot;>
<xsl:attribute name=&quot;border&quot;>0</xsl:attribute>
<xsl:attribute name=&quot;width&quot;>75%</xsl:attribute>
<tr>
<td>
<xsl:apply-templates select=&quot;//header&quot; />
</td>
</tr>
<tr/>
<tr>
<td>
<xsl:element name=&quot;table&quot;>
<xsl:attribute name=&quot;border&quot;>0</xsl:attribute>
<xsl:attribute name=&quot;width&quot;>100%</xsl:attribute>

<tr>
<td width=&quot;25%&quot;>
<p>
<b>Date</b>
</p>
</td>
<td width=&quot;25%&quot;>
<p>
<b>Status</b>
</p>
</td>
<td width=&quot;25%&quot;>
<p>
<b>Reason</b>
</p>
</td>
<td>
<p>
<b>User</b>
</p>
</td>
</tr>
</xsl:element>
</td>
</tr>
<tr>
<table border=&quot;1&quot; width=&quot;75%&quot; height=&quot;67&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; bgcolor=&quot;#FFFFFF&quot;>
<td width =&quot;100%&quot;>

<DIV STYLE=&quot;overflow: auto; width: 780px; height: 70;
border-left: 1px gray solid; border-bottom: 1px gray solid;
padding:0px; margin: 0px&quot;>

<table border=&quot;0&quot; width=&quot;100%&quot; height=&quot;67&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot;>
<xsl:attribute name=&quot;style&quot;>font-family: monospace; font-size: 12</xsl:attribute>


<tr>
<td width=&quot;25%&quot;><span datasrc= &quot;#xmlData&quot; datafld=&quot;StatusDateLabel&quot;></span></td>
<td width=&quot;25%&quot;><span datasrc= &quot;#xmlData&quot; datafld=&quot;StatusLabel&quot;></span></td>
<td width=&quot;25%&quot;><span datasrc= &quot;#xmlData&quot; datafld=&quot;StatusReasonLabel&quot;></span></td>
<td width=&quot;25%&quot;><span datasrc= &quot;#xmlData&quot; datafld=&quot;UserLabel&quot;></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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top