close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Inserting records into Multiple Tables at one with DataAssist is this possible

Thread began 8/24/2009 3:58 am by neil.batchelor254136 | Last modified 10/07/2009 12:33 pm by neil.batchelor254136 | 9804 views | 19 replies

Eric Mittman

Using DataAssist you can insert a single record or multiple records. A single DataAssist insert server behavior will only insert data into a single table, however you can have as many of these on a page as you need to do all of your inserting.

For example, if on a single page you would like to insert into the multiple tables using the id from the first table to record as the foreign key on the other tables you would do so like this:

create the page and form to gather the info from the user. If you use the wizard you will need to specify the first table and the page that is created will only contain form elements for that table. Next you would update this page by adding in the additional form elements that you would need to record the information you want to insert into the other tables.

Once the form elements are in place you will need to add in the additional DataAssist Insert server behaviors. You will need one of these for each table you wish to insert into. You can also use the insert multiple for a table where you need to insert multiple records.

By default the form elements will be text inputs, you can update these to be checkboxes though. It will always use the text inputs as the default input type.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...