Interestingly enough, boolean type columns can either be used as Integer or Boolean values and heres how its done.
string CAMLQuery = "<Where> <Eq><FieldRef Name='Online'/> <Value Type='Integer'>1</Value></Eq> </And> </Where>" ;
or
string CAMLQuery = "<Where> <Eq><FieldRef Name='Online'/> <Value Type='Boolean'>True</Value></Eq> </And> </Where>" ;
where TRUE, True, true are all possible values
string CAMLQuery = "<Where> <Eq><FieldRef Name='Online'/> <Value Type='Integer'>1</Value></Eq> </And> </Where>" ;
or
string CAMLQuery = "<Where> <Eq><FieldRef Name='Online'/> <Value Type='Boolean'>True</Value></Eq> </And> </Where>" ;
where TRUE, True, true are all possible values
No comments:
Post a Comment