diff options
| author | David M <davidmj@users.sourceforge.net> | 2006-12-14 20:36:07 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2006-12-14 20:36:07 +0000 |
| commit | 837fcd1295bb1872cde70db049bd65b2a98c6121 (patch) | |
| tree | d573725b316e79484ab07831d528e1844aa8fe06 /phpBB/search.php | |
| parent | 62763d3f3d2ab758a6de8294e36adb4268f6054b (diff) | |
| download | forums-837fcd1295bb1872cde70db049bd65b2a98c6121.tar forums-837fcd1295bb1872cde70db049bd65b2a98c6121.tar.gz forums-837fcd1295bb1872cde70db049bd65b2a98c6121.tar.bz2 forums-837fcd1295bb1872cde70db049bd65b2a98c6121.tar.xz forums-837fcd1295bb1872cde70db049bd65b2a98c6121.zip | |
#6264
git-svn-id: file:///svn/phpbb/trunk@6764 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/search.php')
| -rw-r--r-- | phpBB/search.php | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/phpBB/search.php b/phpBB/search.php index e8898141c0..d0575bdc3c 100644 --- a/phpBB/search.php +++ b/phpBB/search.php @@ -999,11 +999,18 @@ $template->assign_vars(array( // Can't do comparisons w/ TEXT on MSSQL, CAST is good enough switch ($db->sql_layer) { + case 'oracle': + $sql = 'SELECT search_time, search_keywords + FROM ' . SEARCH_RESULTS_TABLE . ' + WHERE dbms_lob.getlength(search_keywords) > 0 + ORDER BY search_time DESC'; + break; + case 'mssql': case 'mssql_odbc': $sql = 'SELECT search_time, search_keywords FROM ' . SEARCH_RESULTS_TABLE . ' - WHERE CAST(search_keywords AS varchar) <> \'\' + WHERE DATALENGTH(search_keywords) > 0 ORDER BY search_time DESC'; break; |