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
Looper Wizard
The purpose of the Looper Wizard is to
create looped representations of recordset
content in a single operation. If you wish to create the list by putting
together the separate pieces, see Horizontal
Looper. Before applying it, make a selection in page.
The Looper Wizard is accessible from two
locations:
The MX Kollection tab
of the Insert bar.
The Application panel,
Server Behaviors -> + -> MX Kollection ->
Dynamic Lists -> Looper Wizard.
In order to add a horizontal looper into the page, you must follow the
next steps:
Create a recordset containing the data that you want
listed.
Drag and drop the recordset field you wish to display
from the Bindings panel to the design area.
Select the field and apply the Looper
Wizard.
The user interface looks like in the image below. To set the dialog
box options, follow the next instructions:
The Looper type drop-down
menu lets you select the order in which the records will be displayed
(horizontally or vertically):
In the Recordset drop-down
menu select the recordset you've already created and that contains the
data you want to list. If you have no recordset yet, you can use the Add recordset button and create one now.
The Show radio group
offers two possibilities:
· the first
option allows you to set the number of table rows and table columns that
will be used to list the data contained in the recordset (the number of
records displayed is the result of the multiplication between the two
numbers entered).
· the second
option leads to the display of all the records. Depending on the looper
type, only one of the text boxes above (rows,
columns) will be enabled.
The five buttons in the lower part of the interface
offer the following functionalities:
· The < Back / Next >
buttons are disabled as this wizard only has one step and you cannot navigate
back and forth.
· Click Finish when you are done configuring the wizard.
· Click Cancel to exit without the new settings to be
applied.
· The Help button brings you to this help page.
