I need to get the list items from SP 2010 SPList, having the below criteria:
get all the records/listitems whose ID value in between 100 and 110. What should be the CAMl query for matching the above criteria.i have tried the below , but unfortunately it didn't work. i dont have U2U2 CAML builder tool installed in my dev machine.Hence, i am not able to test this!
<Query> <Where> <And> <Gt> <FieldRef Name='ID' /> <Value Type='Number'>100</Value> </Gt> <Lt> <FieldRef Name='ID' /> <Value Type='Number'>110</Value> </Lt> </And> </Where> </Query>