After running into the 2 gig limit on NT, I decided to have multiple
databases and combine the results, in way similar to something I posted
earlier (included at the end of the message). However, the ranking seems to
be a little off, as what I'm doing is grabbing the top 3 results from each
database, then combining and sorting. How does this ranking work? Is it
relative to the other results in the database, or is it an absolute number,
based only on the page? If it's relative, how can I modify my method to
return the correct results? I presume that I can't do some sort of join
across databases.
Thanks,
Erick
Here is how I combined results (not real code, just mockup)
<db=db1>
<sql "select $$rank Rank,Title, ..."></sql>
<db=db2>
<sql "select $$rank Rank2,Title Title2, ..."></sql>
<$r = $r1 $r2>
<$Rank=$Rank $Rank1>
<$Title=$Title $Title1>
...
<sort $Rank num desc $Title ...>
<loop $Rank $Title ...>
show hit
</loop>