|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
using range with webdavWhen 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? "Doug" <ddal***@gmail.com> wrote in message You want the total number of items in the folder? Get its DAV:visiblecount 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? property. Lee. -- ______________________________________ Outlook Web Access For PDA , OWA For WAP www.leederbyshire.com email a@t leederbyshire d.0.t c.0.m ______________________________________ <?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 > ______________________________________ 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 > > ______________________________________ Sorry, add
GROUP BY "D:contentclass" after your FROM line. "Doug" <ddal***@gmail.com> wrote in message I see "DAV:isfolder"=true... and "DAV:visiblecount" is the number innews:f27232a7-ea43-4422-bdc0-947eec1d8bea@l33g2000pri.googlegroups.com... 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 > > ______________________________________
Other interesting topics
Ex2003 PF Async Event Sink OnDelete fires OnSave doesn't
Incremental email updates via webdav Delegated Admin View Only Forms-based authentication in Exchange 2003 AND Exchange 2007 Intercepting emails as they are sent Query Exchange 2003 mailbox store (mailbox sizes etc) Outgoing emails: add automatically actual information and / or attachment Exchange 2007 Backup/Restore API problem OWA extension problem 500 Internal Server Error |
|||||||||||||||||||||||