Commerce Server General - To Display Products with respect to ProductDefinitions

Author

To Display Products with respect to ProductDefinitions

senthilkumar

2006-02-26, 10:46 am

Hi,

can we display products in aspx page according to ProductDefinition for
exaple

Catalog - BOOKSHOP
Categories - MEDICINE,COMPUTERS
Products - BOOK,E-BOOK,AUDIO BOOKS....

I want to display all E-books contained in productdefinition of type
E_BOOK.

Regards
Senthilkumar

Sudha Raghavan [MSFT]

2006-02-26, 10:46 am

You can do this using CatalogSearch. The SqlWhereClause on the
CatalogSearch would be something like "DefinitionName like '%E_BOOK%'". You
can set the search.CategoryName = "MEDICINE"

Thanks,
Sudha
--------------------
From: "senthilkumar" <senthilkumarj@gmail.com>
Newsgroups: microsoft.public.commerceserver.general
Subject: To Display Products with respect to ProductDefinitions
Date: 24 Feb 2006 05:12:29 -0800
Organization: http://groups.google.com
Lines: 16
Message-ID: <1140786749.607155.50850@t39g2000cwt.googlegroups.com>
NNTP-Posting-Host: 203.101.40.88
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1140786757 27244 127.0.0.1 (24 Feb 2006
13:12:37 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 24 Feb 2006 13:12:37 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET
CLR 1.1.4322),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 squid.accelicimtech.com:3128 (squid/2.5.STABLE6)
Complaints-To: groups-abuse@google.com
Injection-Info: t39g2000cwt.googlegroups.com; posting-host=203.101.40.88;
posting- account=0gKvzg0AAABjEgNFQ9y1CySyjBvRQUoX

Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali!ne
wsfeed1.ip.tiscali.net!news.maxwell.syr.edu!postnews.google.com!t39g2000cwt.
googlegroups.com!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:17589
X-Tomcat-NG: microsoft.public.commerceserver.general

Hi,

can we display products in aspx page according to ProductDefinition for
exaple

Catalog - BOOKSHOP
Categories - MEDICINE,COMPUTERS
Products - BOOK,E-BOOK,AUDIO BOOKS....

I want to display all E-books contained in productdefinition of type
E_BOOK.

Regards
Senthilkumar

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2006 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Have a Commerce Server “How To” question? Help is a click away at our
Chats, Newsgroups and Web logs

Chats (2nd Wednesday of the month from 11 to Noon):
http://www.msdn.microsoft.com/chats/
Public newsgroups:
http://www.microsoft.com/technet/co...r/commerce.mspx
Web logs and community:
http://www.microsoft.com/commercese...ty/default.mspx
Other resources:
http://www.microsoft.com/technet/pr...02/default.mspx

senthilkumar

2006-02-26, 10:46 am

Hi Sudha,

Using CatalogSearch i have to specify a keyword to search but i
want all the products of DefinitionName =3D E_BOOK.

I have got a idea to query the DataBase directly

select * from CatalogName_CatalogProducts
where DefinitionName =3D 'E_BOOK';

Using this i can create DataSet & display it in a DataGrid.

Is this Feasible to Query the Commerce server Database direclty or any
Disadvantage is there?

Regards
Senthilkumar

Sudha Raghavan [MSFT] wrote:
> You can do this using CatalogSearch. The SqlWhereClause on the
> CatalogSearch would be something like "DefinitionName like '%E_BOOK%'". Y=
ou
> can set the search.CategoryName =3D "MEDICINE"
>
> Thanks,
> Sudha
> --------------------
> From: "senthilkumar" <senthilkumarj@gmail.com>
> Newsgroups: microsoft.public.commerceserver.general
> Subject: To Display Products with respect to ProductDefinitions
> Date: 24 Feb 2006 05:12:29 -0800
> Organization: http://groups.google.com
> Lines: 16
> Message-ID: <1140786749.607155.50850@t39g2000cwt.googlegroups.com>
> NNTP-Posting-Host: 203.101.40.88
> Mime-Version: 1.0
> Content-Type: text/plain; charset=3D"iso-8859-1"
> X-Trace: posting.google.com 1140786757 27244 127.0.0.1 (24 Feb 2006
> 13:12:37 GMT)
> X-Complaints-To: groups-abuse@google.com
> NNTP-Posting-Date: Fri, 24 Feb 2006 13:12:37 +0000 (UTC)
> User-Agent: G2/0.2
> X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET
> CLR 1.1.4322),gzip(gfe),gzip(gfe)
> X-HTTP-Via: 1.0 squid.accelicimtech.com:3128 (squid/2.5.STABLE6)
> Complaints-To: groups-abuse@google.com
> Injection-Info: t39g2000cwt.googlegroups.com; posting-host=3D203.101.40.8=
8;
> posting- account=3D0gKvzg0AAABjEgNFQ9y1CySyjBvRQU
oX
> Path:
> TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali=
!ne
> wsfeed1.ip.tiscali.net!news.maxwell.syr.edu!postnews.google.com!t39g2000c=
wt.
> googlegroups.com!not-for-mail
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:17589
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> Hi,
>
> can we display products in aspx page according to ProductDefinition for
> exaple
>
> Catalog - BOOKSHOP
> Categories - MEDICINE,COMPUTERS
> Products - BOOK,E-BOOK,AUDIO BOOKS....
>
> I want to display all E-books contained in productdefinition of type
> E_BOOK.
>
>
> Regards
> Senthilkumar
>
>
>
> This posting is provided "AS IS" with no warranties, and confers no right=
s=2E
> You assume all risk for your use. =A9 2006 Microsoft Corporation. All rig=
hts
> reserved.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> Have a Commerce Server "How To" question? Help is a click away at our
> Chats, Newsgroups and Web logs
>
> Chats (2nd Wednesday of the month from 11 to Noon):
> http://www.msdn.microsoft.com/chats/
> Public newsgroups:
> http://www.microsoft.com/technet/co...r/commerce.mspx
> Web logs and community:
> http://www.microsoft.com/commercese...ty/default.mspx
> Other resources:
> http://www.microsoft.com/technet/pr...02/default.mspx
> ------=3D_NextPart_0001_07424BD0
> Content-Type: text/x-rtf
> X-Google-AttachSize: 2957
>
> & #123;\rtf1\ansi\ansicpg1252\deff0\deflan
g1033{\fonttbl{\f0\fnil\fprq2\fcharse=
t0 MS Sans Serif;}}
> \viewkind4\uc1\pard\f0\fs20 You can do this using CatalogSearch. The SqlW=
hereClause on the CatalogSearch would be something like "DefinitionName lik=
e '%E_BOOK%'". You can set the search.CategoryName \par
> \par Thanks,
> \par Sudha
> \par \pard\li720 --------------------
> \par From: "senthilkumar" <senthilkumarj@gmail.com>
> \par Newsgroups: microsoft.public.commerceserver.general
> \par Subject: To Display Products with respect to ProductDefinitions
> \par Date: 24 Feb 2006 05:12:29 -0800
> \par Organization: http://groups.google.com
> \par Lines: 16
> \par Message-ID: <1140786749.607155.50850@t39g2000cwt.googlegroups.com>
> \par NNTP-Posting-Host: 203.101.40.88
> \par Mime-Version: 1.0
> \par Content-Type: text/plain; charset=3D"iso-8859-1"
> \par X-Trace: posting.google.com 1140786757 27244 127.0.0.1 (24 Feb 2006 =
13:12:37 GMT)
> \par X-Complaints-To: groups-abuse@google.com
> \par NNTP-Posting-Date: Fri, 24 Feb 2006 13:12:37 +0000 (UTC)
> \par User-Agent: G2/0.2
> \par X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0;=
=2ENET CLR 1.1. 4322),gzip(gfe),gzip(gfe)
> \par X-HTTP-Via: 1.0 squid.accelicimtech.com:3128 (squid/2.5.STABLE6)
> \par Complaints-To: groups-abuse@google.com
> \par Injection-Info: t39g2000cwt.googlegroups.com; posting-host 3.101.40.=
88;
> \par posting- account=3D0gKvzg0AAABjEgNFQ9y1CySyjBvRQU
oX
> \par Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet=
..it!tiscali!newsfeed1.ip.tiscali.net!news.maxwell.syr.edu!postnews.google.c=
om!t39g2000cwt.googlegroups.com!not-for-mail
> \par Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:=
17589
> \par X-Tomcat-NG: microsoft.public.commerceserver.general
> \par
> \par Hi,
> \par
> \par can we display products in aspx page according to ProductDefinition =
for
> \par exaple
> \par
> \par Catalog - BOOKSHOP
> \par Categories - MEDICINE,COMPUTERS
> \par Products - BOOK,E-BOOK,AUDIO BOOKS....
> \par
> \par I want to display all E-books contained in productdefinition of type
> \par E_BOOK.
> \par
> \par
> \par Regards
> \par Senthilkumar
> \par
> \par \pard
> \par
> \par This posting is provided "AS IS" with no warranties, and confers no =
rights.
> \par You assume all risk for your use. 'a9 2006 Microsoft Corporation. A=
ll rights
> \par reserved.
> \par Use of included script samples are subject to the terms specified at
> \par http://www.microsoft.com/info/cpyright.htm
> \par
> \par Have a Commerce Server \ldblquote How To\rdblquote question? Help i=
s a click away at our Chats, Newsgroups and Web logs
> \par
> \par Chats (2nd Wednesday of the month from 11 to Noon): http://www.msdn=
..microsoft.com/chats/
> \par Public newsgroups: http://www.microsoft.com/technet/community/newsgr=
oups/server/commerce.mspx
> \par Web logs and community: http://www.microsoft.com/commerceserver/comm=
unity/default.mspx
> \par Other resources: http://www.microsoft.com/technet/prodtechnol/Comm/c=
omm2002/default.mspx
> \par }
> ------=3D_NextPart_0001_07424BD0--

Zoom

2006-02-27, 5:51 pm

Hi Senthil,

It's not recommonded to query commerce server db directly.

"senthilkumar" wrote:

> Hi Sudha,
>
> Using CatalogSearch i have to specify a keyword to search but i
> want all the products of DefinitionName = E_BOOK.
>
> I have got a idea to query the DataBase directly
>
> select * from CatalogName_CatalogProducts
> where DefinitionName = 'E_BOOK';
>
> Using this i can create DataSet & display it in a DataGrid.
>
> Is this Feasible to Query the Commerce server Database direclty or any
> Disadvantage is there?
>
> Regards
> Senthilkumar
>
>
> Sudha Raghavan [MSFT] wrote:
>
>

Sudha Raghavan [MSFT]

2006-02-27, 5:51 pm

Hi Senthil

It is not recommended to query the catlaog db directly.

You don't have to do a keyword search to get al products with
definitionName = E_BOOK

CatalogSearch cSearch;
cSearch.SqlWhereClause = "DefinitionName like '%E_BOOK%'";

The above lines of code should do the required.

Thanks
Sudha
--------------------
Thread-Topic: To Display Products with respect to ProductDefinitions
thread-index: AcY7saDBlM842XrSTy6OXJLBpfi7gA==
X-WBNR-Posting-Host: 203.101.43.211
From: "=?Utf-8?B?Wm9vbQ==?=" <Zoom@discussions.microsoft.com>
References: <1140786749.607155.50850@t39g2000cwt.googlegroups.com>
<isC$pbXOGHA.608@TK2MSFTNGXA01.phx.gbl>
<1140852886.580925.264140@u72g2000cwu.googlegroups.com>
Subject: Re: To Display Products with respect to ProductDefinitions
Date: Mon, 27 Feb 2006 07:22:31 -0800
Lines: 163
Message-ID: <59604721-6D2B-45DD-80A5-E8E0CD0B4114@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 8bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:17599
X-Tomcat-NG: microsoft.public.commerceserver.general

Hi Senthil,

It's not recommonded to query commerce server db directly.

"senthilkumar" wrote:

> Hi Sudha,
>
> Using CatalogSearch i have to specify a keyword to search but i
> want all the products of DefinitionName = E_BOOK.
>
> I have got a idea to query the DataBase directly
>
> select * from CatalogName_CatalogProducts
> where DefinitionName = 'E_BOOK';
>
> Using this i can create DataSet & display it in a DataGrid.
>
> Is this Feasible to Query the Commerce server Database direclty or any
> Disadvantage is there?
>
> Regards
> Senthilkumar
>
>
> Sudha Raghavan [MSFT] wrote:
You[vbcol=seagreen]
.NET[vbcol=seagreen]
posting-host=203.101.40.88;[vbcol=seagreen]
TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali!ne[vbcol=seagreen]
wsfeed1.ip.tiscali.net!news.maxwell.syr.edu!postnews.google.com!t39g2000cwt.[vbcol=seagreen]
microsoft.public.commerceserver.general:17589[vbcol=seagreen]
rights.[vbcol=seagreen]
rights[vbcol=seagreen]
http://www.microsoft.com/technet/co...r/commerce.mspx[vbcol=seagreen]
& #123;\rtf1\ansi\ansicpg1252\deff0\deflan
g1033{\fonttbl{\f0\fnil\fprq2\fcharset0
MS Sans Serif;}}[vbcol=seagreen]
SqlWhereClause on the CatalogSearch would be something like "DefinitionName
like '%E_BOOK%'". You can set the search.CategoryName \par[vbcol=seagreen]
2006 13:12:37 GMT)[vbcol=seagreen]
5.0; .NET CLR 1.1. 4322),gzip(gfe),gzip(gfe)[vbcol=seagreen
]
3.101.40.88;[vbcol=seagreen]
TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet..it!tiscali!n
ewsfeed1.ip.tiscali.net!news.maxwell.syr.edu!postnews.google.com!t39g2000cwt
.googlegroups.com!not-for-mail[vbcol=seagreen]
microsoft.public.commerceserver.general:17589[vbcol=seagreen]
ProductDefinition for[vbcol=seagreen]
type[vbcol=seagreen]
no rights.[vbcol=seagreen]
All rights[vbcol=seagreen]
at[vbcol=seagreen]
is a click away at our Chats, Newsgroups and Web logs[vbcol=seagreen]
http://www.msdn..microsoft.com/chats/[vbcol=seagreen]
http://www.microsoft.com/technet/co...r/commerce.mspx[vbcol=seagreen]
http://www.microsoft.com/commercese...ty/default.mspx[vbcol=seagreen]
http://www.microsoft.com/technet/pr...02/default.mspx[vbcol=seagreen]
>
>

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2005 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Have a Commerce Server “How To” question? Help is a click away at our
Chats, Newsgroups and Web logs

Chats (2nd Wednesday of the month from 11 to Noon):
http://www.msdn.microsoft.com/chats/
Public newsgroups:
http://www.microsoft.com/technet/co...r/commerce.mspx
Web logs and community:
http://www.microsoft.com/commercese...ty/default.mspx
Other resources:
http://www.microsoft.com/technet/pr...02/default.mspx

senthilkumar

2006-02-28, 7:49 am

Hi Sudha,

Thanks For the reply i got it done.i just removed the keyword property
from search & using only SqlWhereClause as
you said its working fine.

Why it is not feasible to use Direct catalog db Querying & what are the
disadvantages in commerce server 2002?

Regards
Senthilkumar.

Sudha Raghavan [MSFT] wrote:
> Hi Senthil
>
> It is not recommended to query the catlaog db directly.
>
> You don't have to do a keyword search to get al products with
> definitionName =3D E_BOOK
>
> CatalogSearch cSearch;
> cSearch.SqlWhereClause =3D "DefinitionName like '%E_BOOK%'";
>
> The above lines of code should do the required.
>
> Thanks
> Sudha
> --------------------
> Thread-Topic: To Display Products with respect to ProductDefinitions
> thread-index: AcY7saDBlM842XrSTy6OXJLBpfi7gA=3D=3D
> X-WBNR-Posting-Host: 203.101.43.211
> From: "=3D?Utf-8?B?Wm9vbQ=3D=3D?=3D" <Zoom@discussions.microsoft.com>
> References: <1140786749.607155.50850@t39g2000cwt.googlegroups.com>
> <isC$pbXOGHA.608@TK2MSFTNGXA01.phx.gbl>
> <1140852886.580925.264140@u72g2000cwu.googlegroups.com>
> Subject: Re: To Display Products with respect to ProductDefinitions
> Date: Mon, 27 Feb 2006 07:22:31 -0800
> Lines: 163
> Message-ID: <59604721-6D2B-45DD-80A5-E8E0CD0B4114@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset=3D"Utf-8"
> Content-Transfer-Encoding: 8bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> Newsgroups: microsoft.public.commerceserver.general
> NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:17599
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> Hi Senthil,
>
> It's not recommonded to query commerce server db directly.
>
>
> "senthilkumar" wrote:
>
"=2E[vbcol=seagreen]
> You
> .NET
> posting-host=3D203.101.40.88;
> TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali=
!ne
> wsfeed1.ip.tiscali.net!news.maxwell.syr.edu!postnews.google.com!t39g2000c=
wt.
> microsoft.public.commerceserver.general:17589
or[vbcol=seagreen]
> rights.
All[vbcol=seagreen]
> rights
> http://www.microsoft.com/technet/co...r/commerce.mspx
px[vbcol=seagreen]
> & #123;\rtf1\ansi\ansicpg1252\deff0\deflan
g1033{\fonttbl{\f0\fnil\fprq2\fcharse=
t0
> MS Sans Serif;}}
> SqlWhereClause on the CatalogSearch would be something like "DefinitionNa=
me
> like '%E_BOOK%'". You can set the search.CategoryName \par
m>[vbcol=seagreen]
> 2006 13:12:37 GMT)
> 5.0; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
> 3.101.40.88;
> TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet..it!tiscal=
i!n
> ewsfeed1.ip.tiscali.net!news.maxwell.syr.edu!postnews.google.com!t39g2000=
cwt
> .googlegroups.com!not-for-mail
> microsoft.public.commerceserver.general:17589
> ProductDefinition for
> type
> no rights.
n=2E[vbcol=seagreen]
> All rights
> at
lp[vbcol=seagreen]
> is a click away at our Chats, Newsgroups and Web logs
> http://www.msdn..microsoft.com/chats/
> http://www.microsoft.com/technet/co...r/commerce.mspx
> http://www.microsoft.com/commercese...ty/default.mspx
> http://www.microsoft.com/technet/pr...02/default.mspx
>
>
> This posting is provided "AS IS" with no warranties, and confers no right=
s=2E
> You assume all risk for your use. =A9 2005 Microsoft Corporation. All rig=
hts
> reserved.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> Have a Commerce Server "How To" question? Help is a click away at our
> Chats, Newsgroups and Web logs
>
> Chats (2nd Wednesday of the month from 11 to Noon):
> http://www.msdn.microsoft.com/chats/
> Public newsgroups:
> http://www.microsoft.com/technet/co...r/commerce.mspx
> Web logs and community:
> http://www.microsoft.com/commercese...ty/default.mspx
> Other resources:
> http://www.microsoft.com/technet/pr...02/default.mspx
> ------=3D_NextPart_0001_17285820
> Content-Type: text/x-rtf
> X-Google-AttachSize: 10182
>
> & #123;\rtf1\ansi\ansicpg1252\deff0\deflan
g1033{\fonttbl{\f0\fnil\fprq2\fcharse=
t0 MS Sans Serif;}}
> \viewkind4\uc1\pard\f0\fs20 Hi Senthil
> \par
> \par It is not recommended to query the catlaog db directly.
> \par
> \par You don't have to do a keyword search to get al products with defini=
tionName \par
> \par CatalogSearch cSearch;
> \par cSearch.SqlWhereClause \par
> \par The above lines of code should do the required.
> \par
> \par Thanks
> \par Sudha
> \par \pard\li720 --------------------
> \par Thread-Topic: To Display Products with respect to ProductDefinitions
> \par thread-index: AcY7saDBlM842XrSTy6OXJLBpfi7gA=3D
> \par X-WBNR-Posting-Host: 203.101.43.211
> \par From: "=3D?Utf-8?B?Wm9vbQ=3D?=3D" <Zoom@discussions.microsoft.com>
> \par References: <1140786749.607155.50850@t39g2000cwt.googlegroups.com> =
<isC$pbXOGHA.608@TK2MSFTNGXA01.phx.gbl> <1140852886.580925.264140@u72g2000c=
wu.googlegroups.com>
> \par Subject: Re: To Display Products with respect to ProductDefinitions
> \par Date: Mon, 27 Feb 2006 07:22:31 -0800
> \par Lines: 163
> \par Message-ID: <59604721-6D2B-45DD-80A5-E8E0CD0B4114@microsoft.com>
> \par MIME-Version: 1.0
> \par Content-Type: text/plain;
> \par \tab charset=3D"Utf-8"
> \par Content-Transfer-Encoding: 8bit
> \par X-Newsreader: Microsoft CDO for Windows 2000
> \par Content-Class: urn:content-classes:message
> \par Importance: normal
> \par Priority: normal
> \par X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> \par Newsgroups: microsoft.public.commerceserver.general
> \par NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> \par Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> \par Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:=
17599
> \par X-Tomcat-NG: microsoft.public.commerceserver.general
> \par
> \par Hi Senthil,
> \par
> \par It's not recommonded to query commerce server db directly.
> \par
> \par
> \par "senthilkumar" wrote:
> \par
> \par > Hi Sudha,
> \par >
> \par > Using CatalogSearch i have to specify a keyword to search but i
> \par > want all the products of DefinitionName \par >
> \par > I have got a idea to query the DataBase directly
> \par >
> \par > select * from CatalogName_CatalogProducts
> \par > where DefinitionName \par >
> \par > Using this i can create DataSet & display it in a DataGrid.
> \par >
> \par > Is this Feasible to Query the Commerce server Database direclty or=
any
> \par > Disadvantage is there?
> \par >
> \par > Regards
> \par > Senthilkumar
> \par >
> \par >
> \par > Sudha Raghavan [MSFT] wrote:
> \par > > You can do this using CatalogSearch. The SqlWhereClause on the
> \par > > CatalogSearch would be something like "DefinitionName like '%E_B=
OOK%'". You
> \par > > can set the search.CategoryName \par > >
> \par > > Thanks,
> \par > > Sudha
> \par > > --------------------
> \par > > From: "senthilkumar" <senthilkumarj@gmail.com>
> \par > > Newsgroups: microsoft.public.commerceserver.general
> \par > > Subject: To Display Products with respect to ProductDefinitions
> \par > > Date: 24 Feb 2006 05:12:29 -0800
> \par > > Organization: http://groups.google.com
> \par > > Lines: 16
> \par > > Message-ID: <1140786749.607155.50850@t39g2000cwt.googlegroups.co=
m>
> \par > > NNTP-Posting-Host: 203.101.40.88
> \par > > Mime-Version: 1.0
> \par > > Content-Type: text/plain; charset=3D"iso-8859-1"
> \par > > X-Trace: posting.google.com 1140786757 27244 127.0.0.1 (24 Feb 2=
006
> \par > > 13:12:37 GMT)
> \par > > X-Complaints-To: groups-abuse@google.com
> \par > > NNTP-Posting-Date: Fri, 24 Feb 2006 13:12:37 +0000 (UTC)
> \par > > User-Agent: G2/0.2
> \par > > X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT =
5=2E0; .NET
> \par > > CLR 1.1.4322),gzip(gfe),gzip(gfe)
> \par > > X-HTTP-Via: 1.0 squid.accelicimtech.com:3128 (squid/2.5.STABLE6)
> \par > > Complaints-To: groups-abuse@google.com
> \par > > Injection-Info: t39g2000cwt.googlegroups.com; posting-host 3.101=
..40.88;
> \par > > posting- account=3D0gKvzg0AAABjEgNFQ9y1CySyjBvRQU
oX
> \par > > Path:
> \par > > TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.i=
t!tiscali!ne
> \par > > wsfeed1.ip.tiscali.net!news.maxwell.syr.edu!postnews.google.com!=
t39g2000cwt.
> \par > > googlegroups.com!not-for-mail
> \par > > Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.gene=
ral:17589
> \par > > X-Tomcat-NG: microsoft.public.commerceserver.general
> \par > >
> \par > > Hi,
> \par > >
> \par > > can we display products in aspx page according to ProductDefinit=
ion for
> \par > > exaple
> \par > >
> \par > > Catalog - BOOKSHOP
> \par > > Categories - MEDICINE,COMPUTERS
> \par > > Products - BOOK,E-BOOK,AUDIO BOOKS....
> \par > >
> \par > > I want to display all E-books contained in productdefinition of =
type
> \par > > E_BOOK.
> \par > >
> \par > >
> \par > > Regards
> \par > > Senthilkumar
> \par > >
> \par > >
> \par > >
> \par > > This posting is provided "AS IS" with no warranties, and confers=
no rights.
> \par > > You assume all risk for your use. 'c2'a9 2006 Microsoft Corpor=
ation. All rights
> \par > > reserved.
> \par > > Use of included script samples are subject to the terms specifie=
d at
> \par > > http://www.microsoft.com/info/cpyright.htm
> \par > >
> \par > > Have a Commerce Server "How To" question? Help is a click away a=
t our
> \par > > Chats, Newsgroups and Web logs
> \par > >
> \par > > Chats (2nd Wednesday of the month from 11 to Noon):
> \par > > http://www.msdn.microsoft.com/chats/
> \par > > Public newsgroups:
> \par > > http://www.microsoft.com/technet/co...ups/server/com=
merce.mspx
> \par > > Web logs and community:
> \par > > http://www.microsoft.com/commercese...ty/default.mspx
> \par > > Other resources:
> \par > > http://www.microsoft.com/technet/pr...comm2002/defau=
lt.mspx
> \par > > ------=3D_NextPart_0001_07424BD0
> \par > > Content-Type: text/x-rtf
> \par > > X-Google-AttachSize: 2957
> \par > >
> \par > > \& #123;\\rtf1\\ansi\\ansicpg1252\\deff0\\d
eflang1033\{\\fonttbl\{\\f0=
\\fnil\\fprq2\\fcharset0 MS Sans Serif;\}\}
> \par > > \\viewkind4\\uc1\\pard\\f0\\fs20 You can do this using CatalogSe=
arch. The SqlWhereClause on the CatalogSearch would be something like "Defi=
nitionName like '%E_BOOK%'". You can set the search.CategoryName \\par
> \par > > \\par Thanks,
> \par > > \\par Sudha
> \par > > \\par \\pard\\li720 --------------------
> \par > > \\par From: "senthilkumar" <senthilkumarj@gmail.com>
> \par > > \\par Newsgroups: microsoft.public.commerceserver.general
> \par > > \\par Subject: To Display Products with respect to ProductDefini=
tions
> \par > > \\par Date: 24 Feb 2006 05:12:29 -0800
> \par > > \\par Organization: http://groups.google.com
> \par > > \\par Lines: 16
> \par > > \\par Message-ID: <1140786749.607155.50850@t39g2000cwt.googlegro=
ups.com>
> \par > > \\par NNTP-Posting-Host: 203.101.40.88
> \par > > \\par Mime-Version: 1.0
> \par > > \\par Content-Type: text/plain; charset=3D"iso-8859-1"
> \par > > \\par X-Trace: posting.google.com 1140786757 27244 127.0.0.1 (24=
Feb 2006 13:12:37 GMT)
> \par > > \\par X-Complaints-To: groups-abuse@google.com
> \par > > \\par NNTP-Posting-Date: Fri, 24 Feb 2006 13:12:37 +0000 (UTC)
> \par > > \\par User-Agent: G2/0.2
> \par > > \\par X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windo=
ws NT 5.0; .NET CLR 1.1. 4322),gzip(gfe),gzip(gfe)
> \par > > \\par X-HTTP-Via: 1.0 squid.accelicimtech.com:3128 (squid/2.5.ST=
ABLE6)
> \par > > \\par Complaints-To: groups-abuse@google.com
> \par > > \\par Injection-Info: t39g2000cwt.googlegroups.com; posting-host=
3.101.40.88;
> \par > > \\par posting- account=3D0gKvzg0AAABjEgNFQ9y1CySyjBvRQU
oX
> \par > > \\par Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.=
fastwebnet..it!tiscali!newsfeed1.ip.tiscali.net!news.maxwell.syr.edu!postne=
ws.google.com!t39g2000cwt.googlegroups.com!not-for-mail
> \par > > \\par Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserve=
r=2Egeneral:17589
> \par > > \\par X-Tomcat-NG: microsoft.public.commerceserver.general
> \par > > \\par
> \par > > \\par Hi,
> \par > > \\par
> \par > > \\par can we display products in aspx page according to ProductD=
efinition for
> \par > > \\par exaple
> \par > > \\par
> \par > > \\par Catalog - BOOKSHOP
> \par > > \\par Categories - MEDICINE,COMPUTERS
> \par > > \\par Products - BOOK,E-BOOK,AUDIO BOOKS....
> \par > > \\par
> \par > > \\par I want to display all E-books contained in productdefiniti=
on of type
> \par > > \\par E_BOOK.
> \par > > \\par
> \par > > \\par
> \par > > \\par Regards
> \par > > \\par Senthilkumar
> \par > > \\par
> \par > > \\par \\pard
> \par > > \\par
> \par > > \\par This posting is provided "AS IS" with no warranties, and c=
onfers no rights.
> \par > > \\par You assume all risk for your use. \'a9 2006 Microsoft Cor=
poration. All rights
> \par > > \\par reserved.
> \par > > \\par Use of included script samples are subject to the terms sp=
ecified at
> \par > > \\par http://www.microsoft.com/info/cpyright.htm
> \par > > \\par
> \par > > \\par Have a Commerce Server \\ldblquote How To\\rdblquote ques=
tion? Help is a click away at our Chats, Newsgroups and Web logs
> \par > > \\par
> \par > > \\par Chats (2nd Wednesday of the month from 11 to Noon): http:=
//www.msdn..microsoft.com/chats/
> \par > > \\par Public newsgroups: http://www.microsoft.com/technet/commun=
ity/newsgroups/server/commerce.mspx
> \par > > \\par Web logs and community: http://www.microsoft.com/commerces=
erver/community/default.mspx
> \par > > \\par Other resources: http://www.microsoft.com/technet/prodtech=
nol/Comm/comm2002/default.mspx
> \par > > \\par \}
> \par > > ------=3D_NextPart_0001_07424BD0--
> \par >
> \par >
> \par \pard
> \par
> \par This posting is provided "AS IS" with no warranties, and confers no =
rights.
> \par You assume all risk for your use. 'a9 2005 Microsoft Corporation. A=
ll rights
> \par reserved.
> \par Use of included script samples are subject to the terms specified at
> \par http://www.microsoft.com/info/cpyright.htm
> \par
> \par Have a Commerce Server \ldblquote How To\rdblquote question? Help i=
s a click away at our Chats, Newsgroups and Web logs
> \par
> \par Chats (2nd Wednesday of the month from 11 to Noon): http://www.msdn=
..microsoft.com/chats/
> \par Public newsgroups: http://www.microsoft.com/technet/community/newsgr=
oups/server/commerce.mspx
> \par Web logs and community: http://www.microsoft.com/commerceserver/comm=
unity/default.mspx
> \par Other resources: http://www.microsoft.com/technet/prodtechnol/Comm/c=
omm2002/default.mspx
> \par }
> ------=3D_NextPart_0001_17285820--

Sudha Raghavan [MSFT]

2006-03-21, 3:10 am

It is not recommended to do queries against Commerce DB directly because
the schema may change in future releases and then these queries may not
work any more.

Thanks
Sudha
--------------------
From: "senthilkumar" <senthilkumarj@gmail.com>
Newsgroups: microsoft.public.commerceserver.general
Subject: Re: To Display Products with respect to ProductDefinitions
Date: 27 Feb 2006 23:35:39 -0800
Organization: http://groups.google.com
Lines: 551
Message-ID: <1141112139.643535.178010@u72g2000cwu.googlegroups.com>
References: <1140786749.607155.50850@t39g2000cwt.googlegroups.com>
<isC$pbXOGHA.608@TK2MSFTNGXA01.phx.gbl>
<1140852886.580925.264140@u72g2000cwu.googlegroups.com>
<59604721-6D2B-45DD-80A5-E8E0CD0B4114@microsoft.com>
<bmbU0P#OGHA.768@TK2MSFTNGXA01.phx.gbl>
NNTP-Posting-Host: 203.101.40.88
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1141112146 4061 127.0.0.1 (28 Feb 2006 07:35:46
GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 28 Feb 2006 07:35:46 +0000 (UTC)
In-Reply-To: <bmbU0P#OGHA.768@TK2MSFTNGXA01.phx.gbl>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET
CLR 1.1.4322),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 squid.accelicimtech.com:3128 (squid/2.5.STABLE6)
Complaints-To: groups-abuse@google.com
Injection-Info: u72g2000cwu.googlegroups.com; posting-host=203.101.40.88;
posting- account=0gKvzg0AAABjEgNFQ9y1CySyjBvRQUoX

Path:
TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!nntp.giganews.com!transit3.readnews.com!
news-out.readnews.com!news-out.readnews.com!news-xxxfer.readnews.com!postnew
s.google.com!u72g2000cwu.googlegroups.com!not-for-mail
Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.commerceserver.general:17596
X-Tomcat-NG: microsoft.public.commerceserver.general

Hi Sudha,
Thanks For the reply i got it done.i just removed the keyword property
from search & using only SqlWhereClause as
you said its working fine.
Why it is not feasible to use Direct catalog db Querying & what are the
disadvantages in commerce server 2002?
Regards
Senthilkumar.
Sudha Raghavan [MSFT] wrote:
> Hi Senthil
>
> It is not recommended to query the catlaog db directly.
>
> You don't have to do a keyword search to get al products with
> definitionName = E_BOOK
>
> CatalogSearch cSearch;
> cSearch.SqlWhereClause = "DefinitionName like '%E_BOOK%'";
>
> The above lines of code should do the required.
>
> Thanks
> Sudha
> --------------------
> Thread-Topic: To Display Products with respect to ProductDefinitions
> thread-index: AcY7saDBlM842XrSTy6OXJLBpfi7gA==
> X-WBNR-Posting-Host: 203.101.43.211
> From: "=?Utf-8?B?Wm9vbQ==?=" <Zoom@discussions.microsoft.com>
> References: <1140786749.607155.50850@t39g2000cwt.googlegroups.com>
> <isC$pbXOGHA.608@TK2MSFTNGXA01.phx.gbl>
> <1140852886.580925.264140@u72g2000cwu.googlegroups.com>
> Subject: Re: To Display Products with respect to ProductDefinitions
> Date: Mon, 27 Feb 2006 07:22:31 -0800
> Lines: 163
> Message-ID: <59604721-6D2B-45DD-80A5-E8E0CD0B4114@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 8bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> Newsgroups: microsoft.public.commerceserver.general
> NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:17599
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> Hi Senthil,
>
> It's not recommonded to query commerce server db directly.
>
>
> "senthilkumar" wrote:
>
'%E_BOOK%'".[vbcol=seagreen]
> You
> .NET
> posting-host=203.101.40.88;
>
TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali!ne
>
wsfeed1.ip.tiscali.net!news.maxwell.syr.edu!postnews.google.com!t39g2000cwt.
> microsoft.public.commerceserver.general:17589
for[vbcol=seagreen]
> rights.
> rights
> http://www.microsoft.com/technet/co...r/commerce.mspx
http://www.microsoft.com/technet/pr...02/default.mspx[vbcol=seagreen]
>
& #123;\rtf1\ansi\ansicpg1252\deff0\deflan
g1033{\fonttbl& #123;\f0\fnil\fprq2\fcharset0
> MS Sans Serif;}}
> SqlWhereClause on the CatalogSearch would be something like
"DefinitionName
> like '%E_BOOK%'". You can set the search.CategoryName \par
<1140786749.607155.50850@t39g2000cwt.googlegroups.com>[vbcol=seagreen]
> 2006 13:12:37 GMT)
> 5.0; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
> 3.101.40.88;
>
TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet..it!tiscali!n
>
ewsfeed1.ip.tiscali.net!news.maxwell.syr.edu!postnews.google.com!t39g2000cwt
> .googlegroups.com!not-for-mail
> microsoft.public.commerceserver.general:17589
> ProductDefinition for
> type
> no rights.
Corporation.[vbcol=seagreen]
> All rights
> at
Help[vbcol=seagreen]
> is a click away at our Chats, Newsgroups and Web logs
> http://www.msdn..microsoft.com/chats/
> http://www.microsoft.com/technet/co...r/commerce.mspx
> http://www.microsoft.com/commercese...ty/default.mspx
> http://www.microsoft.com/technet/pr...02/default.mspx
>
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> You assume all risk for your use. © 2005 Microsoft Corporation. All rights
> reserved.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> Have a Commerce Server "How To" question? Help is a click away at our
> Chats, Newsgroups and Web logs
>
> Chats (2nd Wednesday of the month from 11 to Noon):
> http://www.msdn.microsoft.com/chats/
> Public newsgroups:
> http://www.microsoft.com/technet/co...r/commerce.mspx
> Web logs and community:
> http://www.microsoft.com/commercese...ty/default.mspx
> Other resources:
> http://www.microsoft.com/technet/pr...02/default.mspx
> ------=_NextPart_0001_17285820
> Content-Type: text/x-rtf
> X-Google-AttachSize: 10182
>
>
& #123;\rtf1\ansi\ansicpg1252\deff0\deflan
g1033{\fonttbl{\f0\fnil\fprq2\fcharset0
MS Sans Serif;}}
> \viewkind4\uc1\pard\f0\fs20 Hi Senthil
> \par
> \par It is not recommended to query the catlaog db directly.
> \par
> \par You don't have to do a keyword search to get al products with
definitionName \par
> \par CatalogSearch cSearch;
> \par cSearch.SqlWhereClause \par
> \par The above lines of code should do the required.
> \par
> \par Thanks
> \par Sudha
> \par \pard\li720 --------------------
> \par Thread-Topic: To Display Products with respect to ProductDefinitions
> \par thread-index: AcY7saDBlM842XrSTy6OXJLBpfi7gA=
> \par X-WBNR-Posting-Host: 203.101.43.211
> \par From: "=?Utf-8?B?Wm9vbQ=?=" <Zoom@discussions.microsoft.com>
> \par References: <1140786749.607155.50850@t39g2000cwt.googlegroups.com>
<isC$pbXOGHA.608@TK2MSFTNGXA01.phx.gbl>
<1140852886.580925.264140@u72g2000cwu.googlegroups.com>
> \par Subject: Re: To Display Products with respect to ProductDefinitions
> \par Date: Mon, 27 Feb 2006 07:22:31 -0800
> \par Lines: 163
> \par Message-ID: <59604721-6D2B-45DD-80A5-E8E0CD0B4114@microsoft.com>
> \par MIME-Version: 1.0
> \par Content-Type: text/plain;
> \par \tab charset="Utf-8"
> \par Content-Transfer-Encoding: 8bit
> \par X-Newsreader: Microsoft CDO for Windows 2000
> \par Content-Class: urn:content-classes:message
> \par Importance: normal
> \par Priority: normal
> \par X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> \par Newsgroups: microsoft.public.commerceserver.general
> \par NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> \par Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> \par Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.commerceserver.general:17599
> \par X-Tomcat-NG: microsoft.public.commerceserver.general
> \par
> \par Hi Senthil,
> \par
> \par It's not recommonded to query commerce server db directly.
> \par
> \par
> \par "senthilkumar" wrote:
> \par
> \par > Hi Sudha,
> \par >
> \par > Using CatalogSearch i have to specify a keyword to search but i
> \par > want all the products of DefinitionName \par >
> \par > I have got a idea to query the DataBase directly
> \par >
> \par > select * from CatalogName_CatalogProducts
> \par > where DefinitionName \par >
> \par > Using this i can create DataSet & display it in a DataGrid.
> \par >
> \par > Is this Feasible to Query the Commerce server Database direclty or
any
> \par > Disadvantage is there?
> \par >
> \par > Regards
> \par > Senthilkumar
> \par >
> \par >
> \par > Sudha Raghavan [MSFT] wrote:
> \par > > You can do this using CatalogSearch. The SqlWhereClause on the
> \par > > CatalogSearch would be something like "DefinitionName like
'%E_BOOK%'". You
> \par > > can set the search.CategoryName \par > >
> \par > > Thanks,
> \par > > Sudha
> \par > > --------------------
> \par > > From: "senthilkumar" <senthilkumarj@gmail.com>
> \par > > Newsgroups: microsoft.public.commerceserver.general
> \par > > Subject: To Display Products with respect to ProductDefinitions
> \par > > Date: 24 Feb 2006 05:12:29 -0800
> \par > > Organization: http://groups.google.com
> \par > > Lines: 16
> \par > > Message-ID:
<1140786749.607155.50850@t39g2000cwt.googlegroups.com>
> \par > > NNTP-Posting-Host: 203.101.40.88
> \par > > Mime-Version: 1.0
> \par > > Content-Type: text/plain; charset="iso-8859-1"
> \par > > X-Trace: posting.google.com 1140786757 27244 127.0.0.1 (24 Feb
2006
> \par > > 13:12:37 GMT)
> \par > > X-Complaints-To: groups-abuse@google.com
> \par > > NNTP-Posting-Date: Fri, 24 Feb 2006 13:12:37 +0000 (UTC)
> \par > > User-Agent: G2/0.2
> \par > > X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
5.0; .NET
> \par > > CLR 1.1.4322),gzip(gfe),gzip(gfe)
> \par > > X-HTTP-Via: 1.0 squid.accelicimtech.com:3128 (squid/2.5.STABLE6)
> \par > > Complaints-To: groups-abuse@google.com
> \par > > Injection-Info: t39g2000cwt.googlegroups.com; posting-host
3.101.40.88;
> \par > > posting- account=0gKvzg0AAABjEgNFQ9y1CySyjBvRQUoX

> \par > > Path:
> \par > >
TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali!ne
> \par > >
wsfeed1.ip.tiscali.net!news.maxwell.syr.edu!postnews.google.com!t39g2000cwt.
> \par > > googlegroups.com!not-for-mail
> \par > > Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.commerceserver.general:17589
> \par > > X-Tomcat-NG: microsoft.public.commerceserver.general
> \par > >
> \par > > Hi,
> \par > >
> \par > > can we display products in aspx page according to
ProductDefinition for
> \par > > exaple
> \par > >
> \par > > Catalog - BOOKSHOP
> \par > > Categories - MEDICINE,COMPUTERS
> \par > > Products - BOOK,E-BOOK,AUDIO BOOKS....
> \par > >
> \par > > I want to display all E-books contained in productdefinition of
type
> \par > > E_BOOK.
> \par > >
> \par > >
> \par > > Regards
> \par > > Senthilkumar
> \par > >
> \par > >
> \par > >
> \par > > This posting is provided "AS IS" with no warranties, and confers
no rights.
> \par > > You assume all risk for your use. 'c2'a9 2006 Microsoft
Corporation. All rights
> \par > > reserved.
> \par > > Use of included script samples are subject to the terms
specified at
> \par > > http://www.microsoft.com/info/cpyright.htm
> \par > >
> \par > > Have a Commerce Server "How To" question? Help is a click away
at our
> \par > > Chats, Newsgroups and Web logs
> \par > >
> \par > > Chats (2nd Wednesday of the month from 11 to Noon):
> \par > > http://www.msdn.microsoft.com/chats/
> \par > > Public newsgroups:
> \par > >
http://www.microsoft.com/technet/co...r/commerce.mspx
> \par > > Web logs and community:
> \par > > http://www.microsoft.com/commercese...ty/default.mspx
> \par > > Other resources:
> \par > >
http://www.microsoft.com/technet/pr...02/default.mspx
> \par > > ------=_NextPart_0001_07424BD0
> \par > > Content-Type: text/x-rtf
> \par > > X-Google-AttachSize: 2957
> \par > >
> \par > >
\& #123;\\rtf1\\ansi\\ansicpg1252\\deff0\\d
eflang1033\{\\fonttbl\{\\f0\\fnil\\fprq
2\\fcharset0 MS Sans Serif;\}\}
> \par > > \\viewkind4\\uc1\\pard\\f0\\fs20 You can do this using
CatalogSearch. The SqlWhereClause on the CatalogSearch would be something
like "DefinitionName like '%E_BOOK%'". You can set the search.CategoryName
\\par
> \par > > \\par Thanks,
> \par > > \\par Sudha
> \par > > \\par \\pard\\li720 --------------------
> \par > > \\par From: "senthilkumar" <senthilkumarj@gmail.com>
> \par > > \\par Newsgroups: microsoft.public.commerceserver.general
> \par > > \\par Subject: To Display Products with respect to
ProductDefinitions
> \par > > \\par Date: 24 Feb 2006 05:12:29 -0800
> \par > > \\par Organization: http://groups.google.com
> \par > > \\par Lines: 16
> \par > > \\par Message-ID:
<1140786749.607155.50850@t39g2000cwt.googlegroups.com>
> \par > > \\par NNTP-Posting-Host: 203.101.40.88
> \par > > \\par Mime-Version: 1.0
> \par > > \\par Content-Type: text/plain; charset="iso-8859-1"
> \par > > \\par X-Trace: posting.google.com 1140786757 27244 127.0.0.1 (24
Feb 2006 13:12:37 GMT)
> \par > > \\par X-Complaints-To: groups-abuse@google.com
> \par > > \\par NNTP-Posting-Date: Fri, 24 Feb 2006 13:12:37 +0000 (UTC)
> \par > > \\par User-Agent: G2/0.2
> \par > > \\par X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0;
Windows NT 5.0; .NET CLR 1.1. 4322),gzip(gfe),gzip(gfe)
> \par > > \\par X-HTTP-Via: 1.0 squid.accelicimtech.com:3128
(squid/2.5.STABLE6)
> \par > > \\par Complaints-To: groups-abuse@google.com
> \par > > \\par Injection-Info: t39g2000cwt.googlegroups.com; posting-host
3.101.40.88;
> \par > > \\par posting- account=0gKvzg0AAABjEgNFQ9y1CySyjBvRQUoX

> \par > > \\par Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet..it!tiscali!n
ewsfeed1.ip.tiscali.net!news.maxwell.syr.edu!postnews.google.com!t39g2000cwt
.googlegroups.com!not-for-mail
> \par > > \\par Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.commerceserver.general:17589
> \par > > \\par X-Tomcat-NG: microsoft.public.commerceserver.general
> \par > > \\par
> \par > > \\par Hi,
> \par > > \\par
> \par > > \\par can we display products in aspx page according to
ProductDefinition for
> \par > > \\par exaple
> \par > > \\par
> \par > > \\par Catalog - BOOKSHOP
> \par > > \\par Categories - MEDICINE,COMPUTERS
> \par > > \\par Products - BOOK,E-BOOK,AUDIO BOOKS....
> \par > > \\par
> \par > > \\par I want to display all E-books contained in
productdefinition of type
> \par > > \\par E_BOOK.
> \par > > \\par
> \par > > \\par
> \par > > \\par Regards
> \par > > \\par Senthilkumar
> \par > > \\par
> \par > > \\par \\pard
> \par > > \\par
> \par > > \\par This posting is provided "AS IS" with no warranties, and
confers no rights.
> \par > > \\par You assume all risk for your use. \'a9 2006 Microsoft
Corporation. All rights
> \par > > \\par reserved.
> \par > > \\par Use of included script samples are subject to the terms
specified at
> \par > > \\par http://www.microsoft.com/info/cpyright.htm
> \par > > \\par
> \par > > \\par Have a Commerce Server \\ldblquote How To\\rdblquote
question? Help is a click away at our Chats, Newsgroups and Web logs
> \par > > \\par
> \par > > \\par Chats (2nd Wednesday of the month from 11 to Noon):
http://www.msdn..microsoft.com/chats/
> \par > > \\par Public newsgroups:
http://www.microsoft.com/technet/co...r/commerce.mspx
> \par > > \\par Web logs and community:
http://www.microsoft.com/commercese...ty/default.mspx
> \par > > \\par Other resources:
http://www.microsoft.com/technet/pr...02/default.mspx
> \par > > \\par \}
> \par > > ------=_NextPart_0001_07424BD0--
> \par >
> \par >
> \par \pard
> \par
> \par This posting is provided "AS IS" with no warranties, and confers no
rights.
> \par You assume all risk for your use. 'a9 2005 Microsoft Corporation.
All rights
> \par reserved.
> \par Use of included script samples are subject to the terms specified at
> \par http://www.microsoft.com/info/cpyright.htm
> \par
> \par Have a Commerce Server \ldblquote How To\rdblquote question? Help
is a click away at our Chats, Newsgroups and Web logs
> \par
> \par Chats (2nd Wednesday of the month from 11 to Noon):
http://www.msdn.microsoft.com/chats/
> \par Public newsgroups:
http://www.microsoft.com/technet/co...r/commerce.mspx
> \par Web logs and community:
http://www.microsoft.com/commercese...ty/default.mspx
> \par Other resources:
http://www.microsoft.com/technet/pr...02/default.mspx
> \par }
> ------=_NextPart_0001_17285820--

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2005 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Have a Commerce Server “How To” question? Help is a click away at our
Chats, Newsgroups and Web logs

Chats (2nd Wednesday of the month from 11 to Noon):
http://www.msdn.microsoft.com/chats/
Public newsgroups:
http://www.microsoft.com/technet/co...r/commerce.mspx
Web logs and community:
http://www.microsoft.com/commercese...ty/default.mspx
Other resources:
http://www.microsoft.com/technet/pr...02/default.mspx