|
|
|
|
In this section of the tutorial you will build the page that will display a list of all courses in the database. The list will display the courses ordered by the order_crs field (as explained at the database description).
The page will be built using a NeXTensio list. To add the list, follow the next steps:
Open the index page in Dreamweaver.
Click on the Create NeXTensio List Wizard icon on the MX Kollection tab of the Insert panel, then configure each step of the wizard as explained in what follows.
In the first step of the wizard, you must set details concerning the table to display data from, and where the NeXTensio form is located:
In the Get data from drop-down menu, select the method for retrieving the data to display: from a pre-made recordset, or from a table. Select the Table option.
In the Connection drop-down menu, select the database connection used to access the courses table. Select the one you've created at the beginning of this tutorial (connInsertFirst).
In the Table drop-down menu, select the table containing the data to display: select courses_crs.
The Primary key column should be automatically selected in the drop-down menu (id_crs).
In the Detail page text field, you must decide where will the NeXTensio form be created. By default, it is in the form.php file.
In the Number of records
text field, enter the number of records to display (10).
When you have configured all user interface options, click on the Next button to advance to the second step.
In the second step of the wizard, you must decide which fields to display in the list. By default, the table primary key (the one selected in the first step of the wizard) is not displayed in the column grid.
In the List columns grid, select the order_crs column, then press the Minus (-) button on top of the grid. This will prevent the column from being displayed in the list.
Leave the settings for the name_crs
column at their default values, then click on Next
to move on to the third step of the wizard.
The third step allows you to define what element will be used as filter for each list field. Since the list will only display course names, which are plain text, you do not need to change anything in this step (by default, a text field is used for list fields). Then click on Next to move on to the wizard's last step.
In the last step of the wizard, you will define list-specific actions:
In the Move up/down column drop-down menu, select the order_crs column. This way, table records will be displayed according to the order defined by the user. Also, this will disable the Default order controls.
In the Duplicate buttons
and the Duplicate navigation drop-down menus,
select No. This will display navigational
arrows and insert/edit/delete buttons only in the lower part of the list.
Leave the rest of the fields at their default values (Yes).
Now click on Finish to close the wizard and add all elements to the page.
Now the list page is created, and you can move on and create the NeXTensio form.