close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Did I miss it

Thread began 1/01/2012 11:44 am by newimage96814918 | Last modified 1/03/2012 5:34 pm by newimage96814918 | 484 views | 4 replies |

newimage96814918

Did I miss it

I'm wondering if I just missed it with the wealth of info here about dataassist or not, But anyway is there a way with dataassist to insert into multiple tables, one form and such?
When I used to use ADDT they had a insert into two table wizard, that would work under maost circumstances, and a trick of creating two inserts, tying the forms together and setting some triggers. I just started using dataassist and will be using similar features so i'm trying to get ready, are there any solutions or tutorials for doing somthing similar with datassist.
Also I've been trying to find more info on the manage relational data behavior(not sure if that is where i'm going) but I have'nt really found to much to explain that yet.

Any comment's are appreasiated!

Sign in to reply to this post

Jason ByrnesWebAssist

yes, you can insert to multiple tables by adding multiple insert record behavior to the page.

Open the server Behaviors panel (Window -> Server Behaviors), click the plus button and select DataAssist -> Insert -> Single Record Insert.


On the first page of the insert record behavior, Look in the session variable section, make sure the Primary Column for your table is selected in the Key Column and make note of the "Store As" setting. A session variable with the name set in the Store As section will be created when the record is inserted with the ID of new record.

On the second page of the insert behavior, select each column, click the lightning bolt next to value and select the corresponding form element from the dynamic data bindings.

when adding the second insert behavior, you can use the session variable created by the first behavior in the relationship column of the second table.

Sign in to reply to this post

newimage96814918

Thanks Jason!
Would that work the same way if you wanted to insert from the same form, would you just make sure they are both in one form and set the primary to make session and that to the id of the next?

Sign in to reply to this post

Jason ByrnesWebAssist

yes, that is correct.

Sign in to reply to this post

newimage96814918

Thanks Jason!

Sign in to reply to this post

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...