|
Home > Archive > Commerce Server General > May 2005 > Can you do an IN() in CatalogSearch.SQLWhereClause (BCL)
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 |
Can you do an IN() in CatalogSearch.SQLWhereClause (BCL)
|
|
|
| I'm trying to select a specific list of products, is it
possible to set an IN() in the where clause? I want to
avoid reading directly from the tables.
Any ideas?
Thanks,
Drew
| |
| Vinayak Tadas[MSFT] 2004-06-28, 7:29 pm |
| Incase you still need answer to this question
You can pass "ProductId in ('P1','P2')" to the sqlClause parameter for
Search method.
--------------------
Content-Class: urn:content-classes:message
From: "Drew" <anonymous@discussions.microsoft.com>
Sender: "Drew" <anonymous@discussions.microsoft.com>
Subject: Can you do an IN() in CatalogSearch.SQLWhereClause (BCL)
Date: Wed, 28 Jan 2004 13:43:38 -0800
Lines: 8
Message-ID: <5c5301c3e5e7$c9c087b0$a101280a@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Thread-Index: AcPl58m+lIx58/9hQiGPumG6zdv4Jw==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.public.commerceserver.general
Path: cpmsftngxa07.phx.gbl
Xref: cpmsftngxa07.phx.gbl microsoft.public.commerceserver.general:13064
NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
X-Tomcat-NG: microsoft.public.commerceserver.general
I'm trying to select a specific list of products, is it
possible to set an IN() in the where clause? I want to
avoid reading directly from the tables.
Any ideas?
Thanks,
Drew
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. Thanks
| |
| Shanmuga 2005-05-12, 1:44 pm |
| Vinayak,
Can we pass "ProductID in (' " + dataset.Tables[0].Select() + " ')" to the sqlClause parameter for Search method?
What I am trying to do is pass a CategorySearch Result to next CategorySearch. The reason for this is would be that I need to search multiple categories.
Thanks well in advance,
Singaravel S
quote:
Originally posted by Vinayak Tadas[MSFT]
Incase you still need answer to this question
You can pass "ProductId in ('P1','P2')" to the sqlClause parameter for
Search method.
--------------------
Content-Class: urn:content-classes:message
From: "Drew" <anonymous@discussions.microsoft.com>
Sender: "Drew" <anonymous@discussions.microsoft.com>
Subject: Can you do an IN() in CatalogSearch.SQLWhereClause (BCL)
Date: Wed, 28 Jan 2004 13:43:38 -0800
Lines: 8
Message-ID: <5c5301c3e5e7$c9c087b0$a101280a@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Thread-Index: AcPl58m+lIx58/9hQiGPumG6zdv4Jw==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.public.commerceserver.general
Path: cpmsftngxa07.phx.gbl
Xref: cpmsftngxa07.phx.gbl microsoft.public.commerceserver.general:13064
NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
X-Tomcat-NG: microsoft.public.commerceserver.general
I'm trying to select a specific list of products, is it
possible to set an IN() in the where clause? I want to
avoid reading directly from the tables.
Any ideas?
Thanks,
Drew
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. Thanks
| |
| Vinayak Tadas[MSFT] 2005-05-26, 5:55 pm |
| This might not work.
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: Shanmuga <Shanmuga.1oxxl0@mail.webservertalk.com>
Subject: Re: Can you do an IN() in CatalogSearch.SQLWhereClause (BCL)
Date: Thu, 12 May 2005 13:44:37 -0500
Message-ID: <Shanmuga.1oxxl0@mail.webservertalk.com>
Organization: Web Servers forum
User-Agent: www.webservertalk.com news gateway
X-Newsreader: www.webservertalk.com news gateway
X-Originating-IP: 157.254.98.203
References: <5c5301c3e5e7$c9c087b0$a101280a@phx.gbl>
<#XL5#mWXEHA.308@cpmsftngxa10.phx.gbl>
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: mcse.ms 66.98.192.98
Lines: 1
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:2735
X-Tomcat-NG: microsoft.public.commerceserver.general
Vinayak,
Can we pass "ProductID in (' " + dataset.Tables[0].Select() + " ')" to
the sqlClause parameter for Search method?
What I am trying to do is pass a CategorySearch Result to next
CategorySearch. The reason for this is would be that I need to search
multiple categories.
Thanks well in advance,
Singaravel S
Vinayak Tadas[MSFT] wrote:
> *Incase you still need answer to this question
> You can pass "ProductId in ('P1','P2')" to the sqlClause parameter
> for
> Search method.
>
> --------------------
> Content-Class: urn:content-classes:message
> From: "Drew" <anonymous@discussions.microsoft.com>
> Sender: "Drew" <anonymous@discussions.microsoft.com>
> Subject: Can you do an IN() in CatalogSearch.SQLWhereClause (BCL)
> Date: Wed, 28 Jan 2004 13:43:38 -0800
> Lines: 8
> Message-ID: <5c5301c3e5e7$c9c087b0$a101280a@phx.gbl>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Thread-Index: AcPl58m+lIx58/9hQiGPumG6zdv4Jw==
> X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
> Newsgroups: microsoft.public.commerceserver.general
> Path: cpmsftngxa07.phx.gbl
> Xref: cpmsftngxa07.phx.gbl
> microsoft.public.commerceserver.general:13064
> NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> I'm trying to select a specific list of products, is it
> possible to set an IN() in the where clause? I want to
> avoid reading directly from the tables.
>
> Any ideas?
>
> Thanks,
> Drew
>
>
> 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. Thanks *
--
Shanmuga
------------------------------------------------------------------------
Posted via http://www.webservertalk.com
------------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message114032.html
|
|
|
|
|