A server behavior is a reusable component for server-side development.
They add blocks of code to your pages for accomplishing specific tasks.
Dreamweaver comes with several default server behaviors and the InterAKT
extensions add many more to this list.
A recordset is the result of executing an SQL query.
It is composed of multiple rows, each row having multiple columns. The
columns presented in the query result depend on the column list declared
in the query (they can belong to different tables). The number of rows
and their order depend on the query conditions (WHERE, GROUP BY, HAVING,
ORDER). The recordset acts as a source of dynamic
data
in web applications.
A query is a SQL command that will extract information from the tables
of a database. Essentially, a query is a request for information from
your database.
The InterAKT Dynamic Data tool is a replacement for the standard dynamic
data dialog. It is used in the MX Kollection 3, to provide a unified way
of building mark-ups, or place holders. These are recordset fields, server
or session variables, and other types of dynamic data that are replaced
at runtime by their corresponding values
Configure Dependent Drop-down
The Dependent Drop-downserver
behavior
allows the web developers to include dependent drop-downs in their site
pages. Before applying it, there must be at least one recordset
(for the detail form item) created in the Dreamweaver
page, and two list/menu items inserted.
Also, the master form item must have values associated to it (either
dynamically, through another recordset, or statically). To do this, select
the master list/menu item in your Dreamweaver
page and use the Property Inspector to associate
values to it:
This server behavior is accessible from the Application
panel, Server Behaviors -> + -> MX Kollection
-> Form Controls -> Dependent Drop-down.
The user interface has two tabs. Directions about their correct configuration
are given below.
To set the dialog box options for the first tab, follow the next steps:
In the Master
field drop-down menu select the form element that has the
master role.
In the Detail
field drop-down menu select the form element that has the
detail role. The content of this drop-down menu depends on the selection
you made in the above drop-down menu.
The three buttons on the right of the interface offer
you the next functionalities:
· Click OK when you are done configuring the server behavior.
· Click Cancel to exit without applying the new settings.
· The Help button opens this help page.
These buttons are common to both tabs of the
Dependent Drop-downs server behavior interface.
Click on the Dynamic
tab to continue with configuring the server behavior.
To set the dialog box options for the second tab, follow the next steps:
In the Recordset
drop-down menu select one of the recordsets defined in your page.
The selected recordset should contain the data that you want displayed
in the detail form item when using the dependent drop-downs.
In the Primary key drop-down
menu specify the primary key field of the current table.
In the Foreign key drop-down
menu specify the foreign key field that will be the link to the master
recordset.
In the Get
labels from drop-down menu select the table field that stores
the names you want to be shown in the menu.
In the Default value
text box enter a starting value for the dependent drop-downs. You can
also select it from one of the available recordsets in your page by using
the lightning icon on the right.
Click OK when you are
done configuring the server behavior.