Problems with recordset in PHP/MySQL setting

[ilsescheys]

We use Dreamweaver CS5 for creating dynamic pages (PHP pages with MySQL database). We test the site locally on a Windows 7 operating system with EasyPHP as WAMP server.

We often have a problem in managing the record set.

The following problem occurs quite often:

We take a PHP page. We create a recordset. We use a dynamic table or a repeated region to show the results of the recordset. So far so good.

Then we want to change something to the recordset for example the filter. When editing the recordset, the advanced mode is shown, it is impossible to swith to the simple mode.

By deleting the recordset the problem is not solved. By deleting and afterwards rebuilding the recordset, syntax errors occur. It seems that the php code for building the recordset didn't dissapear.

The only solutions till now seems to completely restart with a new PHP page.

Anyone has a solution for this or anyone did experience the same problem ?

Thank you very much in advance.

Ilse 

[David_Powers]

You cannot switch to Simple mode in the Recordset dialog box if you have made any changes to the SQL in Advanced mode.

Opening the Recordset dialog box to edit the settings does occasionally result in the code being inserted again instead of being changed. This appears to be an intermittent bug, which I have experienced myself, and know that others have complained about it, too. As far as I know, there is no solution other than to watch carefully the code that Dreamweaver generates.

If you don't understand the code, you would be well advised to learn what it means and does. Relying on Dreamweaver to do everything for you severely limits what you can do with PHP/MySQL. Adobe regards the server behaviors as quick prototyping tools, rather than for developing production websites.