Thunderstone Support Forums

I have made the changes in the search script.Everything went well but i m not able to retrieve the images with the news.
Here is my piece of code
<a name=resultConcise>
<table border=0 width=75% valign=top cellpadding=2 cellspacing=7><tr>

<showThumb>
<td valign=top colspan=100%><result_title><BR>
<span class="newsGreenHeader">$SiteName </span>- <nobr> <reltime then=$Visited>
<font size=-1><b class="newsDays"><fmt "%20.20s" $ret></nobr></b></font><br>
<FONT SIZE="-1">
<capture><result_abstract></capture>
<sandr ">>=.{90}[^\space]*" "\2\3<BR>" $ret>
<send $ret>
<BR>
<FONT COLOR="#008000"><!-- <sandr ">>=http://=" "" $durl>
<send $ret><send " - "> <result_docsize><send " - </FONT>">-->
<!-- <result_info class=" CLASS=y"><send " - "> -->
<result_similar class=" CLASS=green" text="Similar pages"></FONT></td>
</tr>
</table>
</a>


Now in the end of search script i added this code
<A NAME=showimg PUBLIC>
<$pr="TechNews">
<strfmt '/usr/local/morph3/texis/%s/db1' $pr><$db=$ret>
<db=$db>
<header name="Content-Type: image/gif">
<sql max=1 "select convert(Thumb, 'varbyte') ThumbnailData from html where id=$id">
<fmt "%s" $ThumbnailData>
</sql>
$ret
</A>
<A NAME=showThumb>
<if $Thumb neq "">
<strfmt '%s/%s.jpg' $imageUrl $id><$imgPath=$ret>
<td width=80 align=center valign=top>
<a href="$Url"><img src="$imgPath" border=1></a>
</td>
</if>
</A>
I have correctely initialise $imageUrl in the begining of the search script.
Please letme know if any more clarification is needed on it
Thanks in advance