diff options
| author | Lester Caine <lester@lsces.co.uk> | 2006-10-21 20:21:52 +0000 |
|---|---|---|
| committer | Lester Caine <lester@lsces.co.uk> | 2006-10-21 20:21:52 +0000 |
| commit | d6039b3a7ca9081049c279bc788034fac43a6b49 (patch) | |
| tree | b47f9f0a2c4671b3f3bd0c1873bf2b5022c93a9a | |
| parent | 5f0523a423193fe444443eabfa88ab78a02ff088 (diff) | |
| download | search-d6039b3a7ca9081049c279bc788034fac43a6b49.tar.gz search-d6039b3a7ca9081049c279bc788034fac43a6b49.tar.bz2 search-d6039b3a7ca9081049c279bc788034fac43a6b49.zip | |
Search result only works for a single word in Firebird
| -rw-r--r-- | search_lib.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/search_lib.php b/search_lib.php index d51dae9..a7288fc 100644 --- a/search_lib.php +++ b/search_lib.php @@ -1,6 +1,6 @@ <?php /** - * $Header: /cvsroot/bitweaver/_bit_search/search_lib.php,v 1.26 2006/09/06 08:33:23 lsces Exp $ + * $Header: /cvsroot/bitweaver/_bit_search/search_lib.php,v 1.27 2006/10/21 20:21:52 lsces Exp $ * * Copyright (c) 2004 bitweaver.org * Copyright (c) 2003 tikwiki.org @@ -8,7 +8,7 @@ * All Rights Reserved. See copyright.txt for details and a complete list of authors. * Licensed under the GNU LESSER GENERAL PUBLIC LICENSE. See license.txt for details * - * $Id: search_lib.php,v 1.26 2006/09/06 08:33:23 lsces Exp $ + * $Id: search_lib.php,v 1.27 2006/10/21 20:21:52 lsces Exp $ * @author Luis Argerich (lrargerich@yahoo.com) * @package search */ @@ -196,7 +196,7 @@ class SearchLib extends BitBase { LEFT OUTER JOIN `".BIT_DB_PREFIX."liberty_content_hits` lch ON (lc.`content_id` = lch.`content_id`) $joinSql WHERE ( - SELECT SUM(i_count) + SELECT FIRST 1 SUM(i_count) FROM `" . BIT_DB_PREFIX . "search_index` si WHERE si.`content_id`=lc.`content_id` GROUP BY |