Thanks Ann.

Regarding ColdFusion and executing a commit between operations:
I'm not certain about this, but I would expect that each of the small
selects and updates are "committed" by ColdFusion as they are run (via
individual "CFQUERY" coldfusion tags). I'll try stopping the CF
server. If I'm right, then the updates that took place to that point
will still be there.

Thanks again!

> That sounds right to me. Is there some way to convince ColdFusion to
> execute a commit between some of its operations. Obviously, if you're
> producing a report that has to be consistent from beginning to end,
> that's not a solution, but most web stuff is kind of ad hoc ... The
> long lasting connection isn't as much of a problem as a long

transaction.

>
> Regards,
>
>
> Ann