According to House Bill 17289, in preparation, programming loops will no longer be able to nest beyond two levels deep. It looks like this sucker's going to become law, so you'd better hope that your code gets grandfathered in.

In other news ... DBI won't prevent you from shooting yourself in the foot -- if you issue updates upon updates of the same row, it won't complain. Your DBMS might, on the other hand. It's up to you to ensure that your code's correct, here as nearly everywhere else.

Philosophy can be made out of anything. Or less -- Jerry A. Fodor

i took it out of the loop i removed the and statements and it works is there anything wrong with the and statements it works in sql manually i cant get it to work if there's even 1 and statement. i know someone who got it to work on the same system here with one and statement any ideas??