General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only