|
Home > Archive > Commerce Server Catalog > July 2004 > Category Search incorrect after FP1 installed
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 |
Category Search incorrect after FP1 installed
|
|
| Jack of all trades, Master of none 2004-07-27, 5:54 pm |
| I've tried sending this yesterday, but got an error.
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.
| |
|
| Test
--
Tony
"Jack of all trades, Master of none" wrote:
> I've tried sending this yesterday, but got an error.
>
> 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.
|
|
|
|
|