Content Query WebPart not showing hyperlink

I am quite new to Content Query WebPart. I have a list which as a 'Hyperklink or Picture' column. I have added below markup in itemstyle.xsl to show hyperlink

<xsl:template name="CQWPStyle" match="Row[@Style='CQWPStyle']" mode="itemstyle">
<html>
<table width="100%">
<xsl:if test="count(preceding-sibling::*)=0">
<tr>
<td width="10%" valign="top"><div class="item"><b>Titleb>div>td>
<td width="10%" valign="top"><div class="item"><b>Addressb>div>td>
<td width="10%" valign="top"><div class="item"><b>Areab>div>td>
<td width="10%" valign="top"><div class="item"><b>ChoiceColb>div>td>
<td width="10%" valign="top"><div class="item"><b>DateTimeColb>div>td>
tr>
xsl:if>
<tr>
<td width="10%" valign="top">
<div class="item">
<xsl:value-of select="@Title" />
div>
td>
<td width="10%" valign="top">
<div class="item">
<xsl:value-of select="@Address" disable-output-escaping="yes" />
div>
td>
<td width="10%" valign="top">
<div class="item">
<xsl:value-of select="@Area" />
div>
td>
<td width="10%" valign="top">
<div class="item">
<xsl:value-of select="@ChoiceCol" />
div>
td>
<td width="10%" valign="top">
<div class="item">
<xsl:value-of select="@DateTimeCol" />
div>
td>
<td width="10%" valign="top">
<div class="item">
<xsl:variable name="ActualLink" select="substring-before(@HyperLinkCol,',')"/>
<xsl:variable name="FriendlyName" select="substring-after(@HyperLinkCol,',')"/>
<a href="{$ActualLink}"><xsl:value-of select="$FriendlyName"/>a>
div>
td>
tr>
table>
html>

All other columns show as expected. However, the hyperlink column does not show. Kindly let me know, what I am missing.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sumit Deshmukh9y ago
Hi Shoab,

Sharing to you some useful links kindly try it.I hope you will get out something from it.

http://www.sharepoint-tips.com/2007/01/teach-content-query-web-part-how-to.html

http://doitwithsharepoint.blogspot.in/2011/04/url-fields-in-sharepoint-content-query.html

Hope it will helps to you.

Thanks
+1
shoab shah9y ago
Hi Prasham,
Thanks for the reply. Could you please hare a sample code/ Link where huperlink is been displayed in output

Thank you
0
Prasham Sabadra9y ago
Hi,

Code seems to be right. Only one thing I will suggest here, check value of @HyperLinkCol directly once, rather than before doing any string operation on that.
0