|
|
Troll much?
If you think 'goto' is evil, try writing an Assembly program without JMP.
|
|
|
|
|
I think circlej**k is the correct term in this case.
|
|
|
|
|
Calling names again?
But why? First you start sobbing when I say that Mickeysoft sucks and now you start crying when I find something that does not suck. Now make up your mind. 
The language is JavaScript. that of Mordor, which I will not utter here
This is Javascript. If you put big wheels and a racing stripe on a golf cart, it's still a f***ing golf cart.
"I don't know, extraterrestrial?"
"You mean like from space?"
"No, from Canada."
If software development were a circus, we would all be the clowns.
|
|
|
|
|
@petepjksolutionscomm
No CCC yesterday, no CCC today ... do you want to do it tomorrow, or does this need a reboot?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
He is prolly trying to fulfill the expectations of 94 bank holidays!
... such stuff as dreams are made on
|
|
|
|
|
OriginalGriff wrote: or does this need a reboot?
Maybe we need a hard reboot 
Rules for the FOSW ![ ^]
if(this.signature != "")
{
MessageBox.Show("This is my signature: " + Environment.NewLine + signature);
}
else
{
MessageBox.Show("404-Signature not found");
}
|
|
|
|
|
A hard boot in his butt! 
|
|
|
|
|
That's a nice UPDATE statement you've got there...
Would be a shame if it were to be executed...
Without a WHERE clause 
Nothing serious, but still a PITA.
I was about to delete that statement, but hit F5 instead of backspace 
|
|
|
|
|
Argh! NOOOOO! ROLLBACK! Rollback! rollback, please...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Been there, done that. Nothing quite as unnerving as seeing 847 rows affected when you only expected 1. Fortunately it was something like adding a quantity of 5 to an existing value, so I could just reverse it.
|
|
|
|
|
Whenever doing insert\update\delete I always write the WHERE clause first
|
|
|
|
|
INSERT ... WHERE ...
Interesting.
Do you get a lot of success with that?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
|
Interesting, I always write my insert/update/delete statements with a WHERE 1=0 clause first, so even if I have a moment of sheer stupid and run it, chances are less likely it will work. After that, I add AND then the actual clause.
Trying to get people around here to wrap their insert/update/deletes in a rollback/commit block is like pulling teeth. Seriously, what do you expect the change to be? If it doesn't match that something went wrong.
|
|
|
|
|
I did, but I wanted to change the UPDATE Table... to SELECT * FROM TABLE... So I highlighted the query without the WHERE clause and wanted to delete it... With F5
|
|
|
|
|
ditto. But when using MySql (which I do for about 50% of my projects, Sql Server the other 50%) I usually use MySql Workbench; this has an option ("Safe updates") that prevents execution of update queries without a where clause. (Though it accepts WHERE 1=1 for when you really want to update everything).
|
|
|
|
|
Couple of weeks ago, but, as they used to say: "saved by the skin of my teeth"
Was working on code that produces SQL par rowsets by interpreting SQL table schema. Anyway, I was working on a version of the table that was named the same, but with an _test. I wanted to clear it of data, except the first record. DELETE FROM and then the moment of horror. My _test table wasn't empty. The production table was. Literally hundreds of reports and dozens of applications are totally dependent upon this table.
But, as it would happen, somehow a miracle was pre-planned. Literally the night before, my boss created an archive table. All the deleted records were moved to it. The several minutes of horror were soothed with a little bit of delete, rename, and then recreating that archive . . . just in case I want to drive myself to drink again, some day.* Amazingly, quick enough (although it seemed to take forever) that no one even called IT or put in a support request.
* Yes, there are backups, but until that could be brought to bare, a major panic was imminent, much yelling, screaming, gnashing of teeth, and then the bad stuff would start.
** This is only the second time in about 15 years I popped a production table. It was all much less essential that first time.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
W∴ Balboos wrote: * This is only the second time in about 15 years I popped a production table. It was all much less essential that first time.
With some equipment[^] you get no second chance.
The language is JavaScript. that of Mordor, which I will not utter here
This is Javascript. If you put big wheels and a racing stripe on a golf cart, it's still a f***ing golf cart.
"I don't know, extraterrestrial?"
"You mean like from space?"
"No, from Canada."
If software development were a circus, we would all be the clowns.
|
|
|
|
|
Many many years ago we had a word for that . . . . . . . . . . ooops!
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
We had something like that hanging right above those consoles:
A soldier sitting at a radar console and you can see a missile launching outside the window. He holds a telephone and asks: "How do you say 'sorry, my fault' in Russian?"
The language is JavaScript. that of Mordor, which I will not utter here
This is Javascript. If you put big wheels and a racing stripe on a golf cart, it's still a f***ing golf cart.
"I don't know, extraterrestrial?"
"You mean like from space?"
"No, from Canada."
If software development were a circus, we would all be the clowns.
|
|
|
|
|
I wrote an SQL-Generator for that, so every DB Model has it and the Generator creates the statements. This saves my a55
Rules for the FOSW ![ ^]
if(this.signature != "")
{
MessageBox.Show("This is my signature: " + Environment.NewLine + signature);
}
else
{
MessageBox.Show("404-Signature not found");
}
|
|
|
|
|
Unless selecting, always start your SQL script with "START TRANSACTION".
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Eddy Vluggen wrote: always start your SQL script with "START TRANSACTION".
That's like jumping out of a plane with a parachute on, just in case you need it. Real men don't need it.
There are two kinds of people in the world: those who can extrapolate from incomplete data.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
My rule of thumb is to create the select statement and run it before changing it to delete or update. That, however, only works if (1) I count on my thumbes, and (2) type the write table name. Everything could seem OK. (even with your Transaction wrap) until just a little bit later.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
