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 4 of 4

Thread: Advanced search

  1. 12-20-2009, 09:14 PM #1
    Richnyc30 is offline Senior Member
    Join Date
    Mar 2009
    Posts
    340

    Default Advanced search

    Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'dbo.product' because it is not full-text indexed.

    In Advancedsearch.aspx any search produces this error. It doesn't happen in theproduction site, just the test site, but I would like to know what is going on.

    Also, I seem to have trouble finding the "Department" pull down to remove it from the page.
  2. 12-21-2009, 12:21 AM #2
    Jao is offline Senior Member
    Join Date
    Oct 2008
    Posts
    1,132

    Default

    Could you tell us what version you're using? ML8012 already has a full-text catalog. See the {Database}>Storage>Full Text Catalogs using the SQL Server Management Studio...
  3. 12-21-2009, 06:59 AM #3
    Richnyc30 is offline Senior Member
    Join Date
    Mar 2009
    Posts
    340

    Default Full text search

    I may have looked at full text search, but maybe I half installed it? I'm using ver ML8012.
  4. 12-21-2009, 07:36 PM #4
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    Full-text search is an optional component of the SQL Server Database Engine, make sure you've included it when you installed your sql server. If you're using SQL 2005 express, you may refer to this installation instruction.

    This might be helpful as well - http://manual.aspdotnetstorefront.co...xt-search.aspx