A database refers to data organized and stored on a computer that can
be searched and retrieved by a computer program. Most industrial-strength
and many smaller database applications can be addressed using SQL (Structured
Query
Language).
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.
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.
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
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.
Delete Record Wizard
Deleting a certain record from a database
table can be done in a single operation using the Delete
Record Wizard, without having to manually retrieve its ID and build
the recordset.
The wizard adds a Delete Record server
behavior
to your delete page. To edit the server behavior, open the Server
Behaviors panel (Window -> Server Behaviors) and double-click the Delete
Transaction serverbehavior.
The Delete Record Wizard is accessible
from two locations:
The MX Kollection tab
of the Insert bar.
The Application panel,
Server Behaviors -> + -> MX Kollection ->
Forms -> Delete Record Wizard.
The purpose of this wizard is to build a page that enables users to
delete records from a database table. This wizard is divided into two
steps. To build the delete page with the Delete
Record Wizard, follow the next instructions:
Open the page in Design view,
and then apply the Delete Record Wizard.
A dialog box appears.
Complete the dialog box, following the instructions
below for each of the two steps:
· The
Basic tab
· The
Advanced tab
Click OK when done.
The Basic tab
The first step into completing the dialog box requires the user to input
basic information about the transaction, like the table to delete from,
the ID of the record to be deleted, and the page to which it will be redirected:
To set the dialog box options, follow the next steps:
In the Connection drop-down
menu select the database connection defined for your site; if you don't
have a connection yet, you can use the Define
button and create one now.
In the Delete from table
drop-down menu select the database table from which you want to delete
records.
In the Primary key column
drop-down menu specify the primary key column for the current table. The
content of this drop-down menu is refreshed each time the user changes
the table for the delete operation. By default, the first element is selected.
The Numeric checkbox
specifies whether the selected Primary key column
has a numeric type (integer, double, etc). The state for this checkbox
is altered each time the user changes the selected value of the Primary key column according to the meta-data retrieved
by Dreamweaver for the specified table column.
In the Primary key equals
drop-down menu select the way the record ID is passed to the delete page
(either URL Parameter, Form Variable, Cookie, Session Variable, Server
Variable, Entered Value), and type its name in the associated text-box.
In the First Check Variable
drop-down menu select which element should act as a starter condition
for the delete operation (either Primary key value, URL Parameter, Form
Variable, Cookie, Session Variable, Server Variable), and type its name
in the associated text-box.
Note: The form that performs the delete operation should have
the Method attribute set to POST,
not GET.
In the After deleting, go to
text box enter the page to be opened after the record is deleted or click
the Browse... button to select the file
page.
The three buttons in the top right corner 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 appear on both interfaces of the Delete
Record Wizard, so their role will not be explained again in the
next step.
Click on the Advanced
tab to continue with configuring the wizard.
The Advanced tab
This last step of the wizard requires the user to set some transaction
options:
To set the dialog box options, follow the next steps:
In the Transaction name
text box enter the desired name for the delete transaction. Be careful
when choosing it, because it has to be unique on each page. By default,
MX Kollection 3 assigns unique names to
each transaction, and this setting should not be changed, unless you really
know what you are doing.
After completing the user interface, click on the
OK button to apply the wizard, or Cancel to dismiss it without making any changes
to your page.
