SelectParameters suing "OR" instead of "AND"

Posts   
 
    
Posts: 5
Joined: 13-Jun-2006
# Posted on: 19-Jun-2007 01:24:19   

I want to set up a DataSource with SelectParameters that use an OR where clause instead of an AND clause. Is this possible?


<llblgenpro:LLBLGenProDataSource2 ID="CustomerDataSource" runat="server">
        <SelectParameters>
            <asp:Parameter DefaultValue="True" Name="Rich" />
            <asp:Parameter DefaultValue="True" Name="Stupid" />
        </SelectParameters>
</llblgenpro:LLBLGenProDataSource2>

I want to get all the "Rich" customers and all the "Stupid" customers, not just the "Rich Stupid" customers.

Any ideas?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 19-Jun-2007 05:49:51   

Hi Kevin. As far as I know there isn't a property that allows you to change that. However you can use the property LLBLGenDataSource2.FilterToUse at Page_Load event to specify the filter you want.

David Elizondo | LLBLGen Support Team
Posts: 5
Joined: 13-Jun-2006
# Posted on: 19-Jun-2007 23:50:08   

Thanks David, This will work for what I need.