Yup. Why don't you look at <cftransaction>?
-----Original Message-----
From: Steven Dworman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 10:14 AM
To: CF-Talk
Subject: oracle and coldfusion
Here's the situation. I have this rather large and complex package of
procedures, and I want to avoid doing a commit or rollback inside the procs.
What I am attempting to do is run the procedures and if there is an error
message do a rollback, or if no error message then do a commit. This would
be done in CF.
Is it possible to turn off the auto commit feature in CF? From my
experience
CF does a commit on any sql statement passed to a SQL server or Oracle db.
Thanks,
Steve
--
Steven D Dworman
------------------------------
Web Consultant
Systems Administrator
office: 248.647.8841
cell: 734.972.9676
------------------------------
ComSpec International
http://www.comspec-intnl.com
***Empower XL
---Software for Higher Education---
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
