That should work fine. On Jun 1, 12:44 pm, Andrew Scott <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
