[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: CAP-12-e: 18.104.22.168 Query by Date-Time range
I posted the same question a few days ago:
Doug replied to this thread but I must confess I was still confused after reading it and I didn't get a chance to reply back.
From: Bruce_Kahn@xxxxxxxxxxxxxxxx [mailto:Bruce_Kahn@xxxxxxxxxxxxxxxx]
Sent: Thursday, December 11, 2003 10:58 AM
Subject: CAP-12-e: 22.214.171.124 Query by Date-Time range
In revistiing some sections of CAP 12-e for snippets for other postings I ran across what appears to be an incorrect example for the section. Section 126.96.36.199 Query by Date-Time range should have an example for getting "every booked "VEVENT" component that has an instance greater than or equal to July 1st, 2000 00:00:00 UTC and less than or equal to July 30st, 2000 23:59:59 UTC."
However the query is using RECURRENCE-ID which is an instance identifier and NOT the acutal entry occuring in that time range. I believe the correct example should be:
QUERY:SELECT * FROM VEVENT
WHERE DTSTART >= '20000701T000000Z'
AND DTEND <= '20000730T235959Z'
AND STATE() = 'BOOKED'
Bruce Kahn INet: Bruce_Kahn@xxxxxxxxxxxxxxxx
Messaging & Collaboration Phone: 978.399.6496
IBM Software Group FAX: and nothing but the FAX...
Standard disclaimers apply, even where prohibited by law...