|
|
|
|
In this 'how to' tutorial you will learn how to modify the NeXTensio list and form in order to add records that have the lowest order degree. This means that they will show up first in an ordered list.
For the purpose of this tutorial, you will use a simple database structure,
involving only a table, with the structure similar to the one presented
in the image below:
Note: The database diagram in the image above was built with MX Query Builder (also referred as QuB) to better illustrate the database structure. You do not need to build it in order to complete this 'how to' tutorial.
The table columns have the following signification:
id_crs - the course unique identifier, and primary key for the table.
name_crs - the course name (label).
order_crs - the course order. This is used when displaying the courses, to keep them in their intended order. It is a numeric field.
If you want to create a similar table structure, included in the zip package, in \tutorials\_HOW_TO\Insert records first\db\, you can find the database scripts, in sql and mdb formats.
For this tutorial, you will create only two files: one for the NeXTensio list (index), and one for the form that will allow inserting new records ( the NeXTensio list creates the empty file automatically).
Before you start working on the page, make sure you have a correctly
defined Dreamweaver site. Then you also
have to add a Dreamweaver database connection which will point to the
database containing the table shown above:
