Hi,

iv gone around the block a few times with this one. Iv created a simple web user control for user search agaisnt products.

Using the linq query below. I would like to know why this returns deleted products??

Its returning products that have been deleted individually as well as products that have been deleted via their category.

 var q = from product in Product.All()
                    where product.ParentProductId == null
                    select product;

I require a way to remove these items from the search results. Even using the category.Deleted property on products category (that has been deleted) always shows false. (I.e not been deleted)

This is making it impossible to display a correct listing of results.

I do not have access to the DB due to my customers hosting package.

Many thanks in advance.

If iv missed any vital informaiton please request and il do my best to reply ASAP.

Deano