Hi all, I have been trying to get this working for hours and days now and need a fresh pair of eyes to tell me what I'm doing wrong. I hope someone out there can help. Thanks you so much in advance if you able to help :)
BACKGROUND INFO
I have the following two xml files that are combined together into one xml file and then transformed using server side XSLT, PHP and the MODx content management system.
WHAT I AM TRYING TO DO
From a long list of hotels in the xml file (hotellist.xml - please see below), I am trying to call ONE hotel in particular with the ID of '1234567' and get it's 'hotelurl' value and place this into a link using XSLT.
THE PROBLEM
The problem I am having with the XSL below is with the 'ThisHotelID' variable and 'HotelURL' variable. I don't get an error but I can't seem to be able to get the value of the 'ThisHotelID' variable into the variable of 'HotelURL' - it seems to just ignore it and parse the variable as if it's empty?!
MY QUESTIONS
What am I doing wrong here?
Are you not able to put a variable within another variable?
What is the best way to do this?
------------------------------------------------- CODE -------------------------------------------------
[b]XML 1[/b] (hotelinfo.xml)
<Hotel>
<HotelID>1234567</HotelID>
<HotelName>Hotel Name Here</HotelName>
<HotelAddress>Hotel Address Here</HotelAddress>
<City>City Name</City>
<Country>Country Name</Country>
<StarRating>5</StarRating>
<!-- There is lots more information in this xml file omitted here to save space -->
</Hotel>
[b]XML 2[/b] (hotellist.xml)
<hotels>
<hotel id="1234567">
<hotelname>Hotel Name Here</hotelname>
<hotelurl>[b][i]/link/to/hotel/url/on/server.php[/i][/b]</hotelurl>
<latitude>18.76624</latitude>
<longitude>98.99526</longitude>
</hotel>
<hotel id="7654321">
<hotelname>Hotel Name Here</hotelname>
<hotelurl>/link/to/hotel/url/on/server.php</hotelurl>
<latitude>18.76624</latitude>
<longitude>98.99526</longitude>
</hotel>
<!-- There are lots more hotels in this xml file omitted here to save space -->
</hotels>
[b]COMBINED XML FILE[/b] (combined.xml)
<hoteldetails>
<file href="http://www.mydomain.org/hotels/hotelinfo.xml"/>
<file href="http://www.mydomain.org/hotels/hotellist.xml"/>
</hoteldetails>
[b]XSL FILE[/b] (hotel.xsl)
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html" encoding="UTF-8" doctype-public="-//W3C//DTD XHTML 1.0 Transitional//EN" doctype-system="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"/>
<xsl:template match="hoteldetails">
<h1><xsl:value-of select="document(file/@href)/Hotel/HotelName"/></h1>
<p><xsl:value-of select="document(file/@href)/Hotel/Address"/></p>
<xsl:variable name="[b][i]ThisHotelID[/i][/b]"><xsl:value-of select="document(file/@href)/Hotel/HotelID" /></xsl:variable>
<xsl:variable name="[b][i]HotelURL[/i][/b]"><xsl:value-of select="document(file/@href)/hotels/hotel[@id='[b][i]{$ThisHotelID}[/i][/b]']/hotelurl" /></xsl:variable>
<p>
<a href="http://www.mydomain.org[b][i]{$HotelURL}[/i][/b]" title="Click to view the {document(file/@href)/Hotel/HotelName}" target="_top">
<img src="http://www.mydomain.org/hotels/images/image.jpg" alt="{document(file/@href)/Hotel/HotelName}" />
</a>
</p>
<!-- There are a lot more hotels and hotels info in this xml file omitted here to save space -->
</xsl:template>
</xsl:stylesheet>
