|
Home > Archive > Commerce Server Catalog > August 2006 > Catalog Searching CS2002
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 |
Catalog Searching CS2002
|
|
| Johnny 2006-08-17, 1:23 am |
| CS2002 FP1 Com+
..
Having great difficulty with catalog searching. I understand that
freetext searches will not do implicit 'AND' for multi-word fulltext
searches. Therefore, I am trying to pass a 'CONTAINS' clause into the
call. Nothing is getting returned. It seems that it must be throwing
errors, but there is nothing in the app logs.
Here is my code.
s = "CONTAINS (*, '<search term>')"
Set rs = m_objManager.Search(s, , _
m_objCatalog.CatalogName, _
cscProductClass Or cscProductFamilyClass, _
"style_number", _
"style_number", _
False, _
1, 25, , t)
Even if I just have one word in the table, the thing blows up.
Is there anyway I can accomplish getting a query to do an implicit
'AND' other than putting together a huge clause using 'LIKE' operands?
I have tried everything I can think of based on the documentation.
Please don't tell me I have to wait until CS2007 because my customer
really does not want to hear it. Thank you.
| |
| Vinayak Tadas[MSFT] 2006-08-17, 7:16 pm |
| | |
| Johnny 2006-08-19, 7:25 am |
| Yes, that seems to work, but the code will not search the variants.(
hence my request to use a contains clause) The variants have a
description field that is included in the full-text search.
When I attempt to use the cscProductFamilyForVariantsClass flag, I get
duplicate productid's returned in the search query.
"Vinayak Tadas[MSFT]" wrote:
> You cannot pass a Contains clause in CS2002
> Have you tried something like
> "book and cd and music"
> In this case we use the Contains function to do the search
> See this post
> http://blogs.msdn.com/vinayakt/arch.../05/126329.aspx
>
>
> --------------------
> From: "Johnny" <johnnycougarflats@hotmail.com>
> Newsgroups: microsoft.public.commerceserver.catalog
> Subject: Catalog Searching CS2002
> Date: 16 Aug 2006 13:40:19 -0700
> Organization: http://groups.google.com
> Lines: 28
> Message-ID: <1155760819.435252.179710@h48g2000cwc.googlegroups.com>
> NNTP-Posting-Host: 68.15.44.109
> Mime-Version: 1.0
> Content-Type: text/plain; charset="iso-8859-1"
> X-Trace: posting.google.com 1155760824 552 127.0.0.1 (16 Aug 2006 20:40:24
> GMT)
> X-Complaints-To: groups-abuse@google.com
> NNTP-Posting-Date: Wed, 16 Aug 2006 20:40:24 +0000 (UTC)
> User-Agent: G2/0.2
> X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;
> .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
> Complaints-To: groups-abuse@google.com
> Injection-Info: h48g2000cwc.googlegroups.com; posting-host=68.15.44.109;
> posting-account=KQxj-g0AAAC_Ck8nKSIRn7BC8tuPcYzw
> Path:
> TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS02.phx.gbl!tornado.fa
> stwebnet.it!tiscali!newsfeed1.ip.tiscali.net!news.glorb.com!postnews.google.
> com!h48g2000cwc.googlegroups.com!not-for-mail
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.catalog:6251
> X-Tomcat-NG: microsoft.public.commerceserver.catalog
>
> CS2002 FP1 Com+
> ------=_NextPart_0001_2BBAF8F6--
| |
| Vinayak Tadas[MSFT] 2006-08-21, 7:20 pm |
| What is the value you have specified for the Classtypes parameter
--------------------
From: "Johnny" <johnnycougarflats@hotmail.com>
Newsgroups: microsoft.public.commerceserver.catalog
Subject: Re: Catalog Searching CS2002
Date: 18 Aug 2006 12:49:33 -0700
Organization: http://groups.google.com
Lines: 49
Message-ID: <1155930573.645672.215340@i42g2000cwa.googlegroups.com>
References: <1155760819.435252.179710@h48g2000cwc.googlegroups.com>
<k6uCRFiwGHA.3200@TK2MSFTNGXA01.phx.gbl>
NNTP-Posting-Host: 64.222.37.73
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1155930577 15157 127.0.0.1 (18 Aug 2006
19:49:37 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 18 Aug 2006 19:49:37 +0000 (UTC)
In-Reply-To: <k6uCRFiwGHA.3200@TK2MSFTNGXA01.phx.gbl>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;
NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: i42g2000cwa.googlegroups.com; posting-host=64.222.37.73;
posting-account=KQxj-g0AAAC_Ck8nKSIRn7BC8tuPcYzw
Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed00
sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!border1.nntp.dca.
giganews.com!nntp.giganews.com!postnews.google.com!i42g2000cwa.googlegroups.
com!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.catalog:6258
X-Tomcat-NG: microsoft.public.commerceserver.catalog
Yes, that seems to work, but the code will not search the variants.(
hence my request to use a contains clause) The variants have a
description field that is included in the full-text search.
When I attempt to use the cscProductFamilyForVariantsClass flag, I get
duplicate productid's returned in the search query.
"Vinayak Tadas[MSFT]" wrote:
> You cannot pass a Contains clause in CS2002
> Have you tried something like
> "book and cd and music"
> In this case we use the Contains function to do the search
> See this post
> http://blogs.msdn.com/vinayakt/arch.../05/126329.aspx
>
>
> --------------------
> From: "Johnny" <johnnycougarflats@hotmail.com>
> Newsgroups: microsoft.public.commerceserver.catalog
> Subject: Catalog Searching CS2002
> Date: 16 Aug 2006 13:40:19 -0700
> Organization: http://groups.google.com
> Lines: 28
> Message-ID: <1155760819.435252.179710@h48g2000cwc.googlegroups.com>
> NNTP-Posting-Host: 68.15.44.109
> Mime-Version: 1.0
> Content-Type: text/plain; charset="iso-8859-1"
> X-Trace: posting.google.com 1155760824 552 127.0.0.1 (16 Aug 2006 20:40:24
> GMT)
> X-Complaints-To: groups-abuse@google.com
> NNTP-Posting-Date: Wed, 16 Aug 2006 20:40:24 +0000 (UTC)
> User-Agent: G2/0.2
> X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;
> .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
> Complaints-To: groups-abuse@google.com
> Injection-Info: h48g2000cwc.googlegroups.com; posting-host=68.15.44.109;
> posting-account=KQxj-g0AAAC_Ck8nKSIRn7BC8tuPcYzw
> Path:
>
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS02.phx.gbl!tornado.fa
>
stwebnet.it!tiscali!newsfeed1.ip.tiscali.net!news.glorb.com!postnews.google.
> com!h48g2000cwc.googlegroups.com!not-for-mail
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.catalog:6251
> X-Tomcat-NG: microsoft.public.commerceserver.catalog
>
> CS2002 FP1 Com+
> ------=_NextPart_0001_2BBAF8F6--
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
| |
| Johnny 2006-08-21, 7:20 pm |
| cscProductClass Or cscProductFamilyClass
When I add the cscProductFamilyForVariantsClass flag, I get the dupes.
Set rs = m_objManager.Search(s, _
m_SearchPhrase, _
m_ObjCatalog.CatalogName, _
cscProductClass Or
cscProductFamilyClass, _
PROPERTIES_TO_RETURN, _
PROPERTIES_TO_SORT_ON, _
False, _
nStartingRecord, _
m_ProductListPageSize, "en-us",
_
t _
)
"Vinayak Tadas[MSFT]" wrote:
> What is the value you have specified for the Classtypes parameter
|
|
|
|
|