DATE_FORMAT() problem was with my data, not 8.0.2 updater
May 14th, 2006
When the Dreamweaver 8.0.2 updater came out, I originally reported that it mishandles the MySQL DATE_FORMAT() function in the Test SQL Statement panel. After further testing, and some help from Alexandru Costin of InterAKT, I’ve discovered the problem was with the dates in a test table that I was using. Oops!
The dates had been entered incorrectly into the test table, so the actual values were 0000-00-00 00:00:00. No wonder that DATE_FORMAT() wasn’t able to convert them. However, the nasty problem with Dreamweaver 8.0.2 corrupting SQL queries that use CONCAT() has been confirmed by several people. Let’s hope it gets fixed soon.
Entry Filed under: Dreamweaver, MySQL
4 Comments
1. Thomas | August 11th, 2006 at 2:48 pm
OFF TOPIC:
can fix it.
Are you the author of the Lorem and More extension for Dreamweaver?
If yes, please contact me - there’s a bug with Dreamweaver 8, and I want to discuss how we (you or I
Thanks.
2. David | August 11th, 2006 at 2:58 pm
Yes, I created Lorem and More - and it works just fine with Dreamweaver 8.
3. Lance | March 19th, 2007 at 4:01 pm
David,
I’m having a similar problem with Lorem & More in DW 8. What is happening is that the “Okay” and “Cancel” buttons do not show up, thus leaving no way to insert the paragraphs.
I have a screenshot if you’d like to see what I’m seeing.
Thanks
4. David | March 19th, 2007 at 4:16 pm
Lorem & More works fine in Dreamweaver 8. I know exactly the problem that you are referring to. It has nothing to do with my extension, but a bug in Dreamweaver that the engineering team fixed when I drew their attention to it. I can’t remember when it emerged, but it was a long time ago, and there’s definitely no problem in Dreamweaver 8.0.2.
If I remember correctly, the bug prevented the OK and Cancel buttons being displayed if you accessed Lorem & More from the Insert menu, but they appeared normally if you used the icon on the Common tab of the Insert bar. Or it may have been the other way round.
Trackback this post