I'm working with a MySQL table via MySQL Front. I'm entering dates in a DATE field using the format provided (YYYY-MM-DD) and I click tab (or enter, I've tried both); the SQL pane shows that the record has been set. When I click the sort column, the dates that I have manually entered disappear completely and I'm left with the 0000-00-00 default. The data entered is just gone. Any idea why it's doing that?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Dates not taking
- Thread starter RikForgo
- Start date
sleipnir214
Programmer
What version of MySQL-Front are you running?
Want the best answers? Ask the best questions!
TANSTAAFL!!
Want the best answers? Ask the best questions!
TANSTAAFL!!
- Thread starter
- #3
sleipnir214
Programmer
As a first step, I'd upgrade. The author has ended his development hiatus and is working on this software again.
Want the best answers? Ask the best questions!
TANSTAAFL!!
Want the best answers? Ask the best questions!
TANSTAAFL!!
- Thread starter
- #5
Yep, I was entering the date format wrong, for example I was submitting 2004-29-03 when it should have been 2004-03-29. v2.5 simply wouln't take it, but v3.0 showed an error message that said it was entered incorrectly. Geez.
Thanks for the help.
Thanks for the help.
- Status
