At 04:37 PM 6/9/2001 -0400, you wrote:
>1) Hopefully your dba does nightly backups and worst case scenario you lose
>1 days worth of data.
>
>2) CF generates an automatic commit, so if you tinker with any data in a
>cfquery tag, there is no rollback for you. ( Also if you issue and ddl or
>dcl commands)
That's not the rollback that I'm talking about. I'm talking about rolling
back to a certain date. I'm pretty sure I saw this done in Oracle, but it
might require setting up frequent internal backups. To tell you the truth,
I don't know much about it, but I'm pretty sure that we rolled back after
commit in the Oracle SQL interface without the help of the DBA. I'm almost
positive.
At any rate, if you've got documentation, read the stuff on rollbacks and
see if you can rollback after commit. If you can, you're in luck. If you
can't, you're not.
Now available in a San Francisco Bay Area near you!
http://63.74.114.11/mr_urc/index.cfm
http://63.74.114.11/mr_urc/resume.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
