Does anyone know how I can make this work? I have a query that gathers the names of picture files from a server and I need them to display in the SQLview module. The query looks like this:
Select Pic1, Pic2, Pic3, Pic4 From RealEstate_DNN_Listing Where CAST(ID AS VarChar(10))='[QUERYSTRING:ID]'
The link from the other page provides the ID number and the query works fine, I get the filenames for Pic1, Pic2 etc.
I need them to display in a single column but the grid view will only put them in a row. I have an XSL file that will show the filenames, I just can't get the syntax right to point to the actual files on the web server such as: http://www.Picserver.com/newpics/121b07f3-b0cb-46e5-bb02-741be895c1bd.jpg
_________________________________________
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="SQLData">
<B>Pictures</B><BR/>
<TABLE CELLPADDING="8" CELLSPACING="1" Border="1">
<xsl:for-each select="Table">
<TR>
<TD><xsl:value-of select="Pic1"/></TD>
<TD><xsl:value-of select="Pic2"/></TD>
<TD><xsl:value-of select="Pic3"/></TD>
<TD><xsl:value-of select="Pic4"/></TD>
</TR>
</xsl:for-each>
</TABLE>
</xsl:template>
</xsl:stylesheet>
__________________________________________
This is the result of the template above:
Pictures
121b07f3-b0cb-46e5-bb02-741be895c1bd.jpg c22bcb6a-49ac-4647-86e5-585dcb4c1805.jpg a63dfe9f-4291-48b2-a9b5-2c441979cfa5.jpg 5a5fb05f-fa9d-4747-85a0-619f70352ffa.jpg
-M.Pratt