Database Relational List Advanced
Suppose that you have two tables in a database that are related through a specific field. For example, the tables faq_categories and faq_questions:
A description of the fields:
id: the id of the categories.
category: the category name
id: the question's id
question: the question
answer: the answer to the question
category_id: the id of the category where the question is
The records of the table, faq_categories, are displayed in the main menu. So, the query is:
SELECT id alias value, category alias text FROM faq_categories
The "alias value" string, and the "alias text" are required to define the value and text for the menu options
The records of the table faq_questions are display in the subordinated menu, when an option is selected in the main menu. So, the query for the subordinated menu is:
SELECT id alias value, question alias text FROM faq_questions WHERE category_id=%s
The "alias value" string, and the "alias text", similar to the faq_categories query, are required to define the value and text for the menu options. Pay attention to the "WHERE" clause, "category_id=%s". The string "%s" will be replaced, in execution time, by the id of the category selected in the main menu.
The Database Relational List reads the menu options from a MySQL database, using PHP Script in the server side, to interact with the database. Be sure that you have the website defined correctly in the Adobe Dreamweaver application, with access to the database server and the web server with the PHP Script enabled.
Besides you can to publish the web page modified, and the db_relationallist folder to your public web server to check the Database Relational List in online mode.
After complete the insertion process of the Database Relational List a connection file is generated in "db_relationallist_advanced/connections". A connection file is generated for every pair of related menus. The connection file content is similar to the text below:
$hostname = "hostname or IP";
$database = "database name";
$username = "authentication user name";
$password = "authentication password";
You only must to update, in the connection file, the data modified in the database server.
The most common mistakes in the query entering are related with the clause "WHERE". The %s string is used as wildcard to be replaced by the correct value received from the web page.
Is very important that you know the data type of the field used for filter the database rows, if the data type of the fields is "CHAR", "VARCHAR", "DATE", "DATETIME" or another type represented as text, you must to enter the %s with the symbol (') around, as below:
SELECT id as value, name as text FROM users WHERE surname='%s'
Download the most recent version of the Adobe/Macromedia Extension Manager or the version related to your Dreamweaver version:http://www.adobe.com/exchange/em_download/
After installed open the MXP file from the Extension Manager menu to be sure that you are installing the extension using the correct Extension Manager.
After accessing that link you will get a copy of the product and a copy of the download link will be sent to your email address. If you have not received the email, please check your spam/bulk mail folder.
If you lost both download links, please contact our support service and we will send you a new download link. Please include the email used for payment in your message;
Moneybookers is accepted in almost all countries.
Please, change the "Links relative to" setting in the site configuration options (Dreamweaver 8 or later).
If this setting does not solve the problem, then follow these steps:
- Restart Dreamweaver
- Be sure that you have a local web site defined in Dreamweaver
- Open the page where you want to insert the extension(this page must be saved previously into your web site)
- Try to insert the extension again
We also accept MoneyBookers (accepts credit cards when uploading funds).
It's required to define a working site in Dreamweaver because Dreamweaver needs to know where to place the files.
Download here a PDF document with help about defining a site in Dreamweaver.
If you are testing your page directly from your local hard disk in IE 7, this message appears:
"To help protect your security, Internet Explorer has restricted this webpage from running scripts or ActiveX controls that could access your computer. Click here for options."
In IE 7 this message appears when you test a web page that contains a script or Flash item directly form your local hard disk. When you upload your page to an online web server that message does not appear.
The address from a web server must start with http:// or https:// . On the other hand if the address starts with C:\ or file:// then you are testing it from your local hard disk.
Just upload your web page to your web site and you will see that the error disappears.
- Check if you have defined a local web site at dreamweaver.
- Check if you have saved the page into your local web site.
- If you are using Dreamweaver templates, check if your templates allow an "Editable Region" in the <HEAD> section of the HTML code.
- Mark the "Use case-sensitive link checking" option in the site settings and recreate your site cache.
- After these checks, please restart your Dreamweaver and try again.
That's due to a bug in the Adobe Extension Manager that sometimes corrupts the "Menus.xml" file. That file can be found in the following location:
Windows users: C:\Documents and Settings\[UserName]\Application Data\Macromedia\Dreamweaver [version]\Configuration\Menus\menus.xml
Mac users: HD:Users:username:Library: Application Support:Macromedia:Dreamweaver [version]:Configuration:Menus:Menus.xml
To fix this problem close your Dreamweaver and try the following:
- Un-install all your extensions and then re-install them one at a time. This will work in most cases.
- If the above doesn't work then delete the "Menus.xml" file. After this you will need to disable and enable your extensions in order to get the menu entries again.
- If none of the above works then there is more than one file corrupted, the solution in this case will be to completely uninstall Dreamweaver and reinstall it again.