close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

I need to insert into 2 tables and insert the primary id of one into the other as well how can I do this using webassit ?

Thread began 5/18/2018 11:06 am by Web Manager | Last modified 5/21/2018 11:53 am by Ray Borduin | 1270 views | 5 replies |

Web Manager

I need to insert into 2 tables and insert the primary id of one into the other as well how can I do this using webassit ?

I need a user to be assigned to specific groups for login purposes in a SAAS Format. So I need a form that will allow me to insert info into the login table and include the account record id as well. Does this make sense ?

Sign in to reply to this post

Ray BorduinWebAssist

You can apply multiple insert record server behaviors on the same page to account for this. Exactly how you do it depends on your user interface and how you want it to work, but it should be possible either with the native MySQLi server behaviors or possibly it will require the Data Bridge Beta depending on the complexity.

Sign in to reply to this post
Did this help? Tips are appreciated...

Web Manager

would I be able to create a custom session and get the primary id of one of the insert table and include it in the second table on insert ?

Sign in to reply to this post

Ray BorduinWebAssist

There is already a setting to save the insert id into the session in the user interface. Just make sure the inserts are applied in the correct order on the page and the session variable will be available.

Sign in to reply to this post
Did this help? Tips are appreciated...

Web Manager

Will each insert require its own submit button ? Or will one submit button initiate all the inserts in top to bottom order ?

Sign in to reply to this post

Ray BorduinWebAssist

You can use the same submit button trigger for all of them.

Sign in to reply to this post
Did this help? Tips are appreciated...

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