Is this a Pilot or POC? If it is a Production system, do not go the Direct Database Route, it is not supported and if you mess up something...then well...there you go. I wouldn't advise it. Try these to see if they help... http://sridharu.blogspot.com/2008/01/how-to-read-recurring-events-using-caml.html http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spfieldrecurrence.aspx Dave P
Date: Mon, 6 Oct 2008 10:21:03 +1000From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Re: [OzMOSS] SPSiteDataQuery and Calendar recurrence As bad as it is, perhaps the most efficient way is going to be directly accessing the Database. I know it is never a good idea to do so... but we are left with very little choice on this one. Any more thoughts? On Fri, Oct 3, 2008 at 8:57 PM, Bill Williamson <[EMAIL PROTECTED]> wrote: Recurrance is nasty. I'm not aware of any way of getting it except for hardcoding some logic, which might change later.If there is a helper class for this someone please chime in, I will be grateful! On Wed, Oct 1, 2008 at 1:45 PM, Sharepoint Consultant <[EMAIL PROTECTED]> wrote: Hi all, I need to search for all Calendar events across my site collection. I need for the query to return all recurrence information so that I can replicate events to a separate system. Can I do this with SPSiteDataQuery or is SPList.GetItems(SPQuery) the only way of achieving this? Obviously looping through all Lists is not a very neat solution. Thanks heaps.------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject.Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject.Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject.Powered by mailenable.com ------------------------------------------------------------------- OzMOSS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com
