|
|
|
|
In this 'how to' tutorial you will learn how to replace numeric values that are retrieved by a NeXTensio list from a table with custom text. The NeXTensio list you will build in the following pages will allow managing the users of a site, each having its own attributes: name, password, access level. The access levels are stored as numbers (0 for users and 1 for administrators). However, to ease understanding, the list will have to display the textual description of a level instead of the actual value (e.g. for 0 it will have to display "User").
In order to complete this tutorial, you must have NeXTensio installed, either as a separate product, or as part of the MX Kollection bundle.
The database structure used in this tutorial is fairly simple and common
amongst sites that have user authentication. It only uses one table (user_usr) with the structure depicted 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.
To quickly create the database structure, you can use the scripts provided in the \tutorials\_HOW_TO\Replace values in NeXTensio list\db\ folder of the zip package, either .sql or .mdb, corresponding to your database server.
For this tutorial you will create only one file: the site index. This will contain a NeXTensio list displaying all entries in the database. Create this file right after defining the site, so you can use it later at ease.
Before you start creating the actual page, you must first create a Dreamweaver database connection, and configure it to connect to your database server. Open the page you've created above, and define a new database connection. Make it point to the database containing the table described above.