Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 3 of 3

Thread: Remove from searching the product description when using Full Text Search

  1. #1
    BCru3 is offline Junior Member
    Join Date
    Apr 2010
    Posts
    18

    Default Remove from searching the product description when using Full Text Search

    Is it possible to stop the Full Text Search from searching the Product Description.

    Thanks, Typical Monday...

  2. #2
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    Sure. Modify the aspdnsf_GetProducts stored proc and remove (patindex(@searchstr, isnull(p.Description, '')) > 0).

    You'll have to take note though, once you'd changed that whether the FTS is turned on or not, you won't be able to search into the product description field. You might want to make a backup first so you can restore it later once needed.

  3. #3
    BCru3 is offline Junior Member
    Join Date
    Apr 2010
    Posts
    18

    Default Got it to work finally

    Thats actually not in the aspdnsf_GetProducts sproc, after it gets changed when installing FTS.
    It's only located in the aspdnsf_GetProducts_ORIGINAL.

    What I did do, was right click the Product table > Full-Text index > Properties.
    In the FTS properties I selected the Columns page on the left and then just made sure that
    the Name column was the only one selected, of course this is all that I want indexed and thats it.


    Almost a whole day, _BrianCruz - v9:no source

    Last edited by BCru3; 08-05-2010 at 08:28 AM.