Yup. that's what I am doing now. CFTransaction is an option but it won't do me any good if for some reason the processing just stops without any error. It is strange but that's what's happening. I haven't found any errors in the logs. Also, it gets more interesting as the task runs every 12 hours. the one that runs in the evening is fine and the one running in the morning has started to not run after deleting records from two tables. I am also going to start writing each row's insert/update success to a log file to see exactly what's going on.
On Thu, Nov 12, 2009 at 4:01 PM, Alan Rother <alan.rot...@gmail.com> wrote: > > Hmm... > > Ok, any chance you could create Temp tables that match the production ones? > Run your import on them, then once complete, table by table TRUNCATE the > prod data and then transfer the new data over to the real tables? > > =] > > > -- > Alan Rother > Adobe Certified Advanced ColdFusion MX 7 Developer > Manager, Phoenix Cold Fusion User Group, AZCFUG.org > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4