Operation Manual

591
USING DREAMWEAVER
Building applications visually
Last updated 3/28/2012
5 Specify a database column to insert the record in, select the form object that will insert the record from the Value
pop-up menu, and then select a data type for the form object 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 option values).
Repeat the procedure for each form object in your form.
6 In the After Inserting, Go To box, enter the page to open after the record is inserted in the table or click the Browse
button to browse to the file.
7 Click OK.
Dreamweaver adds a server behavior to the page that lets users insert records in a database table by filling out the
HTML form and clicking the Submit button.
Build the insert page in one operation
1 Open the page in Design view, and select Insert > Data Objects > Insert Record > Record Insertion Form Wizard.
2 In the Connection pop-up menu, select a connection to the database. Click Define if you need to define a
connection.
3 In the Insert Into Table pop-up menu, select the database table into which the record should be inserted.
4 If you use ColdFusion, enter a user name and password.
5 In the After Inserting, Go To box, enter the page to open after the record is inserted into the table or click the
Browse button to browse to the file.
6 In the Form Fields area, specify the form objects you want to include on the insert page’s HTML form, and which
columns in your database table each form object should update.
By default, Dreamweaver creates a form object for each column in the database table. If your database automatically
generates unique key IDs for each new record created, remove the form object corresponding to the key column by
selecting it in the list and clicking the Minus (-) button. This eliminates the risk that the user of the form will enter an
ID value that already exists.
You can also change the order of the form objects on the HTML form by selecting a form object in the list and clicking
the up or down arrow on the right side of the dialog box.
7 Specify how each data-entry field should be displayed on the HTML form by clicking a row in the Form Fields table
and entering the following information in the boxes below the table:
• In the Label box, enter a descriptive label to display beside the data-entry field. By default, Dreamweaver displays
the table column’s name in the label.
• In the Display As pop-up menu, select a form object to serve as the data-entry field. You can select Text Field, Text
Area, Menu, Checkbox, Radio Group, and Text. For read-only entries, select Text. You can also select Password
Field, File Field, and Hidden Field.
Note: Hidden fields are inserted at the end of the form.
• In the Submit As pop-up menu, select the data format accepted by your database table. For example, if the table
column only accepts numeric data, select Numeric.
• Set the form object’s properties. You have different options depending on the form object you select as your data-
entry field. For text fields, text areas, and text, you can enter an initial value. For menus and radio groups, you open
another dialog box to set the properties. For options, select the Checked or Unchecked option.
8 Click OK.