At 06:28 AM 6/9/2001 -0400, you wrote:
>Okay. Gotta come right out and admit the dumb thing I did. I scripted a
>database and ran the script in that database rather than the new database.
>So everything got dropped and recreated. Not good.
One of my coworkers once ran a script to update the price of a product but
forgot the where clause.
Don't feel too bad. These things happen sometimes. Luckily, I have managed
to not do anything like this yet. The missing where clause incident made me
pretty paranoid. There's nothing like hearing your senior programmer
screaming to instill The Fear.
What you might be able to do is run a rollback. Some databases will let you
rollback to a certain date. I've seen this done with a couple of databases,
but SQL 7 isn't one of them. It might be possible with SQL 7 but I just
don't know. If it is possible, then it'll be an easy solution for you.
Besides, it would be good to know that if you run an update without a where
clause, you could recover after only a few minutes of freaking out.
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
