CodeSmith Community

Hi

I've got a string of filters to link with "and" as in below

<Parameters>
            <data:SqlParameter
                Name="WhereClause"
                UseParameterizedFilters="false">
               <Filters>
                    <data:BookingExpressionBuilder
                        Column="PersonId" 
                        QueryStringField="PassedPerson"
                        BuilderExpression="AppendEquals">
                    </data:BookingExpressionBuilder>
               
                   <data:BookingExpressionBuilder
                        Column="Date" 
                        QueryStringField="PassedStartDate"
                        BuilderExpression="AppendGreaterThanOrEqual">
                    </data:BookingExpressionBuilder>
                   
                  <data:BookingExpressionBuilder
                        Column="Date"
                        QueryStringField="PassedEndDate"
                        BuilderExpression="AppendLessThanOrEqual">
                    </data:BookingExpressionBuilder>
                </Filters>
             </data:SqlParameter>
        </Parameters>

How would this look if I wanted to use "or" as in (PersonId=PassedPerson or  Date >= PassedStartDate or Date<=PassedEndDate)

Know the last bit is silly but you get the idea.

Thanks in advance Paul

[Think I'm sort of getting the hang of this:-) ]