logo
Shopping Cart
No products selected.
Extensions

DW Extensions

Free Tools

Another Resources

Advanced Database Relational List

Frequently Asked Questions

Questions


Answers

I don't understand the database Query structure.

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:

Table faq_categories

id: the id of the categories.
category: the category name

Table faq_questions

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 is not working in the Live Preview.

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.

I have changed the authentication data of my database server. How I can to update the Database Relational List to connect to the database?

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 menu displays the text "loading..." but the options are never loaded?

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'

Where can I get the Adobe Extension Manager?

You can download the Adobe Extension Manager from the following page:

http://www.adobe.com/exchange/em_download/

About getting the download link after the purchase.

If you purchased the product using Google Checkout, the instructions for accessing your purchase will appear in a yellow box at the top of your Order Receipt page (into your Google Checkout account):



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. Please be sure to check your spam/bulk mail folder if you don't see the email into your inbox.

Setting writing permissions to a folder.

On Linux/Unix based webservers, FTP programs ("clients") allows setting permissions for files and directories on your remote host. This function is often called chmod or set permissions in the program menu.

Writing permissions is similar to "777" permissions or "rwx-rwx-rwx" permissions. You may see some of these representation in your FTP program.

On Windows based webservers the permissions should be set through the webhosting control panel.