diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-03-05 02:21:22 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-03-05 02:21:22 +0000 |
| commit | 0daf91e6683902233fe53a7560f5b94e7d0cd66c (patch) | |
| tree | 35d935c44d971f82621f0c4f392cf55c03115e39 /phpBB/includes | |
| parent | 28b38f054786014f436eefa019308eb8658cb711 (diff) | |
| download | forums-0daf91e6683902233fe53a7560f5b94e7d0cd66c.tar forums-0daf91e6683902233fe53a7560f5b94e7d0cd66c.tar.gz forums-0daf91e6683902233fe53a7560f5b94e7d0cd66c.tar.bz2 forums-0daf91e6683902233fe53a7560f5b94e7d0cd66c.tar.xz forums-0daf91e6683902233fe53a7560f5b94e7d0cd66c.zip | |
mssql-odbc doesn't seem to like ignoring the duplicate index (even though MSSQL has been told to ... hmm)
git-svn-id: file:///svn/phpbb/trunk@2270 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes')
| -rw-r--r-- | phpBB/includes/search.php | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/phpBB/includes/search.php b/phpBB/includes/search.php index c8d40a8d58..0b68af8f1c 100644 --- a/phpBB/includes/search.php +++ b/phpBB/includes/search.php @@ -172,6 +172,7 @@ function add_search_words($post_id, $post_text, $post_title = "") { case 'postgresql': case 'msaccess': + case 'mssql-odbc': case 'oracle': case 'db2': $sql = "SELECT word_id, word_text @@ -208,7 +209,6 @@ function add_search_words($post_id, $post_text, $post_title = "") $value_sql .= ( ( $value_sql != "" ) ? ", " : "" ) . "('" . $word[$i] . "')"; break; case 'mssql': - case 'mssql-odbc': $value_sql .= ( ( $value_sql != "" ) ? " UNION ALL " : "" ) . "SELECT '" . $word[$i] . "'"; break; default: @@ -233,7 +233,6 @@ function add_search_words($post_id, $post_text, $post_title = "") VALUES $value_sql"; break; case 'mssql': - case 'mssql-odbc': $sql = "INSERT INTO " . SEARCH_WORD_TABLE . " (word_text) $value_sql"; break; |