Looper Wizard

The purpose of the Looper Wizard is to create looped representations of recordset A recordset is the result of executing an SQL query 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.. 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 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 in web applications. 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:

1. Create a recordset containing the data that you want listed.
2. Drag and drop the recordset field you wish to display from the Bindings panel to the design area.
3. 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:

1. The Looper type drop-down menu lets you select the order in which the records will be displayed (horizontally or vertically):
   
   
                                                        
2. 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.
3. 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.
4. 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.