FT Search with nois words

Hello,
Is there a way to make it possible to search for the following
searchstring with containstable?
"test AND is"
what i mean is that it will ignore the word "is" but will continu
searching for "test"
thnx in advance,
Marius
Your best bets are to use FreeTextTable or parse the noise words out at the
client. Please find a sample attached.
You could also remove is and other noise words from your noise word list to
get rid of this message.
"Marius" <marius@.kanniets.nl> wrote in message
news:65032a84.0410190111.196b8638@.posting.google.c om...
> Hello,
> Is there a way to make it possible to search for the following
> searchstring with containstable?
> "test AND is"
> what i mean is that it will ignore the word "is" but will continu
> searching for "test"
> thnx in advance,
> Marius
begin 666 searchpage1.htm
M__X\`$@.`5 !-`$P`/@.`-``H`/ !(`$4`00!$`#X`#0`*`#P`4P!4`%D`3 !%
M`" `5 !9`% `10`]`"(`= !E`'@.`= `O`&,`<P!S`"(`/@.`-``H`0@.!/`$0`
M60`@.``D`"0![`&8`;P!N`'0`+0!F`&$`;0!I`&P`>0`Z`%0`8 0!H`&\`;0!A
M`"P`00!R`&D`80!L`"P`<P!A`&X`<P`M`',`90!R`&D`9@.`[` " `9@.!O`&X`
M= `M`',`:0!Z`&4`.@.`Q`# `< !T`'T`#0`*`"X`+@.!H`&4`80!D`&D`;@.!G
M``D`>P!F`&\`;@.!T`"T`9@.!A`&T`:0!L`'D`.@.!4`&$`: !O`&T`80`L`$$`
M<@.!I`&$`; `L`',`80!N`',`+0!S`&4`<@.!I`&8`.P`@.`&8`;P!N`'0`+0!S
M`&D`>@.!E`#H`,0`T`' `= `[`" `9@.!O`&X`= `M`'<`90!I`&<`: !T`#H`
M8@.!O`&P`9 !]``T`"@.`N`"X`8P!I`'0`90`)``D`>P!F`&\`;@.!T`"T`9@.!A
M`&T`:0!L`'D`.@.!4`&$`: !O`&T`80`L`$$`<@.!I`&$`; `L`',`80!N`',`
M+0!S`&4`<@.!I`&8`.P`@.`&8`;P!N`'0`+0!S`&D`>@.!E`#H`. !P`'0`?0`-
M``H`+@.`N`&0`;P!C`'4`;0!E`&X`= `)`'L`9@.!O`&X`= `M`',`:0!Z`&4`
M.@.`Q`# `< !T`#L`( !F`&\`;@.!T`"T`=P!E`&D`9P!H`'0`.@.!B`&\`; !D
M`#L`( !B`&$`8P!K`&<`<@.!O`'4`;@.!D`"T`8P!O`&P`;P!R`#H`; !I`&<`
M: !T`&<`<@.!E`'D`.P`@.`'<`:0!D`'0`: `Z`#$`, `P`"4`?0`-``H`/ `O
M`%,`5 !9`$P`10`^``T`"@.`\`%,`0P!2`$D`4 !4`" `3 !!`$X`1P!5`$$`
M1P!%`#T`(@.!*`&$`=@.!A`%,`8P!R`&D`< !T`"(`( !4`%D`4 !%`#T`(@.!T
M`&4`> !T`"\`:@.!A`'8`80!S`&,`<@.!I`' `= `B`#X`#0`*`#P`(0`M`"T`
M#0`*``T`"@.!V`&$`<@.`@.`&P`90!T`'0`90!R`&4`> !P`" `/0`@.`"\`6P!A
M`"T`>@.`P`#D`70`O`&D`.P`-``H`9@.!U`&X`8P!T`&D`;P!N`" `: !A`',`
M3 !E`'0`= !E`'(`* !S`'0`<@.`I`" `>P!R`&4`= !U`'(`;@.`@.`&P`90!T
M`'0`90!R`&4`> !P`"X`= !E`',`= `H`',`= !R`"D`?0`[``T`"@.`-``H`
M9@.!U`&X`8P!T`&D`;P!N`" `8P!H`&4`8P!K`&8`;P!R`&T`* !F`&\`<@.!M
M`"D`#0`*`'L`#0`*``T`"@.`)`&D`9@.`@.`" `* `A`&@.`80!S`$P`90!T`'0`
M90!R`"@.`9@.!O`'(`;0`N`'0`80!R`&<`90!T`"X`=@.!A`&P`= 0!E`"D`*0`-
M``H`"0![``T`"@.`)``D`80!L`&4`<@.!T`"@.`(@.!)`&X`=@.!A` &P`:0!D`" `
M<P!E`&$`<@.!C`&@.`( !S`'0`<@.!I`&X`9P`B`"D`.P`-``H`"0`)`&8`;P!R
M`&T`+@.!T`&$`<@.!G`&4`= `N`&8`;P!C`'4`<P`H`"D`.P`-``H`"0`)`'(`
M90!T`'4`<@.!N`" `9@.!A`&P`<P!E`#L`#0`*``D`?0`-``H`"0!E`&P`<P!E
M``T`"@.`)`'L`#0`*``D`"0!T`&4`<P!T`#T`<@.!E`&T`;P!V` &4`7P!N`&\`
M:0!S`&4`* !F`&\`<@.!M`"X`= !A`'(`9P!E`'0`+@.!V`&$`; !U`&4`*0`[
M``T`"@.`)``D`:0!F`"@.`(0!T`&4`<P!T`"X`; !E`&X`9P!T`&@.`*0`-``H`
M"0`)``D`>P`-``H`"0`)``D`80!L`&4`<@.!T`"@.`(@.!I`&X`=@.!A`&P`:0!D
M`" `<P!T`'(`:0!N`&<`( `M`" `= !O`&\`( !M`&$`;@.!Y`" `;@.!O`&D`
M<P!E`" `=P!O`'(`9 !S`"(`*0`[``T`"@.`)``D`"0!F`&\`<@.!M`"X`= !A
M`'(`9P!E`'0`+@.!F`&\`8P!U`',`* `I`#L`#0`*``D`"0`)`'(`90!T`'4`
M<@.!N`" `9@.!A`&P`<P!E`#L`#0`*``D`"0`)`'T`#0`*``D`"0!E`&P`< P!E
M``T`"@.`)``D`>P`-``H`"0`)`&8`;P!R`&T`+@.!T`&$`<@.!G`&4`= `N`'8`
M80!L`'4`90`]`'0`90!S`'0`.P`-``H`"0`)`'(`90!T`'4`<@.!N`" `= !R
M`'4`90`[``T`"@.`)``D`?0`-``H`"0!]``T`"@.!]``T`"@.`-``H`9@.!U`&X`
M8P!T`&D`;P!N`" `<@.!E`&T`;P!V`&4`7P!N`&\`:0!S`&4`* !P`&@.`<@.!A
M`',`90`I``T`"@.![``T`"@.`O`"\`9 !I`&T`90!N`',`:0!O`&X`80!L`&D`
M>@.!I`&X`9P`@.`'8`80!R`&D`80!B`&P`90!S``T`"@.!N`&\`: 0!S`&4`80!R
M`'(`80!Y`#T`;@.!E`'<`( !!`'(`<@.!A`'D`* `I`#L`#0`*`&$`<@.!R`&$`
M>0!?`' `: !R`&$`<P!E`#T`;@.!E`'<`( !!`'(`<@.!A`'D`* `I`#L`#0`*
M`&$`<@.!R`&$`>0!?`' `<@.!U`&X`90!D`#T`;@.!E`'<`( !!`'(`<@.!A`'D`
M* `I`#L`#0`*``T`"@.!V`&$`<@.`@.`&X`;P!I`',`90!A`'(`<@.!A `'D`/0!N
M`&4`=P`@.`$$`<@.!R`&$`>0`@.`"@.`(@.`P`"(`+ `B`#$`(@.`L`"(`,@.`B`"P`
M(@.`S`"(`+ `B`#0`(@.`L`"(`-0`B`"P`(@.`V`"(`+ `B`#<`(@.`L`"(`. `B
M`"P`(@.`Y`"(`+ `B`"0`(@.`L`"(`80`B`"P`(@.!A`&(`;P!U`'0`(@.`L`"(`
M80!F`'0`90!R`"(`+ `B`&$`; !L`"(`+ `B`&$`; !S`&\`(@.`L`"(`80!N
M`"(`+ `B`&$`;@.!D`"(`+ `B`&$`;@.!O`'0`: !E`'(`(@.`L`"(`80!N`'D`
M(@.`L`"(`80!R`&4`(@.`L`"(`80!S`"(`+ `B`&$`= `B`"P`(@.!B`"(`+ `B
M`&(`90`B`"P`(@.!B`&4`8P!A`'4`<P!E`"(`+ `B`&(`90!E`&X`(@.`L`"(`
M8@.!E`&8`;P!R`&4`(@.`L`"(`8@.!E`&D`;@.!G`"(`+ `B`&(`90!T`'<`90!E
M`&X`(@.`L`"(`8@.!O`'0`: `B`"P`(@.!B`'4`= `B`"P`(@.!B`'D`(@.`L`"(`
M8P`B`"P`(@.!C`&$`;0!E`"(`+ `B`&,`80!N`"(`+ `B`&,`;P!M`&4`(@.`L
M`"(`8P!O`'4`; !D`"(`+ `B`&0`(@.`L`"(`9 !I`&0`(@.`L`"(`9 !O`"(`
M+ `B`&0`;P!E`',`(@.`L`"(`90`B`"P`(@.!E`&$`8P!H`"(`+ `B`&4`; !S
M`&4`(@.`L`"(`9@.`B`"P`(@.!F`&\`<@.`B`"P`(@.!F`'(`;P!M` "(`+ `B`&<`
M(@.`L`"(`9P!E`'0`(@.`L`"(`9P!O`'0`(@.`L`"(`: `B`"P`(@.!H`&$`9 `B
M`"P`(@.!H`&$`<P`B`"P`(@.!H`&$`=@.!E`"(`+ `B`&@.`90`B`"P`(@.!H`&4`
M<@.`B`"P`(@.!H`&4`<@.!E`"(`+ `B`&@.`:0!M`"(`+ `B`&@.`:0!M`',`90!L
M`&8`(@.`L`"(`: !I`',`(@.`L`"(`: !O`'<`(@.`L`"(`:0`B`"P`(@.!I`&8`
M(@.`L`"(`:0!N`"(`+ `B`&D`;@.!T`&\`(@.`L`"(`:0!S`"(`+ `B`&D`= `B
M`"P`(@.!I`'0`<P`B`"P`(@.!J`"(`+ `B`&H`=0!S`'0`(@.`L`"(`:P`B`"P`
M(@.!L`"(`+ `B`&P`:0!K`&4`(@.`L`"(`;0`B`"P`(@.!M`&$`:P!E`"(`+ `B
M`&T`80!N`'D`(@.`L`"(`;0!E`"(`+ `B`&T`:0!G`&@.`= `B`"P`(@.!M`&\`
M<@.!E`"(`+ `B`&T`;P!S`'0`(@.`L`"(`;0!U`&,`: `B`"P`(@.!M`'4`<P!T
M`"(`+ `B`&T`>0`B`"P`(@.!N`"(`+ `B`&X`90!V`&4`<@.`B`"P`(@.!N`&\`
M=P`B`"P`(@.!O`"(`+ `B`&\`9@.`B`"P`(@.!O`&X`(@.`L`"(`;P!N`&P`>0`B
M`"P`(@.!O`'(`(@.`L`"(`;P!T`&@.`90!R`"(`+ `B`&\`=0!R`"(`+ `B`&\`
M=0!T`"(`+ `B`&\`=@.!E`'(`(@.`L`"(`< `B`"P`(@.!Q`"(`+ `B`'(`(@.`L
M`"(`<@.!E`"(`+ `B`',`(@.`L`"(`<P!A`&D`9 `B`"P`(@.!S`&$`;0!E`"(`
M+ `B`',`90!E`"(`+ `B`',`: !O`'4`; !D`"(`+ `B`',`:0!N`&,`90`B
M`"P`(@.!S`&\`(@.`L`"(`<P!O`&T`90`B`"P`(@.!S`'0`:0!L` &P`(@.`L`"(`
M<P!U`&,`: `B`"P`(@.!T`"(`+ `B`'0`80!K`&4`(@.`L`"(`5 !E`',`= `B
M`"P`(@.!T`&@.`80!N`"(`+ `B`'0`: !A`'0`(@.`L`"(`= !H`&4`(@.`L`"(`
M= !H`&4`:0!R`"(`+ `B`'0`: !E`&T`(@.`L`"(`= !H`&4`;@.`B`"P`(@.!T
M`&@.`90!R`&4`(@.`L`"(`= !H`&4`<P!E`"(`+ `B`'0`: !E`'D`(@.`L`"(`
M= !H`&D`<P`B`"P`(@.!T`&@.`;P!S`&4`(@.`L`"(`= !H`'(`;P!U`&<`: `B
M`"P`(@.!T`&\`(@.`L`"(`= !O`&\`(@.`L`"(`=0`B`"P`(@.!U`&X`9 !E`'(`
M(@.`L`"(`=0!P`"(`+ `B`'4`<P!E`"(`+ `B`'8`(@.`L`"(`=@.!E`'(`>0`B
M`"P`(@.!W`"(`+ `B`'<`80!N`'0`(@.`L`"(`=P!A`',`(@.`L`"(`=P!A`'D`
M(@.`L`"(`=P!E`"(`+ `B`'<`90!L`&P`(@.`L`"(`=P!E`'(`90`B`"P`(@.!W
M`&@.`80!T`"(`+ `B`'<`: !E`&X`(@.`L`"(`=P!H`&4`<@.!E`"(`+ `B`'<`
M: !I`&,`: `B`"P`(@.!W`&@.`:0!L`&4`(@.`L`"(`=P!H`&\`(@.`L`"(`=P!I
M`&P`; `B`"P`(@.!W`&D`= !H`"(`+ `B`'<`;P!U`&P`9 `B`"P`(@.!X`"(`
M+ `B`'D`(@.`L`"(`>0!O`'4`(@.`L`"(`>0!O`'4`<@.`B`"P`(@.!Z `"(`*0`[
M``T`"@.!V`&$`<@.`@.`&$`<@.!R`&$`>0!?`' `<@.!U`&X`90!D`%\`; !E`&X`
M9P!T`&@.`/0`P`#L`#0`*`'8`80!R`" `8P!O`'4`;@.!T`&4`<@.`]`# `.P`-
M``H`=@.!A`'(`( !C`&\`=0!N`'0`90!R`#$`/0`P`#L`#0`*`'8`80!R`" `
M8P!O`'4`;@.!T`&4`<@.`R`#T`, `[``T`"@.!V`&$`<@.`@.`' `: !R`&$`<P!E
M`#$`.P`-``H`=@.!A`'(`( !L`&4`;@.!G`'0`: `]`# `.P`-``H`=@.!A`'(`
M( !N`&\`:0!S`&4`7P!A`'(`<@.!A`'D`7P!C`&\`=0!N`'0`90!R `#T`, `[
M``T`"@.!V`&$`<@.`@.`',`90!A`'(`8P!H`%\`< !H`'(`80!S`&4`/0`B`"(`
M.P`-``H`#0`*`"\`+P!S`' `; !I`'0`:0!N`&<`( !T`&@.`90`@.`',`90!A
M`'(`8P!H`" `< !H`'(`80!S`&4`( !I`&X`= !O`" `80!N`" `80!R`'(`
M80!Y``T`"@.!A`'(`<@.!A`'D`7P!P`'(`=0!N`&4`9 `]`' `: !R`&$`<P!E
M`"X`<P!P`&P`:0!T`"@.`(@.`@.`"(`*0`[``T`"@.!A`'(`<@.!A` 'D`7P!P`'(`
M=0!N`&4`9 !?`&P`90!N`&<`= !H`#T`80!R`'(`80!Y`%\`< !R`'4`;@.!E
M`&0`+@.!L`&4`;@.!G`'0`: `[``T`"@.`-``H`9@.!O`'(`( `H`&,`;P!U`&X`
M= !E`'(`/0`P`#L`8P!O`'4`;@.!T`&4`<@.`@.`#P`80!R`'(`80!Y`%\`< !R
M`'4`;@.!E`&0`7P!L`&4`;@.!G`'0`: `[`&,`;P!U`&X`= !E`'(`*P`K`"D`
M#0`*`'L`#0`*``D`8P!O`'4`;@.!T`&4`<@.`R`#T`, `[``T`"@.`)`&,`;P!U
M`&X`= !E`'(`,0`]`# `.P`-``H`#0`*``D`9@.!O`'(`( `H`&,`;P!U`&X`
M= !E`'(`,0`]`# `.P!C`&\`=0!N`'0`90!R`#$`/ !N`&\`:0!S`&4`80!R
M`'(`80!Y`"X`; !E`&X`9P!T`&@.`.P!C`&\`=0!N`'0`90!R`#$`*P`K`"D`
M#0`*``D`"0![``T`"@.`-``H`"0`)``D`:0!F`"@.`80!R`'(`80!Y`%\`< !R
M`'4`;@.!E`&0`6P!C`&\`=0!N`'0`90!R`%T`/0`]`&X`;P!I`',`90!A`'(`
M<@.!A`'D`6P!C`&\`=0!N`'0`90!R`#$`70`I``T`"@.`)``D`" 0`)`'L`#0`*
M``D`( `@.`" `"0`)``D`"0!S`&4`80!R`&,`: !?`' `: !R`&$`<P!E`#T`
M( `B`" `(@.`@.`"L`( !A`'(`<@.!A`'D`7P!P`'(`=0!N`&4`9 !;`&,`;P!U
M`&X`= !E`'(`70`@.`"L`( `B`" `(@.`[``T`"@.`@.`" `( `@.``D`"0`)``D`
M<P!E`&$`<@.!C`&@.`7P!P`&@.`<@.!A`',`90!?`&8`:0!R`',`= !?`' `;P!S
M`&D`= !I`&\`;@.`]`" `80!R`'(`80!Y`%\`< !R`'4`;@.!E`&0`6P!C`&\`
M=0!N`'0`90!R`%T`( `K`" `(@.`@.`"(`.P`-``H`"0`)``D`"0`)`&,`;P!U
M`&X`= !E`'(`,@.`@.`#T`( !P`&@.`<@.!A`',`90`N`&D`;@.!D`&4`> !/`&8`
M* !S`&4`80!R`&,`: !?`' `: !R`&$`<P!E`"P`, `I`#L`#0`*``D`"0`)
M``D`"0!C`&\`=0!N`'0`90!R`#,`( `]`" `< !H`'(`80!S`&4`+@.!I`&X`
M9 !E`'@.`3P!F`"@.`<P!E`&$`<@.!C`&@.`7P!P`&@.`<@.!A`',`90!? `&8`:0!R
M`',`= !?`' `;P!S`&D`= !I`&\`;@.`L`# `*0`[``T`"@.`)``D`"0`)``D`
M:0!F`"@.`8P!O`'4`;@.!T`&4`<@.`S`#P`8P!O`'4`;@.!T`&4`< @.`R`"D`#0`*
M``D`"0`)``D`"0`)`&,`;P!U`&X`= !E`'(`,@.`]`&,`;P!U`&X`= !E`'(`
M,P`[``T`"@.`)``D`"0`)``D`=P!H`&D`; !E`" `* !C`&\`=0!N`'0`90!R
M`#(`/@.`]`" `, `I``T`"@.`)``D`"0`)``D`"0![``T`"@.`)``D`"0`)``D`
M"0`)`'0`90!M`' `7P!S`'0`<@.!I`&X`9P`]`&$`<@.!R`&$`>0!?`' `<@.!U
M`&X`90!D`%L`8P!O`'4`;@.!T`&4`<@.!=`#L`#0`*``D`"0`)` `D`"0`)``D`
M; !E`&X`9P!T`&@.`/0!T`&4`;0!P`%\`<P!T`'(`:0!N`&<`+@.!L`&4`;@.!G
M`'0`: `[``T`"@.`)``D`"0`)``D`"0`)`' `: !R`&$`<P!E`" `/0`@.`' `
M: !R`&$`<P!E`"X`<P!U`&(`<P!T`'(`* `P`"P`8P!O`'4`;@.!T`&4`<@.`R
M`"D`( `K`" `< !H`'(`80!S`&4`+@.!S`'4`8@.!S`'0`<@.`H`&,`;P!U`&X`
M= !E`'(`,@.`K`&P`90!N`&<`= !H`"L`,0`I`#L`#0`*``D`"0`)``D`"0`)
M``D`8P!O`'4`;@.!T`&4`<@.`R`#T`< !H`'(`80!S`&4`+@.!I`&X`9 !E`'@.`
M3P!F`"@.`<P!E`&$`<@.!C`&@.`7P!P`&@.`<@.!A`',`90`L`# `*0`[``T`"@.`@.
M`" `"0`)``D`"0`)``D`?0`-``H`"0`)``D`"0!]``T`"@.`)``D`?0`-``H`
M?0`-``H`<@.!E`'0`=0!R`&X`( !P`&@.`<@.!A`',`90`[``T`"@.!]``T`"@.`O
M`"\`+0`M`#X`#0`*`#P`+P!3`$,`4@.!)`% `5 `^``T`"@.`\`"\`2 !%`$$`
M1 `^``T`"@.`\`$(`3P!$`%D`( !"`$<`0P!/`$P`3P!2`#T`(@.!,`$D`30!%
M`"(`/@.`-``H`/ !F`&\`<@.!M`" `;@.!A`&T`90`]`"(`<P!E`&$`<@.!C`&@.`
M1@.!O`'(`;0`B`" `80!C`'0`:0!O`&X`/0`B`',`90!A`'(`8P!H`"X`80!S
M`' `(@.`@.`&T`90!T`&@.`;P!D`#T`1P!%`%0`/@.`-``H`/ !B`#X`4P!E`&$`
M<@.!C`&@.`.@.`\`"\`8@.`^``T`"@.`\`$D`3@.!0`%4`5 `@.`%0`60!0`$4`/0`B
M`'0`90!X`'0`(@.`@.`$X`00!-`$4`/0`B`'0`80!R`&<`90!T`"(`( !3`$D`
M6@.!%`#T`(@.`T`#4`(@.`@.`$T`00!8`$P`10!.`$<`5 !(`#T`(@.`Q`# `, `B
M`" `5@.!!`$P`50!%`#T`(@.`B`#X`#0`*`#P`20!.`% `50!4`" `5 !9`% `
M10`]`"(`<P!U`&(`;0!I`'0`(@.`@.`$X`00!-`$4`/0`B`&<`;P!"`'4`= !T
M`&\`;@.`B`" `5@.!!`$P`50!%`#T`(@.`@.`%,`90!A`'(`8P!H`" `(@.`@.`&\`
M;@.!C`&P`:0!C`&L`( `]`" `(@.!R`&4`= !U`'(`;@.`@.`&,`: !E`&,`:P!F
M`&\`<@.!M`"@.`= !H`&D`<P`N`&8`;P!R`&T`*0`B`#X`#0`*`#P`:0!N`' `
M=0!T`" `= !Y`' `90`]`"(`: !I`&0`9 !E`&X`(@.`@.`&X`80!M`&4`/0`B
M`&X`80!V`$4`=@.!E`&X`= `B`" `=@.!A`&P`=0!E`#T`(@.!4`&\`< `B`#X`
M#0`*`#P`+P!F`&\`<@.!M`#X`#0`*`#P`8@.!R`#X`#0`*`#P`+ P!H`'0`;0!L
?`#X`#0`*``T`"@.`-``H`#0`*``T`"@.`-``H`#0`*````
`
end
|||SQL Server has a config file that specifies all the noise words it ignores
in full text searches. It is located here:
Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\Config\noise.eng
I'm not sure of the specifics on how you get SQL Server to recognize an
update to this file.
"Marius" <marius@.kanniets.nl> wrote in message
news:65032a84.0410190111.196b8638@.posting.google.c om...
> Hello,
> Is there a way to make it possible to search for the following
> searchstring with containstable?
> "test AND is"
> what i mean is that it will ignore the word "is" but will continu
> searching for "test"
> thnx in advance,
> Marius
|||But if I empty this file it will no longer ignore the noise words
(right?).
What I want is that the words will be ignored but the query will still
continue searching the database.
Here is the query I use to search:
--Begin
SELECT Total.TopicID,
f.AuthorizationItemID,
ft.TopicTitle,
ft.TopicStatus,
(SELECT MAX(PostDate) FROM ForumPost WHERE TopicID =
Total.TopicID) AS LastPost,
(SELECT COUNT(*) - 1 FROM ForumPost WHERE TopicID =
Total.TopicID) AS NumberOfReplies,
(SELECT UserFirstName + ' ' + UserLastName FROM Users WHERE
UserID = (SELECT UserID FROM ForumPost WHERE TopicID = Total.TopicID
AND PostDate = (SELECT MIN(PostDate) FROM ForumPost WHERE TopicID =
Total.TopicID))) AS Poster,
f.ForumAfk,
f.ForumName,
f.ForumID,
fc.CategoryName,
SUM(Total.Score) AS Score
FROM
(
SELECT fp.TopicID,
SUM(A.RANK) AS Score
FROM CONTAINSTABLE (ForumPost, PostMessage, @.strSearchString) A
JOIN ForumPost fp ON A.[Key] = fp.PostID
GROUP BY fp.TopicID
UNION ALL
SELECT B.[Key] AS TopicID,
B.RANK * 3 AS Score
FROM CONTAINSTABLE (ForumTopic, TopicTitle, @.strSearchString) B
) AS Total
JOIN ForumTopic ft ON Total.TopicID = ft.TopicID
JOIN ForumCategory fc ON ft.CategoryID = fc.CategoryID
JOIN Forum f ON fc.ForumID = f.ForumID
GROUP BY Total.TopicID, f.AuthorizationItemID, ft.TopicTitle,
ft.TopicStatus, ft.CategoryID, f.ForumAfk, f.ForumName, f.ForumID,
fc.CategoryName
ORDER BY Total.Score DESC
--End
The query it self works perfectly as far is I tested. But a
searchstring like 'test AND is' fails. Looking for a string like
'"test is"' does work but then it wil look for that exact string and
that's not the answer i'm looking for.
A option is ofcourse to remove the noise words from the string in my
code so they never end up in the store procedure. But I realy don't
like that solution so I hope there is an other way.
Marius
"Kevin Lewis" <lewis.kevin@.myfloridahouse.com> wrote in message news:<eoyE5eitEHA.4044@.TK2MSFTNGP09.phx.gbl>...[vbcol=seagreen]
> SQL Server has a config file that specifies all the noise words it ignores
> in full text searches. It is located here:
> Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\Config\noise.eng
> I'm not sure of the specifics on how you get SQL Server to recognize an
> update to this file.
> "Marius" <marius@.kanniets.nl> wrote in message
> news:65032a84.0410190111.196b8638@.posting.google.c om...
|||yes, they will no longer be searched on. Your best bet is to filter them out
at the client.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Marius" <marius@.kanniets.nl> wrote in message
news:65032a84.0410200111.64e78be9@.posting.google.c om...
> But if I empty this file it will no longer ignore the noise words
> (right?).
> What I want is that the words will be ignored but the query will still
> continue searching the database.
> Here is the query I use to search:
> --Begin
> SELECT Total.TopicID,
> f.AuthorizationItemID,
> ft.TopicTitle,
> ft.TopicStatus,
> (SELECT MAX(PostDate) FROM ForumPost WHERE TopicID =
> Total.TopicID) AS LastPost,
> (SELECT COUNT(*) - 1 FROM ForumPost WHERE TopicID =
> Total.TopicID) AS NumberOfReplies,
> (SELECT UserFirstName + ' ' + UserLastName FROM Users WHERE
> UserID = (SELECT UserID FROM ForumPost WHERE TopicID = Total.TopicID
> AND PostDate = (SELECT MIN(PostDate) FROM ForumPost WHERE TopicID =
> Total.TopicID))) AS Poster,
> f.ForumAfk,
> f.ForumName,
> f.ForumID,
> fc.CategoryName,
> SUM(Total.Score) AS Score
> FROM
> (
> SELECT fp.TopicID,
> SUM(A.RANK) AS Score
> FROM CONTAINSTABLE (ForumPost, PostMessage, @.strSearchString) A
> JOIN ForumPost fp ON A.[Key] = fp.PostID
> GROUP BY fp.TopicID
>
> UNION ALL
>
> SELECT B.[Key] AS TopicID,
> B.RANK * 3 AS Score
> FROM CONTAINSTABLE (ForumTopic, TopicTitle, @.strSearchString) B
> ) AS Total
> JOIN ForumTopic ft ON Total.TopicID = ft.TopicID
> JOIN ForumCategory fc ON ft.CategoryID = fc.CategoryID
> JOIN Forum f ON fc.ForumID = f.ForumID
> GROUP BY Total.TopicID, f.AuthorizationItemID, ft.TopicTitle,
> ft.TopicStatus, ft.CategoryID, f.ForumAfk, f.ForumName, f.ForumID,
> fc.CategoryName
> ORDER BY Total.Score DESC
> --End
> The query it self works perfectly as far is I tested. But a
> searchstring like 'test AND is' fails. Looking for a string like
> '"test is"' does work but then it wil look for that exact string and
> that's not the answer i'm looking for.
> A option is ofcourse to remove the noise words from the string in my
> code so they never end up in the store procedure. But I realy don't
> like that solution so I hope there is an other way.
> Marius
> "Kevin Lewis" <lewis.kevin@.myfloridahouse.com> wrote in message
news:<eoyE5eitEHA.4044@.TK2MSFTNGP09.phx.gbl>...[vbcol=seagreen]
ignores[vbcol=seagreen]
Server\MSSQL\FTDATA\SQLServer\Config\noise.eng[vbcol=seagreen]