Paging caml query results

Question

I have about 1000 items in a custom list. i want to retrieve 10 only from a certain position, (i know how to do this).

I also want to get the total in the list.

How would i do this? (this is for custom paging)

RJ Cuthbertson · Accepted Answer · 2012-11-15 16:58:03Z

0

Have you tried getting the list and using SPList.Items.Count?

There is also an SPList.ItemCount property that includes folders as items in the count...

answered Nov 15 '12 at 16:58

RJ Cuthbertson

8,2926 gold badges35 silver badges76 bronze badges

This needs to be selected before the query limits the list. Afterwards it acts as an amount with the RowLimit as the maximum amount.
– Hugh Wood
Nov 15 '12 at 17:02
@HughWood is this additional information or are you saying this isn't a valid answer?
– RJ Cuthbertson
Nov 15 '12 at 18:42
Not at all, I am saying that I am putting a caveat on Item Count. If it wasn't valid I would of down voted.
– Hugh Wood
Nov 16 '12 at 8:19
@HughWood definitely. I was just unsure where you were going with that.
– RJ Cuthbertson
Nov 16 '12 at 14:18

Add a comment |

1 Answer 1