|
Home > Archive > Commerce Server Catalog > October 2006 > Simultaneous Thesaurus and Inflectional search
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Simultaneous Thesaurus and Inflectional search
|
|
| simon.grimes@gmail.com 2006-10-16, 1:20 pm |
| Morning,
Does anyone have any advice on performing a simultaneous FT Thesaurus
and Inflectional search using CS2007 and SQL2005? I've read up on
this in the SQL BOL and CS2007 Docs on this as well as Vinayak's blog
and best I can come up with is using two FormsOf in the
AdvancedFreeTextSearch, ie: catalogSearch.AdvancedFreeTextSearchPhrase
= string.Format(" (FORMSOF(INFLECTIONAL, \"{0}\") OR FORMSOF(THESAURUS,
\"{0}\")) ", keyword);
Is there a better way of doing this?
Thanks,
Simon.
| |
| Vinayak Tadas[MSFT] 2006-10-28, 1:33 pm |
| Maybe you can post this question on the Sql Fulltext alias. If you can do
it using Sql youcan do it in Commerce Server using the
AdvancedFreeTextSearchPhrase
Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only
--------------------
From: simon.grimes@gmail.com
Newsgroups: microsoft.public.commerceserver.catalog
Subject: Simultaneous Thesaurus and Inflectional search
Date: 16 Oct 2006 03:06:43 -0700
Organization: http://groups.google.com
Lines: 16
Message-ID: <1160993203.455108.176940@i42g2000cwa.googlegroups.com>
NNTP-Posting-Host: 194.222.234.97
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1160993207 18478 127.0.0.1 (16 Oct 2006
10:06:47 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 16 Oct 2006 10:06:47 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;
InfoPath.1; .NET CLR 2.0.50727; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: i42g2000cwa.googlegroups.com; posting-host=194.222.234.97;
posting-account=2R91uw0AAAAL8ER8ZN-2lqCK770AeMYx
Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed.c
w.net!cw.net!news-FFM2.ecrc.de!newsfeed.gamma.ru!Gamma.RU!news2.volia.net!po
stnews.google.com!i42g2000cwa.googlegroups.com!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.catalog:6445
X-Tomcat-NG: microsoft.public.commerceserver.catalog
Morning,
Does anyone have any advice on performing a simultaneous FT Thesaurus
and Inflectional search using CS2007 and SQL2005? I've read up on
this in the SQL BOL and CS2007 Docs on this as well as Vinayak's blog
and best I can come up with is using two FormsOf in the
AdvancedFreeTextSearch, ie: catalogSearch.AdvancedFreeTextSearchPhrase
= string.Format(" (FORMSOF(INFLECTIONAL, \"{0}\") OR FORMSOF(THESAURUS,
\"{0}\")) ", keyword);
Is there a better way of doing this?
Thanks,
Simon.
|
|
|
|
|