Correct on obj_num = 100, and 100 only.
You know, that Update almost looks too simple now that I see it. I will definitely test it out on one of my database copies and let you know how it works out for me. Thanks!
- the select part 'should' work with a return of only one row. There should only be one ip_addr = '192.168.100.100' in this stupid thing...
*okay maybe tomorrow (weds). One of the stores blew up today, and I spent the entire time rebuilding
*** Worked fantastically! Verified the select statement first to ensure just one row was being returned. Stuck it into my update script and it went through without any problems. Thanks much for the help!