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!

Register Log in
  • 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!

How come no data is being transformed ?

Status
Not open for further replies.
cpope

cpope

Programmer
Jul 7, 2000
58
US
I have an xml document...

<?xml version="1.0" encoding="utf-8"?>
<?xml-stylesheet type="text/xsl" href="transform.xsl"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV=" xmlns:soap=" xmlns:xsi=" xmlns:xsd=" <SOAP-ENV:Body>
<LoginResponse xmlns="urn:CICSMCSWSAD1">
<ACCOUNT>0123456789
</ACCOUNT>
<USERID>guest1
</USERID>
<PASSWORD>guest1pwd
</PASSWORD>
<PASSWORDHINT>pwd plus user id
</PASSWORDHINT>
<EMAIL>guest1@email.com
</EMAIL>
<REGISTRATIONKEY>deprecated
</REGISTRATIONKEY>
<LOGINSUCCESS>Y
</LOGINSUCCESS>
<PROCESSSUCCESS>Y
</PROCESSSUCCESS>
<LASTACCESS>12-24-2002
</LASTACCESS>
<CREATEDATE>11-11-2002
</CREATEDATE>
</LoginResponse>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

my transformation is as follows:

<?xml version="1.0" encoding="utf-8"?>
<xsl:transform version="1.0" xmlns:xsl=" xmlns:SOAP-ENV=" <xsl:template match="/">
<html>
<head>
<title>Testing Transformation</title>
</head>
<body>
<table border="1">
<th>Account</th><th>Hint</th><th>Last Access</th><th>Reg. Date</th><th>User</th>
<xsl:for-each select="SOAP-ENV:Envelope/SOAP-ENV:Body/LoginResponse">
<tr><td><xsl:value-of select="ACCOUNT"/></td>
<td><xsl:value-of select="PASSWORDHINT"/></td>
<td><xsl:value-of select="LASTACCESS"/></td>
<td><xsl:value-of select="CREATEDATE"/></td>
<td><xsl:value-of select="USERID"/></td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:transform>

The table shows up fine, but no data is loaded....
 
Sort by date Sort by votes
Problem solved by adding a prefix and assigning it to the urn value in the xml file... xmlns:CIC="urn:CICSMCSWSAD1", then using that prefix to select the LoginResponse and it's child nodes...

<?xml version="1.0" encoding="utf-8"?>
<xsl:transform version="1.0" xmlns:xsl=" xmlns:SOAP-ENV=" xmlns:CIC="urn:CICSMCSWSAD1">
<xsl:template match="/">
<html>
<head>
<title>Testing Transformation</title>
</head>
<body>
<table border="1">
<th>Account</th><th>Hint</th><th>Last Access</th><th>Reg. Date</th><th>User</th>
<xsl:for-each select="SOAP-ENV:Envelope/SOAP-ENV:Body/CIC:LoginResponse">
<tr><td><xsl:value-of select="CIC:ACCOUNT"/></td>
<td><xsl:value-of select="CIC:pASSWORDHINT"/></td>
<td><xsl:value-of select="CIC:LASTACCESS"/></td>
<td><xsl:value-of select="CIC:CREATEDATE"/></td>
<td><xsl:value-of select="CIC:USERID"/></td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:transform>
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

P
  • Locked
  • Question
How to re-use a recursive template
Replies
1
Views
898
pdrapeau
P
Sunil Sharma
  • Locked
  • Question
Add Minus (-) into pattern but constrain is Munis (-) should not be first character
Replies
1
Views
847
mikrom
mikrom
dawna3
  • Locked
  • Question
exporting blog posts to XML but how to read?!
Replies
0
Views
790
dawna3
dawna3
SitesMasstec
  • Locked
  • Question
XML data not displaying
Replies
2
Views
909
jjgupta915
jjgupta915
rajneesh4u
  • Locked
  • Question
Is it possible to impose required constraint at value level?
Replies
1
Views
308
atlopes
atlopes

Part and Inventory Search

Sponsor

Back
Top