>Didn't know about the free MySQL gui tool set! Thanks. Thru it's use I think I've determined that the issue is with a blank date. One of the values in the set statement is `dtCancel`=' - - '. In query browser this is causing the error 1292 (incorrect date value) to be thrown. I've been looking for a flag that may be set incorrectly but so far no luck. Again - this does not seem to be a problem in our production environment. I reviewed that information and my post yesterday was not quite right. In production we are running 5.0 while in dev we have 5.1. Suppose this would cause this error?

I don't have the luxury to test the two versions, but it sure seems like it's the problem! Interesting.