diff options
| author | David M <davidmj@users.sourceforge.net> | 2006-08-30 00:58:36 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2006-08-30 00:58:36 +0000 |
| commit | bb3034eb263cf001be0ce002e4442b29dd2ed33f (patch) | |
| tree | b10b6dbb21b45fc61e01784ba8c90be7b7356b53 /phpBB/search.php | |
| parent | bd4391d4cac93a7e224230a8b8f8fe0b7c199043 (diff) | |
| download | forums-bb3034eb263cf001be0ce002e4442b29dd2ed33f.tar forums-bb3034eb263cf001be0ce002e4442b29dd2ed33f.tar.gz forums-bb3034eb263cf001be0ce002e4442b29dd2ed33f.tar.bz2 forums-bb3034eb263cf001be0ce002e4442b29dd2ed33f.tar.xz forums-bb3034eb263cf001be0ce002e4442b29dd2ed33f.zip | |
- Bug #4000
git-svn-id: file:///svn/phpbb/trunk@6332 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/search.php')
| -rw-r--r-- | phpBB/search.php | 22 |
1 files changed, 18 insertions, 4 deletions
diff --git a/phpBB/search.php b/phpBB/search.php index a2feeab37c..d304e71f0d 100644 --- a/phpBB/search.php +++ b/phpBB/search.php @@ -956,10 +956,24 @@ $template->assign_vars(array( 'S_SELECT_SORT_DAYS' => $s_limit_days) ); -$sql = 'SELECT search_time, search_keywords - FROM ' . SEARCH_RESULTS_TABLE . ' - WHERE search_keywords <> \'\' - ORDER BY search_time DESC'; +// Can't do comparisons w/ TEXT on MSSQL, CAST is good enough +switch (SQL_LAYER) +{ + case 'mssql': + case 'mssql_odbc': + $sql = 'SELECT search_time, search_keywords + FROM ' . SEARCH_RESULTS_TABLE . ' + WHERE CAST(search_keywords AS varchar) <> \'\' + ORDER BY search_time DESC'; + break; + + default: + $sql = 'SELECT search_time, search_keywords + FROM ' . SEARCH_RESULTS_TABLE . ' + WHERE search_keywords <> \'\' + ORDER BY search_time DESC'; + break; +} $result = $db->sql_query_limit($sql, 5); while ($row = $db->sql_fetchrow($result)) |