One idea - at the end of the loop, add the ID from the old database to a
server variable. That way if you have to run it again, you can say
(pseudo-code): add record if id not in server.donelist.
Of course, this assumes you are going to do the whole thing in one sitting.
Oh, you could also delete the records from the old db as you copy. If you
can't delete them, make a copy of the old db, suck the data from there, and
delete from there.
=======================================================================
Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com)
Allaire Certified Instructor and Member of Team Allaire
Email : [EMAIL PROTECTED]
ICQ UIN : 3679482
"My ally is the Force, and a powerful ally it is." - Yoda
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 03, 2000 10:05 PM
> To: [EMAIL PROTECTED]
> Subject: RE: External Content to ContentObject?
>
>
> Neil,
>
> A couple of slight additions to this --
>
> 1) Don't expect the code to run quickly that adds objects to the
> CODB. In fact
> it may run very slow. On the order of an object or two per second.
>
> 2) If the browser times out (which it probably will with 10,000
> records), the
> code will often continue to run and so will in fact complete. Be
> careful not to
> set it off again as you'll get two of each object in the CODB
> (since there is no
> primary key violation with a new UUID made for each object).
>
> David Aden
>
> -----Original Message-----
> From: Neil Clark [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 03, 2000 10:33 AM
> To: [EMAIL PROTECTED]
> Subject: RE: External Content to ContentObject?
>
>
> Damn, I knew I should have 'properly' read ithe book ;-)
>
> <! -----------------------------------
> Neil Clark
> Senior Web Applications Engineer
> mcb digital
> Tel. +44 (0)20 8941 3232
> Tel. +44 (0)20 8408 8131 [Direct]
> http://www.mcbdigital.com
> ----------------------------------->
>
>
>
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
