Home All Groups Group Topic Archive Search About

using range with webdav

Author
3 Feb 2009 11:33 AM
Doug
When I use the range header in

objXMLHTTP.SetRequestHeader "Range", "rows=0-9"

how can I query webdav to give me the total number of rows so I can
make my query 0-9,  10-20 etc etc  so that I dont do massive resource
intensive queries rather more incremental queries?

Author
3 Feb 2009 2:39 PM
Lee Derbyshire [MVP]
"Doug" <ddal***@gmail.com> wrote in message
news:68210d3e-aeb7-4ccc-a13a-f078c855b2a6@k1g2000prb.googlegroups.com...
> When I use the range header in
>
> objXMLHTTP.SetRequestHeader "Range", "rows=0-9"
>
> how can I query webdav to give me the total number of rows so I can
> make my query 0-9,  10-20 etc etc  so that I dont do massive resource
> intensive queries rather more incremental queries?

You want the total number of items in the folder?  Get its DAV:visiblecount
property.

Lee.

--
______________________________________

Outlook Web Access For PDA , OWA For WAP
www.leederbyshire.com
email a@t leederbyshire d.0.t c.0.m
______________________________________
Are all your drivers up to date? click for free checkup

Author
4 Feb 2009 12:35 AM
Doug
<?xml version="1.0"?>
<D:searchrequest xmlns:D="DAV:">
<D:sql>
  SELECT "DAV:visiblecount"
  FROM "$url" WHERE "DAV:ishidden"=False AND "DAV:isfolder"=False
  </D:sql>
</D:searchrequest>

Gives me every item in the folders property "visiblecount"  how do I
just count just the items in a folder?

for example inbox has 4000 items (mails)

On Feb 3, 6:39 am, "Lee Derbyshire [MVP]" <email a@t leederbyshire d.
0.t c.0.m> wrote:
Show quoteHide quote
> "Doug" <ddal***@gmail.com> wrote in message
>
> news:68210d3e-aeb7-4ccc-a13a-f078c855b2a6@k1g2000prb.googlegroups.com...
>
> > When I use the range header in
>
> > objXMLHTTP.SetRequestHeader "Range", "rows=0-9"
>
> > how can I query webdav to give me the total number of rows so I can
> > make my query 0-9,  10-20 etc etc  so that I dont do massive resource
> > intensive queries rather more incremental queries?
>
> You want the total number of items in the folder?  Get its DAV:visiblecount
> property.
>
> Lee.
>
> --
> ______________________________________
>
> Outlook Web Access For PDA , OWA For WAPwww.leederbyshire.com
> email a@t leederbyshire d.0.t c.0.m
> ______________________________________
Author
4 Feb 2009 12:48 AM
Doug
I see  "DAV:isfolder"=true... and "DAV:visiblecount" is the number in
the folder...

does that include subfolders?

On Feb 3, 4:35 pm, Doug <ddal***@gmail.com> wrote:
Show quoteHide quote
> <?xml version="1.0"?>
> <D:searchrequest xmlns:D="DAV:">
>  <D:sql>
>   SELECT "DAV:visiblecount"
>   FROM "$url" WHERE "DAV:ishidden"=False AND "DAV:isfolder"=False
>   </D:sql>
>  </D:searchrequest>
>
> Gives me every item in the folders property "visiblecount"  how do I
> just count just the items in a folder?
>
> for example inbox has 4000 items (mails)
>
> On Feb 3, 6:39 am, "Lee Derbyshire [MVP]" <email a@t leederbyshire d.
>
> 0.t c.0.m> wrote:
> > "Doug" <ddal***@gmail.com> wrote in message
>
> >news:68210d3e-aeb7-4ccc-a13a-f078c855b2a6@k1g2000prb.googlegroups.com...
>
> > > When I use the range header in
>
> > > objXMLHTTP.SetRequestHeader "Range", "rows=0-9"
>
> > > how can I query webdav to give me the total number of rows so I can
> > > make my query 0-9,  10-20 etc etc  so that I dont do massive resource
> > > intensive queries rather more incremental queries?
>
> > You want the total number of items in the folder?  Get its DAV:visiblecount
> > property.
>
> > Lee.
>
> > --
> > ______________________________________
>
> > Outlook Web Access For PDA , OWA For WAPwww.leederbyshire.com
> > email a@t leederbyshire d.0.t c.0.m
> > ______________________________________
Author
4 Feb 2009 1:53 AM
Lee Derbyshire [MVP]
Sorry, add

  GROUP BY "D:contentclass"

after your FROM line.


"Doug" <ddal***@gmail.com> wrote in message
news:f27232a7-ea43-4422-bdc0-947eec1d8bea@l33g2000pri.googlegroups.com...
I see  "DAV:isfolder"=true... and "DAV:visiblecount" is the number in
the folder...

does that include subfolders?

On Feb 3, 4:35 pm, Doug <ddal***@gmail.com> wrote:
Show quoteHide quote
> <?xml version="1.0"?>
> <D:searchrequest xmlns:D="DAV:">
> <D:sql>
> SELECT "DAV:visiblecount"
> FROM "$url" WHERE "DAV:ishidden"=False AND "DAV:isfolder"=False
> </D:sql>
> </D:searchrequest>
>
> Gives me every item in the folders property "visiblecount" how do I
> just count just the items in a folder?
>
> for example inbox has 4000 items (mails)
>
> On Feb 3, 6:39 am, "Lee Derbyshire [MVP]" <email a@t leederbyshire d.
>
> 0.t c.0.m> wrote:
> > "Doug" <ddal***@gmail.com> wrote in message
>
> >news:68210d3e-aeb7-4ccc-a13a-f078c855b2a6@k1g2000prb.googlegroups.com...
>
> > > When I use the range header in
>
> > > objXMLHTTP.SetRequestHeader "Range", "rows=0-9"
>
> > > how can I query webdav to give me the total number of rows so I can
> > > make my query 0-9, 10-20 etc etc so that I dont do massive resource
> > > intensive queries rather more incremental queries?
>
> > You want the total number of items in the folder? Get its
> > DAV:visiblecount
> > property.
>
> > Lee.
>
> > --
> > ______________________________________
>
> > Outlook Web Access For PDA , OWA For WAPwww.leederbyshire.com
> > email a@t leederbyshire d.0.t c.0.m
> > ______________________________________

Bookmark and Share