Viewing 15 posts - 55,831 through 55,845 (of 59,078 total)
And, just in case anyone is curious about how much the function will slow things down...
--===== Find a safe place to do this test using "real tables" because...
July 12, 2007 at 8:31 pm
There IS a single magical update and you sure don't need a cursor ![]()
First... here's a little test data to play with as you...
July 12, 2007 at 7:53 pm
Carsten,
Thanks for the detailed feedback. Hard to believe that someone has that particular attitude.
July 12, 2007 at 7:08 pm
Thanks for the confidence, Bledu... not sure it would do any good, though... if I were to give a general example, someone would fail to apply the knowledge to a...
July 12, 2007 at 7:06 pm
So, Hickymanz... any feedback on the code I provided?
July 12, 2007 at 7:05 pm
No... wasn't talking about external security... it's an internal security risk that would fail a PCI audit.
July 12, 2007 at 6:24 am
Heh... that'll teach me to read the question correctly
I labled the nodes 180 out ![]()
July 11, 2007 at 10:13 pm
Generous but I'm curious... why would you pay someone $100 to write code and post it on a public/free forum? Hate to look a gift horse in the mouth, but...
July 11, 2007 at 9:39 pm
They also allow user name and password in clear text... a security risk, for sure. ![]()
July 11, 2007 at 9:03 pm
Sorry... got carried away having fun ![]()
For the format similar to what you ultimately requested... feel free to tweek it... includes a column with...
July 11, 2007 at 8:59 pm
Heh... see what happens when you provide just the right amount of data and a table definition to go along with a good description
July 11, 2007 at 7:50 pm
Look at it this way... they're all flaming one thread and leaving the others alone ![]()
July 11, 2007 at 5:39 pm
That's referred to as a "sequence table" and it one of the things that was suggested. But, you must be VERY careful how you do the update to it or...
July 11, 2007 at 5:37 pm
Can you get them to reverse the process? Seems to me that the data table should be there completely befor the trigger table that says it is.
July 11, 2007 at 5:34 pm
Viewing 15 posts - 55,831 through 55,845 (of 59,078 total)