get rid of "or die(mysql_error())"

It's a bad practice to echo all of one's mysql errors to the screen, since it gives away a lot of information about the structure of your database to hackers. I've taken to commenting out this string. This has the unfortunate effect of making it so that DW won't recognize recordsets or behaviors, which makes it hard to work on the page usefully. Any chance you could make an extension that would let DW parse recordsets and behaviors even when the echoing of the mysql errors has been turned off?

Rather than making code modifications, I would recommend setting the php setting display_errors to off. This will prevent any messages from being written out to the page. It is recommended to hide error messages on a live production server like you said.

If you have access to the php.ini, you can change the setting there. Otherwise this line of php should also work:

ini_set('display_errors', 'off');

-justin

I have errors set to off, but when you tell it die(mysql_error), it overrides that.

I'll add that functionality to the next version of DataAssist, so that you can remove the or die(mysql_error) manually. Unfortunatly Dreamweaver will always add it back when you edit the recordset so you may have to remove it repeatedly.

I have attached the "fix" for this issue. Just unzip and place the .edml file in your configuration/server behavoirs/php_mysql/ directory and it should allow you to remove the die statement and still recognize the recordset. If you have dataassist you can replace the file that is already there.