Category.Products
.gif "Ee798442.c++_on(en-US,CS.10).gif")
.gif "Ee798442.vb_off(en-US,CS.10).gif")
The Products property is a read-only recordset that contains product data for all of the products that exist directly within this category.
Definition
Property Products(Optional eClassTypeRequired As Variant,Optional strPropertyToSortOn As Variant,Optional lStartingRecord As Variant,Optional lRecordsToRetrieve As Variant,Optional plTotalRecordsInQuery As Variant) As _Recordset
Parameters
eClassTypeRequired
A Variant that contains the catalog class desired. Valid values are from the CatalogClassTypeEnum enumeration. For more information, see the Remarks section.
strPropertyToSortOn
A Variant that contains the property to sort on.
lStartingRecord
A Variant that contains the starting record number.
lRecordsToRetrieve
A Variant that contains the number of records to retrieve.
plTotalRecordsInQuery
A Variant used to return the total number of records in the query.
Error Values
This method sets the Number property of the global Err object to S_OK (&H00000000) to indicate success and to standard COM error values to indicate failure. For more information about standard COM errors, see Standard COM Errors. Additional information may be available using the global Err object. In particular, the Description property may contain a text description of the error.
Remarks
If the properties specified in strPropertyToSortOn parameter are invalid then the recordset will be unsorted.
.gif "Ee798442.note(en-US,CS.10).gif")
Note
- If the value of cscCategoryClass is specified for the eClassTypeRequired parameter, the returned recordset will contain all the products and all the child categories in this category.
The Products property contains the product data for all the products in this category.
The returned recordset contains all the fields in the CatalogProduct Recordset.
If this category contains no products, then the Products property returns an empty recordset whose EOF property is set to VARIANT_TRUE.
The following table shows the values of the CatalogClassTypeEnum enumeration, their associated names, and describes their use.
| Name | Value | Description |
| cscCategoryClass | 1 | Requests category data. |
| cscProductVariantClass | 2 | Requests product variant data. |
| cscProductClass | 4 | Requests product data. |
| cscProductFamilyClass | 8 | Requests product family data. |
| cscProductFamilyForVariantsClass | 16 | Requests family for variant data, which means the product family of a product variant is being requested. |
| CscProductVariantsForFamily | 32 | Requests variants for family data, which means that all of the product variants for a product family are being requested. |
CatalogClassTypeEnum values can be combined in the eClassTypeRequired parameter with logical OR operators, so that specifying cscProductClass OR cscProductVariantClass will return both product and product variant data.
For more information about memory ownership issues related to COM property and method parameters, see Managing COM Parameter Memory.