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.CatalogSyst
em);
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 t
hey ought to be. Hence the custom among the Scythians of plucking out a cyni
c's eyes to improve his vision.

[ Post a follow-up to this message ]

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 th
e SqlWhereClause and returns
> all the categories.  I tried changing the references in my project to poin
t
> 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.CatalogSy
stem);
> 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 ou
ght to be. Hence the custom among the Scythians of plucking out a cynic's eyes to im
prove his vision.

[ Post a follow-up to this message ]