Hi,
With regards to the bug that the php3 frontend for the postgresql databases
was reporting it found 'n' matches then only displaying 'n-1' results the patch
below should sort it.
It appears that '$from1' was being used with LIMIT instead of '$from' which
was causing one result less to be returned.
The patch should be applied to the search.php3 file in the:
udmsearch-2.2.1b/frontends/pgsql-php
directory.
Regards,
Neil Burrows
=========== Patch ==============================================
--- search.php3 Sat Mar 4 13:09:15 2000
+++ search.php3.modified Sat Mar 4 13:09:15 2000
@@ -380,14 +380,14 @@
AND dict.word in ($w)
GROUP BY url_id
HAVING ($qu)>0
- ORDER BY r DESC LIMIT $ps1,$from1";
+ ORDER BY r DESC LIMIT $ps1,$from";
else
$query="SELECT dict.url_id,sum(case when (dict.word in ($w))then 1 else
0 end)as r,($qu)as qu
FROM dict
WHERE dict.word in ($w)
GROUP BY url_id
HAVING ($qu)>0
- ORDER BY r DESC LIMIT $ps1,$from1";
+ ORDER BY r DESC LIMIT $ps1,$from";
if($DEBUG) echo $query,"<BR><HR>";
if (!($res=@pg_exec($zbsocket,$query)))
______________
If you want to unsubscribe send "unsubscribe udmsearch"
to [EMAIL PROTECTED]
