the table "intenetConnections" has only 2 columns right now, and this code works as expected.
One of the engineers is testing a replication tool that adds a third column at the end of the table for a tracking ID.... when he adds this column my query no loger works. anyone have any ideas why this additional column would break this simple query?
Thanks weirdan! I forgot to mention that this has been tried, and it does work, but the problem is I have probably close to 300 different querys that this small change will affect, so I'd like to see if there is an easier way to fix the error than having to recode the querries