| Jack of all trades, Master of none 2004-07-27, 2:52 am |
| The following search (with the names changed to protect the innocent),
only returned categories that had the custom property set to 1.
After installing FP1, and migrating the catalog, the search is ignoring the SqlWhereClause and returns
all the categories. I tried changing the references in my project to point
at the FP1 assemblies (runtime and shared), but that had no effect.
Any help would be greatly appreciated.
CatalogSearchOptions searchOptions = new CatalogSearchOptions();
searchOptions.ClassTypes = CatalogClassTypes.CategoryClass;
CatalogSearch search = new CatalogSearch(CommerceContext.Current.CatalogSystem);
search.CatalogNames = catalogName;
search.CategoryName = categoryName;
search.SearchOptions = searchOptions;
search.Recursive = false;
search.SqlWhereClause = @"[CustomProperty] = 1";
Sincerely,
Jack
--
CYNIC, n. A blackguard whose faulty vision sees things as they are, not as they ought to be. Hence the custom among the Scythians of plucking out a cynic's eyes to improve his vision.
|