Cheers Jason, I was just thinking that I could purge the data from dmArchive older than lastdatetimeupdated >= date and then run the code to fixrefobjects and this should do what I need in one hit?
By doing this in a template, then putting this into the scheduled tasks to run nightly I should be safe with this. Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Sent: Friday, 1 June 2007 12:40 PM To: farcry-dev Subject: [farcry-dev] Re: dmArchive table You can remove any objects you want from dmArchive, just run the fixrefobjects afterwards and it will remove any entries in refobjects that no longer exists in the content table it represents. In fact fixrefobjects should also insert any items missing from refobjects that exist in a content type. On Jun 1, 12:26 pm, Andrew Scott <[EMAIL PROTECTED]> wrote: > Jason, > > Thank you so much, that is precisely what I have been looking for. But the > one question I will ask though, is there a way to do this without breaking > the live version? > > Sorry but even though you cleared it up, I do not know enough about the > tables to make an informed decision on the best way to do what I require. > > Andrew Scott > Senior Coldfusion Developer > Aegeon Pty. Ltd.www.aegeon.com.au > Phone: +613 8676 4223 > Mobile: 0404 998 273 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
