Adobe Dreamweaver CC 2015 - Manual (Page 565)

558
Dynamic sites, pages and web forms
Last updated 6/3/2015
• Using a space in the name.
The error can also occur when an input mask is defined for an object in the database, and the inserted data does not
conform to the mask.
To fix the problem, avoid using reserved words such as “date”, “name”, “select”, “where,” and “level” when specifying
column names in your database. Also, eliminate spaces and special characters.
See the following web pages for lists of reserved words for common database systems:
• Microsoft Access at http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209187
• MySQL at http://dev.mysql.com/doc/mysql/en/reserved-words.html
[Reference]80040e21—ODBC error on Insert or Update]
This error occurs when the server tries to process a page containing an Update Record or Insert Record server behavior.
The database cannot handle the update or insert operation the server behavior is trying to perform.
Here are possible causes and solutions:
• The server behavior is trying to update a database table’s auto-number field or to insert a record into an auto-
number field. Because auto-number fields are populated automatically by the database system, any attempt to
externally populate them with a value fails.
• The data the server behavior is updating or inserting is the wrong type for the database field, such as inserting a date
into a Boolean (yes/no) field, inserting a string into a numeric field, or inserting an improperly formatted string into
Date/Time field.
[Reference]800a0bcd—Either BOF or EOF is true]
This error occurs when you attempt to view a dynamic page in a web browser or in Live view.
The problem occurs when the page tries to display data from an empty recordset. To solve the problem, apply the Show
Region server behavior to the dynamic content to be displayed on the page, as follows:
1 Highlight the dynamic content on the page.
2 In the Server Behaviors panel, click the Plus (+) button and select Show Region > Show Region If Recordset Is Not
Empty.
3 Select the recordset supplying the dynamic content and click OK.
4 Repeat steps 1 to 3 for each element of dynamic content on the page.
Troubleshooting MySQL error messages
One common error message that you might encounter when testing a PHP database connection to MySQL 4.1 is
“Client does not support authentication protocol requested. Consider upgrading MySQL client.”
You may have to revert to an earlier version of MySQL, or install PHP 5 and copy some dynamic link libraries (DLLs).
For detailed instructions, see .
Removing connection scripts
Note: The user interface has been simplified in Dreamweaver CC and later. As a result, you may not find some of the
options described in this article in Dreamweaver CC and later. For more information, see
this article .