> 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!

Isn't your CF script running via ODBC? If so, then it will be running , by
default, inside one implicit (page based) transaction. Unless you make
explicit transaction calls to start/commit/rollback.
Alan