i want to create a filter with null

Posts   
 
    
bo2bo2 avatar
bo2bo2
User
Posts: 13
Joined: 03-Apr-2006
# Posted on: 06-Feb-2007 11:06:14   

i need to create a filter which retrieves rows with null value like


            IPredicateExpression filter = new PredicateExpression();
            filter.Add(ItemSubCategoryFields.SubCategoryId is null);

but ofcourse that wouldn't work confused

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39927
Joined: 17-Aug-2003
# Posted on: 06-Feb-2007 11:12:58   

filter.Add(ItemSubCategoryFields.SubCategoryId == DBNull.Value);

Frans Bouma | Lead developer LLBLGen Pro
bo2bo2 avatar
bo2bo2
User
Posts: 13
Joined: 03-Apr-2006
# Posted on: 06-Feb-2007 11:15:56   

silly me flushed