|
Home > Archive > Commerce Server General > August 2005 > Get all data from the CATALOG_ATTRIBUTES table
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 |
Get all data from the CATALOG_ATTRIBUTES table
|
|
| Stephan 2005-07-31, 7:47 am |
| Hi,
i want to get all data from the CATALOG_ATTRIBUTES table.
i tried using the followings:
CatalogAttributesEnum catalogAttributesEnum =
CatalogAttributesEnum.cscPropertyAttributes;
1. ADODB.Recordset rsPropertiesAttributes = (ADODB.Recordset)
catalogManager.GetAttributes(catalogAttributesEnum, false);
but it doesnt work - it just gives me the schema of the table with no data
i looked in the MSSQL profiler and saw that it was the following STP
"ctlg_GetDefinedPropertyAttributes" which get the table's data, the problem
is that it gets the schema only with no data.
10Q
| |
| Vinayak Tadas[MSFT] 2005-08-03, 5:51 pm |
| You should use oCatalogamanager.Properties property
http://msdn.microsoft.com/library/d...-us/csvr2002/ht
m/cs_rp_catalogmanager_uqln_c.asp
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
--------------------
Thread-Topic: Get all data from the CATALOG_ATTRIBUTES table
thread-index: AcWVsm0/MEiLd7PfQ5qcVC+hZ6WMkQ==
X-WBNR-Posting-Host: 207.232.8.18
From: "=?Utf-8?B?U3RlcGhhbg==?=" <Stephan@discussions.microsoft.com>
Subject: Get all data from the CATALOG_ATTRIBUTES table
Date: Sun, 31 Jul 2005 02:30:02 -0700
Lines: 18
Message-ID: <6BA77677-9180-406E-9C74-6638B67D6132@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
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:3122
X-Tomcat-NG: microsoft.public.commerceserver.general
Hi,
i want to get all data from the CATALOG_ATTRIBUTES table.
i tried using the followings:
CatalogAttributesEnum catalogAttributesEnum =
CatalogAttributesEnum.cscPropertyAttributes;
1. ADODB.Recordset rsPropertiesAttributes = (ADODB.Recordset)
catalogManager.GetAttributes(catalogAttributesEnum, false);
but it doesnt work - it just gives me the schema of the table with no data
i looked in the MSSQL profiler and saw that it was the following STP
"ctlg_GetDefinedPropertyAttributes" which get the table's data, the problem
is that it gets the schema only with no data.
10Q
|
|
|
|
|