site collapsing

feles · Post by **feles** » Fri Aug 31, 2001 5:30 pm

I have indexed 15 sites on my company and when i search a term like internet the result set returns the first 20 result from one site how can I make the search script return one url for each site?

bart · Post by **bart** » Fri Aug 31, 2001 8:09 pm

That would require a bit of effort on the inner loop of the primary <sql "select...">
statement. You'll have to learn a little about texis web script to do this.

feles · Post by **feles** » Sat Sep 01, 2001 3:26 am

Do you have any examples like this one ?

bart · Post by **bart** » Sat Sep 01, 2001 8:10 am

Sorry, nothing we could show you would be of any real use.

the loop would probably look something like this though:

<sql "select Url,abstract(..)... from html where ....">
<rex ">>=[^/]+" $Url>
<if $ret neq $lastsite>
<$lastsite=$ret>
<show the hit>
</if>
</sql>

bart · Post by **bart** » Sat Sep 01, 2001 8:14 am

Oh yeah, I forgot to mention... If this were a full Texis license instead of a Webinator this would be a lot easier because you'd just add a field to the html table to contain the site name. Then you could just check it directly.