Macromedia dreamweaver 8-using dreamweaver User Manual
650
Chapter 29: Troubleshooting Database Connections
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
Data mode.
Data mode.
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:
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.
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
This section addresses one common error message that you might encounter when testing a
PHP database connection to MySQL 4.1: “Client does not support authentication protocol
requested. Consider upgrading MySQL client.”
PHP database connection to MySQL 4.1: “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 “Installing a PHP application server (Windows)” in Getting Started with Dreamweaver.
dynamic link libraries (DLLs). For detailed instructions, see “Installing a PHP application server (Windows)” in Getting Started with Dreamweaver.
Also see the following TechNotes on the Macromedia website:
■
TechNote c45f8a29 at
■
TechNote 16515 at
.