 |
|
Updating the table of users in the database
You add an Insert Record server behavior to update the database table of site users.
To update the table of users in the database:
| 1 |
In the Server Behaviors panel (Window > Server Behaviors), click the plus (+) button and choose Insert Record from the pop-up menu. |
|
The Insert Record dialog box appears. |
|
|
|
|
|
|
|
|
| 2 |
Use the Connection and Insert Into Table pop-up menus to specify the table of users in the database. |
| 3 |
In the "After Inserting, Go To" box, enter the page to open after the record is inserted into the table. |
| 4 |
In the Get Values From pop-up menu, choose the HTML form used to obtain the user's user name and password. |
| 5 |
Specify what each object on your form will update in the database table by selecting a form object in the Form Elements list, then choosing a corresponding table column from the Column pop-up menu and a data type from the Submit As pop-up menu. |
|
The data type is the kind of data the column in your database table is expecting (text, numeric, Boolean checkbox values). Password or user name columns usually expect text. |
|
For example, in the Form Elements list, click the password text field, choose the column in the database table where the password should be stored, and then choose the Text data type. |
|
|
|
|
|
|
|
|
|
Repeat the procedure for each form object in the Form Elements list. |
| 6 |
Click OK. |
|
|
The final step is to make sure the user name has not been selected by another registered user.
|
|
|
|
