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 6:58 am by neil.batchelor254136 | Last modified 10/07/2009 3:33 pm by neil.batchelor254136 | 4379 views | 19 replies

Eric Mittman

Before you can begin trying to implement DataAssist for the inserts and updates you will need to have your db structure defined.

Based on what you have posted I think you will need to have a userID column in the following tables:

3. Listings

6. Corporate Days
7. Inspirational Locations
8. Special Offers
9. Eating Places
10. Spa and Leisure

The following tables will need to have a column to hold the listing id:
4. Meeting Rooms
5. Rates

Once you have these tables properly crafted you will use DataAssist to generate a set of pages to manipulate the data in these tables. DataAssist does not incorporate your requirements for data integrity, this is something you will need to take care of in the design of your pages. For example since you would like to have only one listing per user you should do a check of the listing table for the current user to ensure that a record for that user does not already exist.

From the perspective of the user rite now it would go like this:

A new user registers
Once logged in the user can add a listing
On the insert page for the listing you will bind the id for the currently logged in user with the userID column you have in this table. This is the same for the other tables that have the userID column, it will be bound to the id for the currently logged in user.
After the listing has been inserted you will have the id for that listing record available from the session, you then make sure to reference this session variable for the listing id when inserting into tables 4 and 5.

Please post back with any questions that you have about creating the pages or using DataAssist to edit the insert and update statements. When you reply make sure to post questions about the functionality from the perspective of the end user that will be interacting with the pages, I find it much easier to address situations when questions are posed in this way.

As far as obtaining your files to evaluate and offer guidance that really goes beyond the scope of the support that can be offered. I can address specific questions about use and functionality of the tools, or how to implement certain features in the context of our tools but tutoring or guiding is not something that I can provide.

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