Personally, I use the old "Oracle" trick... only "lock" if you have to.
You remember the contents of the record when you originally "selected" the record (without any FOR UPDATE clause) and in the update statement, you compare the current contents of the record with the contents the original contents. If the record has changed then you'll get "0 records updated" and you know that "eh - that didn't work!" and you can then go into an exception routine.
The idea is that you will SELECT many times (so don't lock) and only UPDATE and small % of the records - and a smaller % will be in contention. So only do work when you have to.
e.g. (sorry about the Oracle syntax - but I'm sure you can convert for your purposes)
SELECT custname, custadd1 INTO:p_oldname,:p_oldadd1 FROM customer WHERE custid =:p_custid;
(1 row selected)
UPDATE customer SET custname =:p_newname, custadd1 =:p_newadd1 WHERE custid =:p_custid AND custname =:p_oldname AND custadd1 =:p_oldadd1
IF SQL%ROWCOUNT = 0 THEN ...error code... END IF
Yes - it involves extra typing - but if you want it done right - then do it right first time!!!
She should aim to get formal training in project management or management trouble shooting (PRINCE2 for example - in the UK at least. I'm sure the US has similar standard PM certification).
By asking for it, she will know if she is really "appriciated" as a trouble shooter. If they say "no" then you know that they just want her to "knock heads together" and then go back to her day job. Good for the boss as he get's the praise and profit, and no increase in salary costs.
If she get's the training then she should take on a role to "train the PM's" and stop these projects going tit's up in the first place. Good for the companies reputation?
If they don't then it's obvious that your wife has a brain, is not afriad to use it, so go get another job!
But if the job suit's her (close to home, child care) then stop kicking the horse. It's dead!
(My wife in a similar role at work - but they keep asking her to go for promotion and she refuses cause it would screw home our life.)
...I don't know about RailTrack employees (unless your house is leased by Railtrack, as they do own a huge amount of land and property), but I know that Gas Board and Electricity Board employees have a right of access to your property to inspect their metering equipment, even if it's inside your house, but they have no right to 'forced' entry without your presence.
The police (and customs officers) do have the right to access to your house, but not to search it, without a warrent. Anything evidence found without a warrent would be inadmissable in court. Obviously this is rarely used without a senior officers approval.
Interestingly, if you say 'no' to a TV Licencing people then they will just send you a summons to go to court, to appear before a judge who can fine you upto £4000 and may even imprison you!
Apart from that, the UK's a great place to live, but the weathers crummy!
All spelling mistakes are my own and do not represent the mistakes of my employer.
MS says they've "improved" the parsing speed of ASP vs HTML in W2K until there is no/little difference between them. Look up on MSDN / aspwire for more info. Not that your advice is not sound or correct. I'd still do the same (if/when) I migrate.
Dunno if the've stopped W3SVC crashing every two minutes tho!
Remove Windows Scripting Host from your computer, and you should be fine! So far, the best tool to use to remove WSH is fdisk. WSH comes as default on Win98 and W2k. NT can get it, but it is not installed as default
trying to remember it from my Patrick Moore "Universe" book, thanks Mum for the xmas pressie...
Your right that planet is derived from the greek word wanderer. This is because the ancient greeks couldn't understand why when observed that most of the stars moved from right to left during the night but some didn't follow the same path, but moved (and wandered) across the sky, sometimes even moving backwards and looped across the nights sky!
In fact these stars where the now known planets orbit as observed from the earth etc etc etc.
Can anyone try putting their display into Nested / Oldest First and see what they get?
(I might be putting my head in the lions month here but..) the formatting of the posts really screws up, starting half way across, with the "sections" panel in the centre (US center). then half way down it jumps over to the left.
OK - I'll admit to running IE5 *duck - flame attack*
Am I going mad? Can someone check please...
(BTW - Mozzilla 13 is surpisingly good! I've been keeping a sneakie eye on it and I recommend you check it out. Once they fix the proxy auth. then I'll ditch IE, I promise!!)
Everything you ranted about is illegal, and for very good reasons!
What if it was your daughter who was killed by a drunk driver speeding after running a red light! There are rules, that everyone must obey (and respect) otherwise NOBODY will have ANY freedom.
My first *real* job was maintaining an inventory control system, on an IBM System/36, written in RPG.
In German!
It was bad enought that any comments were in German, and all accounting terms (stock on hand, out of order, balance) but RPG limited you to 6 or 8 character variable names. And it was someones bright idea that the first two characters were used to identify the program. Then they used acroymns. Examples include GBKXA1 (always uppercase).
Above all that, RPG used indicators. These true/false 'flags' could be used to condition code, and 3 of these indicators could be concatenated on a single line.
Then you can set the indicators by placing it in columns from 60 to 65 (if I remember) based on the result field being zero, positive or negative.
Even better was the commenting function. RPG was (is) strictly column based. Place a * in column six and the line is a comment. How many times, when trying to work out what a program function was doing did I find that the code was in fact commented out.
Missing rule? Carefully hide open and close comment tags in the code
I was a good start to learn *what not to do* and the other guy's in the team taught me the basic's of maintanable code. Thankfully, I've forgotten most of it by now and work in the internet world where it seems obligatory to code in the most obtuse way as possible!!
I think all the Linux developers can let out a huge sigh of relief that their baby doesn't run like a dog (as claimed by MS), but can and does keep up with the big boys! And thanks to MS, it can only get better!!!
I still feel that the test is still aiming at Linus's achillies heal, so to say. How about rerunning the test on the old '486 in loft' hardware that the real world has got rather then $40K kit MS rolled out!
And don't underestimate the 'come in over the weekend to reboot it' factor (from a previous thread, too lazy to look it up but it made me chuckle!) - we're all too busy chatting away to have to keep an eye on the kit every second.
(Sorry - Connection refused - MS Proxy Server 2 - Too busy - Please try later)
Slashdot Mirror
Enjoy it while you can.
As soon as your "future wife" becomes your "Mrs", you'll know what it's like to have your arse ripped off by a croc!
And you can wave goodbye to "free sex whenever I want" - LOL
Personally, I use the old "Oracle" trick... only "lock" if you have to.
:p_oldname, :p_oldadd1 :p_custid;
:p_newname, :p_newadd1 :p_custid :p_oldname :p_oldadd1
...error code...
You remember the contents of the record when you originally "selected" the record (without any FOR UPDATE clause) and in the update statement, you compare the current contents of the record with the contents the original contents. If the record has changed then you'll get "0 records updated" and you know that "eh - that didn't work!" and you can then go into an exception routine.
The idea is that you will SELECT many times (so don't lock) and only UPDATE and small % of the records - and a smaller % will be in contention. So only do work when you have to.
e.g. (sorry about the Oracle syntax - but I'm sure you can convert for your purposes)
SELECT custname, custadd1
INTO
FROM customer
WHERE custid =
(1 row selected)
UPDATE customer SET
custname =
custadd1 =
WHERE custid =
AND custname =
AND custadd1 =
IF SQL%ROWCOUNT = 0 THEN
END IF
Yes - it involves extra typing - but if you want it done right - then do it right first time!!!
She should aim to get formal training in project management or management trouble shooting (PRINCE2 for example - in the UK at least. I'm sure the US has similar standard PM certification).
By asking for it, she will know if she is really "appriciated" as a trouble shooter. If they say "no" then you know that they just want her to "knock heads together" and then go back to her day job. Good for the boss as he get's the praise and profit, and no increase in salary costs.
If she get's the training then she should take on a role to "train the PM's" and stop these projects going tit's up in the first place. Good for the companies reputation?
If they don't then it's obvious that your wife has a brain, is not afriad to use it, so go get another job!
But if the job suit's her (close to home, child care) then stop kicking the horse. It's dead!
(My wife in a similar role at work - but they keep asking her to go for promotion and she refuses cause it would screw home our life.)
**Unbelieveable**
Your telling
I'm British, and I hope my irony stick aint broke...
Surely they will attach RFID tags to each fruit fly to make automatic scanning of your purchase quicker and more accurate.
OSS != Free (beer)
OSS == Free (libre)
It will have a fully-direct3D9 accelerated GUI, allowing all sorts of craziness
or read as....
It will have a fully-direct3D9 accelerated GUI, allowing all sorts of crashiness
It's got to be somewhere on the map!
Correction, it has now been identified as a part of the 'Super Supreme' Pizza Hut space program, with the cheese filled crust still intact.
Now the weather...
In my experience, coming off the caffeine for a few days restores my creative thinking when I'm stumped.
It lets my mind think laterally, around the problem, usually when I'm doing nothing at all.
Once the idea's start flowing, its back to work and back on the caffeine!
...I don't know about RailTrack employees (unless your house is leased by Railtrack, as they do own a huge amount of land and property), but I know that Gas Board and Electricity Board employees have a right of access to your property to inspect their metering equipment, even if it's inside your house, but they have no right to 'forced' entry without your presence.
The police (and customs officers) do have the right to access to your house, but not to search it, without a warrent. Anything evidence found without a warrent would be inadmissable in court. Obviously this is rarely used without a senior officers approval.
Interestingly, if you say 'no' to a TV Licencing people then they will just send you a summons to go to court, to appear before a judge who can fine you upto £4000 and may even imprison you!
Apart from that, the UK's a great place to live, but the weathers crummy!
All spelling mistakes are my own and do not represent the mistakes of my employer.
Burning rice?!!
Aww come on, it's not that hard to cook rice!
We're talking about 'star trek' style technology and we can't even boil water without cocking it up!
MS says they've "improved" the parsing speed of ASP vs HTML in W2K until there is no/little difference between them. Look up on MSDN / aspwire for more info. Not that your advice is not sound or correct. I'd still do the same (if/when) I migrate.
Dunno if the've stopped W3SVC crashing every two minutes tho!
Scunthorpe, North Linconshire.
Mod this up!
"If you can't measure, you can't manage!"
Remove Windows Scripting Host from your computer, and you should be fine! So far, the best tool to use to remove WSH is fdisk. WSH comes as default on Win98 and W2k. NT can get it, but it is not installed as default
Ha! See what that does to the lusers!
If the magnetic polarity flips, then I think the least of your problems will be having to reboot your PC...
trying to remember it from my Patrick Moore "Universe" book, thanks Mum for the xmas pressie...
Your right that planet is derived from the greek word wanderer. This is because the ancient greeks couldn't understand why when observed that most of the stars moved from right to left during the night but some didn't follow the same path, but moved (and wandered) across the sky, sometimes even moving backwards and looped across the nights sky!
In fact these stars where the now known planets orbit as observed from the earth etc etc etc.
The rest, as they say, I learnt on TV!
Hey! Did someone change /.
Can anyone try putting their display into Nested / Oldest First and see what they get?
(I might be putting my head in the lions month here but..) the formatting of the posts really screws up, starting half way across, with the "sections" panel in the centre (US center). then half way down it jumps over to the left.
OK - I'll admit to running IE5 *duck - flame attack*
Am I going mad? Can someone check please...
(BTW - Mozzilla 13 is surpisingly good! I've been keeping a sneakie eye on it and I recommend you check it out. Once they fix the proxy auth. then I'll ditch IE, I promise!!)
Everything you ranted about is illegal, and for very good reasons!
What if it was your daughter who was killed by a drunk driver speeding after running a red light! There are rules, that everyone must obey (and respect) otherwise NOBODY will have ANY freedom.
Please, think about it before you post.
My first *real* job was maintaining an inventory control system, on an IBM System/36, written in RPG.
In German!
It was bad enought that any comments were in German, and all accounting terms (stock on hand, out of order, balance) but RPG limited you to 6 or 8 character variable names. And it was someones bright idea that the first two characters were used to identify the program.
Then they used acroymns. Examples include GBKXA1 (always uppercase).
Above all that, RPG used indicators. These true/false 'flags' could be used to condition code, and 3 of these indicators could be concatenated on a single line.
Then you can set the indicators by placing it in columns from 60 to 65 (if I remember) based on the result field being zero, positive or negative.
Even better was the commenting function. RPG was (is) strictly column based. Place a * in column six and the line is a comment. How many times, when trying to work out what a program function was doing did I find that the code was in fact commented out.
Missing rule? Carefully hide open and close comment tags in the code
I was a good start to learn *what not to do* and the other guy's in the team taught me the basic's of maintanable code. Thankfully, I've forgotten most of it by now and work in the internet world where it seems obligatory to code in the most obtuse way as possible!!
Anyone want to lend him a tin of WD40?
(Sorry, had to be said!)
I think all the Linux developers can let out a huge sigh of relief that their baby doesn't run like a dog (as claimed by MS), but can and does keep up with the big boys! And thanks to MS, it can only get better!!!
I still feel that the test is still aiming at Linus's achillies heal, so to say. How about rerunning the test on the old '486 in loft' hardware that the real world has got rather then $40K kit MS rolled out!
And don't underestimate the 'come in over the weekend to reboot it' factor (from a previous thread, too lazy to look it up but it made me chuckle!) - we're all too busy chatting away to have to keep an eye on the kit every second.
(Sorry - Connection refused - MS Proxy Server 2 - Too busy - Please try later)