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]

Frequency Query

on a SQL 7.0 database is it possible to do a query to analyze frequency of the entries in the database?in other words I want to know which entries have the most instances.

Hi,

You can use the count method in combination with a group by clause.
For example: SELECT ProductName, COUNT(*) FROM Orders GROUP BY ProductName

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

thanks for your reply, the column name in the table is Tagname, would it be possible to count all entries for a specific time period? alarmlog is the table name, eventstamp is the time stamp of the entry.

like this:

select *, count(*)

from alarmlog

where eventstamp > '02/01/2007 00:00:00' and

eventstamp < '02/02/2007 00:00:00

thanks

Gary

|||

Yes but you should do it like this:

select TagName, count(*)
from alarmlog
where eventstamp > '02/01/2007 00:00:00' and eventstamp < '02/02/2007 00:00:00'
group by TagName

FYI: This is a good site with basic SQL syntax: http://www.w3schools.com/sql/default.asp

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

thanks again.

Gary

|||

Sorry one more quick question, for the results can I add another column to appear? there is a comment column for each entry that has the description in it that would be useful in the resluts.

Gary

|||

You can add as much columns as you want but the column must be included in the group by clause OR included in an aggregate function like (SUM, AVG, MIN, MAX, COUNT, ...)

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

FREETEXTTABLE

Hi..

I have used Full-Text Search in a stored procedure with English words whithout any problems..But when i use it with Arabic words it gives me THE Error:

Server: Msg 7619, Level 16, State 1, Procedure SearchProject, Line 19
Execution of a full-text operation failed. A clause of the query contained only ignored words.

The stored procedure :

CREATE PROCEDURE SearchProject
(
@.SearchString nvarchar(500),
@.CultureName nvarchar(50),
@.HowManyResults int OUTPUT
)
AS
CREATE TABLE #SearchTable
(
FieldNO int,
ProjectNO int,
ProjectName nvarchar(200),
ProjectDescription nvarchar(1000),
ProjectImage nvarchar(1000),
CultureID int
)

INSERT INTO #SearchTable (FieldNO,ProjectNO,ProjectName,ProjectDescription,ProjectImage,CultureID)
SELECT P.FieldNO, PL.ProjectNO,PL.ProjectName,PL.ProjectDescription,P.ProjectImage,PL.CultureID
FROM FREETEXTTABLE(Project_Locale,*,@.SearchString) AS FT JOIN Project_Locale AS PL ON FT.[KEY]=PL.ProjectCultureID
JOIN Project AS P ON P.ProjectNO=PL.ProjectNO
WHERE PL.CultureID=dbo.GetCultureID(@.CultureName)

INSERT INTO #SearchTable (FieldNO,ProjectNO,ProjectName,ProjectDescription,ProjectImage,CultureID)
SELECT P.FieldNO, PL.ProjectNO,PL.ProjectName,PL.ProjectDescription,P.ProjectImage,PL.CultureID
FROM Project_Locale AS PL ,Project AS P,
ProjectField_Locale AS FL,
FREETEXTTABLE(ProjectField_Locale,*,@.SearchString) AS FT2
WHERE FL.FieldNO=P.FieldNO
AND FL.FieldCultureID=FT2.[KEY]
AND PL.ProjectNO=P.ProjectNO
AND PL.CultureID=dbo.GetCultureID(@.CultureName)
AND FL.CultureID=dbo.GetCultureID(@.CultureName)

INSERT INTO #SearchTable (FieldNO,ProjectNO,ProjectName,ProjectDescription,ProjectImage,CultureID)
SELECT P.FieldNO, PL.ProjectNO,PL.ProjectName,PL.ProjectDescription,P.ProjectImage,PL.CultureID
FROM Project_Locale AS PL ,Project AS P,
Feature_Locale AS PFEA,
ProjectFeature AS FP,
Feature AS F,
FREETEXTTABLE(Feature_Locale,*,@.SearchString) AS FT3
WHERE FT3.[KEY]=PFEA.FeatureCultureID
AND FP.ProjectNO=P.ProjectNO
AND FP.FeatureNO=PFEA.FeatureNO
AND PL.ProjectNO=P.ProjectNO
AND F.FeatureNO=PFEA.FeatureNO
AND PFEA.CultureID=dbo.GetCultureID(@.CultureName)
AND PL.CultureID=dbo.GetCultureID(@.CultureName)

SELECT @.HowManyResults=COUNT(DISTINCT ProjectNO) FROM #SearchTable
SELECT DISTINCT * FROM #SearchTable
RETURN
GO

I called the stored procedure using the following(in the Query Analayzer) :

USE nabeel1eagle
DECLARE @.HowManyResults int
EXEC SearchProject '?????','ar-SA',@.HowManyResults OUTPUT

but when I use the previous code directly(without calling the stored procedure using EXEC) in the Query Analyzer it works fine.Like the following (part of the code)code:

SELECT P.FieldNO, PL.ProjectNO,PL.ProjectName,PL.ProjectDescription,P.ProjectImage,PL.CultureID
FROM FREETEXTTABLE(Project_Locale,*,'?????') AS FT JOIN Project_Locale AS PL ON FT.[KEY]=PL.ProjectCultureID
JOIN Project AS P ON P.ProjectNO=PL.ProjectNO
WHERE PL.CultureID=dbo.GetCultureID('ar-SA')

Could any one help and tell me how to solve this problem?

http://support.microsoft.com/?kbid=892924

HTH

|||

Thank you very much for your respond and important information..I have found a solution for my problem before i view your message..The solution was changing the sql collation and the windows collation.

The Search tool is working fine now in my website:www.engineeringprojects.net.

|||could you provide me the changed code using windows collation and sql collation. plz mail me to ananth.ramasamymeenachi@.cognizant.com|||

Sorry for being too late...

The code is the same but you can change the collation visually in the table designer..I dont remember what was the SqlCollation exactlly but the windows Collation was arabic.

FREETEXTTABLE

Hi..

I have used Full-Text Search in a stored procedure with English words whithout any problems..But when i use it with Arabic words it gives me THE Error:

Server: Msg 7619, Level 16, State 1, Procedure SearchProject, Line 19
Execution of a full-text operation failed. A clause of the query contained only ignored words.

The stored procedure :

CREATE PROCEDURE SearchProject
(
@.SearchString nvarchar(500),
@.CultureName nvarchar(50),
@.HowManyResults int OUTPUT
)
AS
CREATE TABLE #SearchTable
(
FieldNO int,
ProjectNO int,
ProjectName nvarchar(200),
ProjectDescription nvarchar(1000),
ProjectImage nvarchar(1000),
CultureID int
)

INSERT INTO #SearchTable (FieldNO,ProjectNO,ProjectName,ProjectDescription,ProjectImage,CultureID)
SELECT P.FieldNO, PL.ProjectNO,PL.ProjectName,PL.ProjectDescription,P.ProjectImage,PL.CultureID
FROM FREETEXTTABLE(Project_Locale,*,@.SearchString) AS FT JOIN Project_Locale AS PL ON FT.[KEY]=PL.ProjectCultureID
JOIN Project AS P ON P.ProjectNO=PL.ProjectNO
WHERE PL.CultureID=dbo.GetCultureID(@.CultureName)

INSERT INTO #SearchTable (FieldNO,ProjectNO,ProjectName,ProjectDescription,ProjectImage,CultureID)
SELECT P.FieldNO, PL.ProjectNO,PL.ProjectName,PL.ProjectDescription,P.ProjectImage,PL.CultureID
FROM Project_Locale AS PL ,Project AS P,
ProjectField_Locale AS FL,
FREETEXTTABLE(ProjectField_Locale,*,@.SearchString) AS FT2
WHERE FL.FieldNO=P.FieldNO
AND FL.FieldCultureID=FT2.[KEY]
AND PL.ProjectNO=P.ProjectNO
AND PL.CultureID=dbo.GetCultureID(@.CultureName)
AND FL.CultureID=dbo.GetCultureID(@.CultureName)

INSERT INTO #SearchTable (FieldNO,ProjectNO,ProjectName,ProjectDescription,ProjectImage,CultureID)
SELECT P.FieldNO, PL.ProjectNO,PL.ProjectName,PL.ProjectDescription,P.ProjectImage,PL.CultureID
FROM Project_Locale AS PL ,Project AS P,
Feature_Locale AS PFEA,
ProjectFeature AS FP,
Feature AS F,
FREETEXTTABLE(Feature_Locale,*,@.SearchString) AS FT3
WHERE FT3.[KEY]=PFEA.FeatureCultureID
AND FP.ProjectNO=P.ProjectNO
AND FP.FeatureNO=PFEA.FeatureNO
AND PL.ProjectNO=P.ProjectNO
AND F.FeatureNO=PFEA.FeatureNO
AND PFEA.CultureID=dbo.GetCultureID(@.CultureName)
AND PL.CultureID=dbo.GetCultureID(@.CultureName)

SELECT @.HowManyResults=COUNT(DISTINCT ProjectNO) FROM #SearchTable
SELECT DISTINCT * FROM #SearchTable
RETURN
GO

I called the stored procedure using the following(in the Query Analayzer) :

USE nabeel1eagle
DECLARE @.HowManyResults int
EXEC SearchProject '?????','ar-SA',@.HowManyResults OUTPUT

but when I use the previous code directly(without calling the stored procedure using EXEC) in the Query Analyzer it works fine.Like the following (part of the code)code:

SELECT P.FieldNO, PL.ProjectNO,PL.ProjectName,PL.ProjectDescription,P.ProjectImage,PL.CultureID
FROM FREETEXTTABLE(Project_Locale,*,'?????') AS FT JOIN Project_Locale AS PL ON FT.[KEY]=PL.ProjectCultureID
JOIN Project AS P ON P.ProjectNO=PL.ProjectNO
WHERE PL.CultureID=dbo.GetCultureID('ar-SA')

Could any one help and tell me how to solve this problem?

http://support.microsoft.com/?kbid=892924

HTH

|||

Thank you very much for your respond and important information..I have found a solution for my problem before i view your message..The solution was changing the sql collation and the windows collation.

The Search tool is working fine now in my website:www.engineeringprojects.net.

|||could you provide me the changed code using windows collation and sql collation. plz mail me to ananth.ramasamymeenachi@.cognizant.com|||

Sorry for being too late...

The code is the same but you can change the collation visually in the table designer..I dont remember what was the SqlCollation exactlly but the windows Collation was arabic.

FREETEXTTABLE

Hi..

I have used Full-Text Search in a stored procedure with English words whithout any problems..But when i use it with Arabic words it gives me THE Error:

Server: Msg 7619, Level 16, State 1, Procedure SearchProject, Line 19
Execution of a full-text operation failed. A clause of the query contained only ignored words.

The stored procedure :

CREATE PROCEDURE SearchProject
(
@.SearchString nvarchar(500),
@.CultureName nvarchar(50),
@.HowManyResults int OUTPUT
)
AS
CREATE TABLE #SearchTable
(
FieldNO int,
ProjectNO int,
ProjectName nvarchar(200),
ProjectDescription nvarchar(1000),
ProjectImage nvarchar(1000),
CultureID int
)

INSERT INTO #SearchTable (FieldNO,ProjectNO,ProjectName,ProjectDescription,ProjectImage,CultureID)
SELECT P.FieldNO, PL.ProjectNO,PL.ProjectName,PL.ProjectDescription,P.ProjectImage,PL.CultureID
FROM FREETEXTTABLE(Project_Locale,*,@.SearchString) AS FT JOIN Project_Locale AS PL ON FT.[KEY]=PL.ProjectCultureID
JOIN Project AS P ON P.ProjectNO=PL.ProjectNO
WHERE PL.CultureID=dbo.GetCultureID(@.CultureName)

INSERT INTO #SearchTable (FieldNO,ProjectNO,ProjectName,ProjectDescription,ProjectImage,CultureID)
SELECT P.FieldNO, PL.ProjectNO,PL.ProjectName,PL.ProjectDescription,P.ProjectImage,PL.CultureID
FROM Project_Locale AS PL ,Project AS P,
ProjectField_Locale AS FL,
FREETEXTTABLE(ProjectField_Locale,*,@.SearchString) AS FT2
WHERE FL.FieldNO=P.FieldNO
AND FL.FieldCultureID=FT2.[KEY]
AND PL.ProjectNO=P.ProjectNO
AND PL.CultureID=dbo.GetCultureID(@.CultureName)
AND FL.CultureID=dbo.GetCultureID(@.CultureName)

INSERT INTO #SearchTable (FieldNO,ProjectNO,ProjectName,ProjectDescription,ProjectImage,CultureID)
SELECT P.FieldNO, PL.ProjectNO,PL.ProjectName,PL.ProjectDescription,P.ProjectImage,PL.CultureID
FROM Project_Locale AS PL ,Project AS P,
Feature_Locale AS PFEA,
ProjectFeature AS FP,
Feature AS F,
FREETEXTTABLE(Feature_Locale,*,@.SearchString) AS FT3
WHERE FT3.[KEY]=PFEA.FeatureCultureID
AND FP.ProjectNO=P.ProjectNO
AND FP.FeatureNO=PFEA.FeatureNO
AND PL.ProjectNO=P.ProjectNO
AND F.FeatureNO=PFEA.FeatureNO
AND PFEA.CultureID=dbo.GetCultureID(@.CultureName)
AND PL.CultureID=dbo.GetCultureID(@.CultureName)

SELECT @.HowManyResults=COUNT(DISTINCT ProjectNO) FROM #SearchTable
SELECT DISTINCT * FROM #SearchTable
RETURN
GO

I called the stored procedure using the following(in the Query Analayzer) :

USE nabeel1eagle
DECLARE @.HowManyResults int
EXEC SearchProject '?????','ar-SA',@.HowManyResults OUTPUT

but when I use the previous code directly(without calling the stored procedure using EXEC) in the Query Analyzer it works fine.Like the following (part of the code)code:

SELECT P.FieldNO, PL.ProjectNO,PL.ProjectName,PL.ProjectDescription,P.ProjectImage,PL.CultureID
FROM FREETEXTTABLE(Project_Locale,*,'?????') AS FT JOIN Project_Locale AS PL ON FT.[KEY]=PL.ProjectCultureID
JOIN Project AS P ON P.ProjectNO=PL.ProjectNO
WHERE PL.CultureID=dbo.GetCultureID('ar-SA')

Could any one help and tell me how to solve this problem?

http://support.microsoft.com/?kbid=892924

HTH

|||

Thank you very much for your respond and important information..I have found a solution for my problem before i view your message..The solution was changing the sql collation and the windows collation.

The Search tool is working fine now in my website:www.engineeringprojects.net.

|||could you provide me the changed code using windows collation and sql collation. plz mail me to ananth.ramasamymeenachi@.cognizant.com|||

Sorry for being too late...

The code is the same but you can change the collation visually in the table designer..I dont remember what was the SqlCollation exactlly but the windows Collation was arabic.

FREETEXT results

Using the following query I get my desired results. However, in the
resulting recordset, how can I show for example 10 words before and 10 words
after the keyword or phrase that was searched upon? If I get 20 resulting
records I think it would be easier for the user to decide which they want to
view. I know Google does this. Is this an SQL issue or ASP issue?
thanks
DECLARE @.SearchString varchar(100)
SET @.SearchString = ' "stress" '
SELECT KEY_TBL.RANK, Title, Body
FROM Articles INNER JOIN
FREETEXTTABLE(Articles,*, @.SearchString) AS KEY_TBL
ON Articles.ID = KEY_TBL.[KEY]
ORDER BY Rank DESC
string handling is more efficiently done on the client level as opposed to
within SQL Server.
"shank" <shank@.tampabay.rr.com> wrote in message
news:Obj%23ddqZEHA.1508@.TK2MSFTNGP09.phx.gbl...
> Using the following query I get my desired results. However, in the
> resulting recordset, how can I show for example 10 words before and 10
words
> after the keyword or phrase that was searched upon? If I get 20 resulting
> records I think it would be easier for the user to decide which they want
to
> view. I know Google does this. Is this an SQL issue or ASP issue?
> thanks
> DECLARE @.SearchString varchar(100)
> SET @.SearchString = ' "stress" '
> SELECT KEY_TBL.RANK, Title, Body
> FROM Articles INNER JOIN
> FREETEXTTABLE(Articles,*, @.SearchString) AS KEY_TBL
> ON Articles.ID = KEY_TBL.[KEY]
> ORDER BY Rank DESC
>
|||Hilary,
While in some cases, client-side process might be better, for example
client-side paging and sorting of results, however, in this case, I must
respectively disagree...
Shank, you can use Substring and PatIndex along with your FREETEXTTABLE
query and get the "Goggle like" results that you have requested.
Specifically, the following SQL FTS query on the pubs table pub_info will
return rows that match the FTS search word (books) and display the near by
words from 20 characters before the searched keyword(books) for a total
length of 100 characters.
SELECT pub_id, SubString(pr_info,PatIndex ('%books%',pr_info)-20,100)
FROM pub_info
WHERE Contains(pr_info, 'books')
Regards,
John
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:#eM2eLrZEHA.644@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> string handling is more efficiently done on the client level as opposed to
> within SQL Server.
>
> "shank" <shank@.tampabay.rr.com> wrote in message
> news:Obj%23ddqZEHA.1508@.TK2MSFTNGP09.phx.gbl...
> words
resulting[vbcol=seagreen]
want
> to
>
|||I really don't think so. In fact I know so. You can easily demonstrate this
within vbscript.
In fact I have written and ISAPI extension that does this - and posted it
here. Thinking about doing it within a database is simply not a good choice.
"John Kane" <jt-kane@.comcast.net> wrote in message
news:%2364LxM9ZEHA.2792@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Hilary,
> While in some cases, client-side process might be better, for example
> client-side paging and sorting of results, however, in this case, I must
> respectively disagree...
> Shank, you can use Substring and PatIndex along with your FREETEXTTABLE
> query and get the "Goggle like" results that you have requested.
> Specifically, the following SQL FTS query on the pubs table pub_info will
> return rows that match the FTS search word (books) and display the near by
> words from 20 characters before the searched keyword(books) for a total
> length of 100 characters.
> SELECT pub_id, SubString(pr_info,PatIndex ('%books%',pr_info)-20,100)
> FROM pub_info
> WHERE Contains(pr_info, 'books')
> Regards,
> John
>
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:#eM2eLrZEHA.644@.tk2msftngp13.phx.gbl...
to
> resulting
> want
>
|||Hi Hilary,
Then I guess we can agree that we disagree <G>, as I did say in " some
cases" and not in all cases, so we can agree, on a case-by-case basis. Are
you saying that in all cases, that all types of "string handling" are "bad"
if handled on the server-side?
Regards,
John
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:ue$hecFaEHA.2844@.TK2MSFTNGP12.phx.gbl...
> I really don't think so. In fact I know so. You can easily demonstrate
this
> within vbscript.
> In fact I have written and ISAPI extension that does this - and posted it
> here. Thinking about doing it within a database is simply not a good
choice.[vbcol=seagreen]
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:%2364LxM9ZEHA.2792@.TK2MSFTNGP09.phx.gbl...
will[vbcol=seagreen]
by[vbcol=seagreen]
opposed[vbcol=seagreen]
> to
10
>

free text search

does anyone have code that shows how to separate individual words from a sentence.

e.g. i have a list of questions and answers in my database and have the following query for it:

SELECT question, Answer
FROM QuestionsAnswer
WHERE FREETEXT(Question, 'i want to travel around the world and learn about cooking')

so i want to extend the above query so that takes each key word (travel, cooking, learn) to find out how frequently that particular word appears in the question (for ranking purposes).

I know freetexttable does rank results, but they don't seem accurate enough for what i need to do.

HELP!!!i've just been told that freetext does this anyways...

=D|||have u tried search on the web|||You will need:

* A one column list (table) with all unimportant words. For that purpose I used a 20-year-old Commodore 64 text adventure interpreter list.

* A two column list (table) with the important words and the number of total occurences for each word.

You parse your text with space, comma, etc as word seperators and run each word against the first list. If it is not their you search it in the second list. If it is their you increment the occurence counter. If it is not their you add it with an occurence counter=1.

Check your second list from time to time in order to see if you can transfer a word from list 2 to list 1.

Easy, isn't it ?