Allow numbers in full text search

Hi, I need to search a product catalog for an online store, users must be
able to search for kitchens with "4" burners, but I get this error : "A
clause of the query contained only ignored words", below is the code for
stored procedure I'm using. Before I send the "@.SearchTerms" parameter, on
the client side (asp.net/vb.net) I parse the users input and concatenate
each word with an "AND", so if the user searches for "4 burner GE" y convert
this to "4 AND burner AND GE", I know the digit "4" is a noise word, and
I've seen post where people have just edit the noise word files, but I'm on
a shared hosting plan so I don't have access to them. Any ideas?
Regards,
Pablo Tola
pablo at imaget dot com
CREATE PROCEDURE SearchProducts (
@.SearchTerms varchar(500)
)
AS
SELECT
[p].[ProductId],
[p].[CategoryId],
[p].[BrandId],
[p].[Code],
[p].[ManufacturerCode],
[p].[Name],
[p].[Description],
[p].[Characteristics],
[p].[Keywords],
[p].[Image],
[p].[Price1],
[p].[Price2],
[p].[Price3],
[p].[IsDisplayedInCatalog],
[p].[IsInOutlet],
[p].[IsCalculatedForGift],
[p].[GiftRangeId],
[p].[StatusId],
KEY_TBL.RANK
FROM
CONTAINSTABLE ([dbo].[Products],*,@.SearchTerms) KEY_TBL
JOIN [dbo].[Products] p ON [KEY_TBL].[KEY] = [p].[ProductId]
Order By
KEY_TBL.RANK DESC
GO
have a look at this link for more info.
http://www.indexserverfaq.com/noise.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Pablo Tola" <pablo@.imaget.com> wrote in message
news:edn1kEBTFHA.3696@.TK2MSFTNGP15.phx.gbl...
> Hi, I need to search a product catalog for an online store, users must be
> able to search for kitchens with "4" burners, but I get this error : "A
> clause of the query contained only ignored words", below is the code for
> stored procedure I'm using. Before I send the "@.SearchTerms" parameter, on
> the client side (asp.net/vb.net) I parse the users input and concatenate
> each word with an "AND", so if the user searches for "4 burner GE" y
convert
> this to "4 AND burner AND GE", I know the digit "4" is a noise word, and
> I've seen post where people have just edit the noise word files, but I'm
on
> a shared hosting plan so I don't have access to them. Any ideas?
> Regards,
> Pablo Tola
> pablo at imaget dot com
> CREATE PROCEDURE SearchProducts (
> @.SearchTerms varchar(500)
> )
> AS
> SELECT
> [p].[ProductId],
> [p].[CategoryId],
> [p].[BrandId],
> [p].[Code],
> [p].[ManufacturerCode],
> [p].[Name],
> [p].[Description],
> [p].[Characteristics],
> [p].[Keywords],
> [p].[Image],
> [p].[Price1],
> [p].[Price2],
> [p].[Price3],
> [p].[IsDisplayedInCatalog],
> [p].[IsInOutlet],
> [p].[IsCalculatedForGift],
> [p].[GiftRangeId],
> [p].[StatusId],
> KEY_TBL.RANK
> FROM
> CONTAINSTABLE ([dbo].[Products],*,@.SearchTerms) KEY_TBL
> JOIN [dbo].[Products] p ON [KEY_TBL].[KEY] = [p].[ProductId]
> Order By
> KEY_TBL.RANK DESC
> GO
>