2 Replies Latest reply on May 13, 2006 8:16 AM by Newsgroup_User

    ANN: "Foundation PHP for Dreamweaver 8" - DW 8.0.2 updates

    Level 7
      Readers of "Foundation PHP for Dreamweaver 8" who have installed the
      Dreamweaver 8.0.2 updater, should visit the book's update page at

      http://foundationphp.com/dreamweaver8/updates.php#802updater

      I have posted details of changes resulting from the release of the 8.0.2
      updater. The main issues are as follows:

      * SQL queries that use MySQL functions may be corrupted (Adobe has
      confirmed this as a new bug).
      * Changes to the Advanced Recordset dialog box.
      * XSL Transformation server behavior fails in PHP 5.1.4 (not clear
      whether this is a Dreamweaver bug or a PHP one). Fortunately, there is a
      simple solution - Adobe has been alerted to the problem.

      I have also created new download files for Chapters 8 - 10 (Chapter 11
      will follow later). They will eventually be moved to the book's official
      downloads page, but can already be downloaded from the friends of ED
      forum at the following address:

      http://friendsofed.infopop.net/2/OpenTopic?q=Y&s=989094322&a=tpc&f=8033053165&m=7831083921 &r=5741045921#5741045921
      --
      David Powers
      Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
      Author, "Foundation PHP 5 for Flash" (friends of ED)
      http://foundationphp.com/
        • 1. Re: ANN: "Foundation PHP for Dreamweaver 8" - DW 8.0.2 updates
          Level 7
          David Powers wrote:
          > Readers of "Foundation PHP for Dreamweaver 8" who have installed the
          > Dreamweaver 8.0.2 updater, should visit the book's update page at
          >
          > http://foundationphp.com/dreamweaver8/updates.php#802updater
          >
          > I have posted details of changes resulting from the release of the 8.0.2
          > updater. The main issues are as follows:
          >
          > * SQL queries that use MySQL functions may be corrupted (Adobe has
          > confirmed this as a new bug).
          > * Changes to the Advanced Recordset dialog box.
          > * XSL Transformation server behavior fails in PHP 5.1.4 (not clear
          > whether this is a Dreamweaver bug or a PHP one). Fortunately, there is a
          > simple solution - Adobe has been alerted to the problem.
          >
          > I have also created new download files for Chapters 8 - 10 (Chapter 11
          > will follow later). They will eventually be moved to the book's official
          > downloads page, but can already be downloaded from the friends of ED
          > forum at the following address:
          >
          > http://friendsofed.infopop.net/2/OpenTopic?q=Y&s=989094322&a=tpc&f=8033053165&m=7831083921 &r=5741045921#5741045921
          >
          David,

          Will this affect pages prospectively? In other words, if I update to
          8.2 and then create the database and queries, will everything be just
          tickety boo and it's only already-created functions that are in jeopardy?

          Thanks for staying on top of this!


          --
          Bonnie in California
          kroko at
          sbcglobal dot net
          http://www.theanimalrescuesite.com/cgi-bin/WebObjects/CTDSites.woa
          • 2. Re: ANN: "Foundation PHP for Dreamweaver 8" - DW 8.0.2 updates
            Level 7
            Bonnie wrote:
            > David Powers wrote:
            >
            >> I have posted details of changes resulting from the release of the
            >> 8.0.2 updater. The main issues are as follows:
            >>
            >> * SQL queries that use MySQL functions may be corrupted (Adobe has
            >> confirmed this as a new bug).
            >
            > Will this affect pages prospectively? In other words, if I update to
            > 8.2 and then create the database and queries, will everything be just
            > tickety boo and it's only already-created functions that are in jeopardy?

            The 8.0.2 updater corrupts SQL queries that use the MySQL CONCAT()
            function. It doesn't matter whether they're existing queries or newly
            created ones; closing the recordset dialog box strips out CONCAT( and
            the closing parenthesis.

            I don't know if it affects any other MySQL functions. The only other one
            that I have tested is DATE_FORMAT(). Although 8.0.2 doesn't render the
            result of DATE_FORMAT() in the Test SQL Statement panel, it leaves the
            function itself untouched.

            --
            David Powers
            Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
            Author, "Foundation PHP 5 for Flash" (friends of ED)
            http://foundationphp.com/