|
| |
|
|
VanessaBurgess
Posts: 5
Joined: 2/29/2008
Status: offline
 |
CS3 - Sending data to Access database from Form - 5/20/2008 13:44:54
Can anybody help me with this please or point me in the right direction ..
Connection fine and am able to retrieve data but ....
How do I add data to the Access database using a simple form?
Thanks
|
|
|
|
mar0364
Posts: 3091
Joined: 4/5/2002
From: Florida, US
Status: offline
|
RE: CS3 - Sending data to Access database from Form - 5/20/2008 16:43:14
This should do it for you.
Link
Build the insert page in one operation
Open the page in Design view, and select Insert > Data Objects > Insert Record > Record Insertion Form Wizard.
In the Connection pop‑up menu, select a connection to the database. Click Define if you need to define a connection.
In the Insert Into Table pop‑up menu, select the database table into which the record should be inserted.
If you use ColdFusion, enter a user name and password.
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.
If you use ASP.NET, you can specify a page to go to on success, and a page to go to on failure. Or you can choose to display debugging information upon failure.
If you select Display Debugging Information On Failure, Dreamweaver ignores the On Failure, Go To option.
Use the Display Debugging Information On Failure option during development and use the On Failure, Go To option when your page is live.
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.
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.
If you use ASP.NET, you can choose to use web form control.
Click OK.
Dreamweaver adds both an HTML form and an Insert Record server behavior to your page. The form objects are laid out in a basic table, which you can customize using the Dreamweaver page design tools. (Make sure all the form objects remain within the form’s boundaries.)
To edit the server behavior, open the Server Behaviors panel (Window > Server Behaviors) and double-click the Insert Record behavior.
_____________________________
Easy Web
“Stay committed to your decisions, but stay flexible in your approach.”
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
