Content Query WebPart not showing hyperlink

Question

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 > Title b > div > td > td width = 10% valign = top > div class = item > b > Address b > div > td > td width = 10% valign = top > div class = item > b > Area b > div > td > td width = 10% valign = top > div class = item > b > ChoiceCol b > div > td > td width = 10% valign = top > div class = item > b > DateTimeCol b > 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.

Sumit Deshmukh · Answer

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

shoab shah · Answer

Hi Prasham Thanks for the reply. Could you please hare a sample code/ Link where huperlink is been displayed in output Thank you

Prasham Sabadra · Answer

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.