close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Multiple Insert issue

Thread began 9/14/2017 3:25 pm by iain331081 | Last modified 10/04/2017 1:48 pm by Ray Borduin | 61 views | 9 replies |

iain331081

Multiple Insert issue

I have a page with an multiple insert that just needs to insert values into two fields - but one doesn't seem to be inserting.

I've looked at anything obvious for typos, wrong references, but can't see what's wrong.

Probably something I should have spotted, but haven't...

I have attached a copy of the page here.

Thanks for having a look.

Sign in to reply to this post

Ray BorduinWebAssist

It looks like you have edited the code by hand to set the voelu of the ItineraryIDPL field to $EnquiryID on line 300. However, the value of $EnquiryID isn't set anywhere on the page.

Sign in to reply to this post

iain331081

Thanks Ray - see it now. Should have been $ItineraryID, which hadn't been set either - added that and its all working now.

Sign in to reply to this post

Patrice

Hi iain331081:
I just had a client ask for this and I am totally lost where to begin.
Working on a back end admin for entering information into database. Only 2 fields needed. However, she needs to enter 30 at a time, so doing one by one is annoying. So I want to set up the WA Insert page to contain 10 or so to populate the database. If you don't mind, can you point me in the right direction? I tried putting the information field into a table, and then tried the repeat table in WA, but that didn't work. I tried, just duplicating the two fields and that didn't work. I can't apply the repeat region as that needs to reconnect, so I'm at a loss. Any help you can give me would be so very appreciated.

Updated: I found the tutorial and learned quite a bit concept-wise. That is helpful but I haven't yet learned the relationship of the insert page to the form submission sample in the tutorial. And just trying to use a form, I haven't been successful in populating the database, but at least I'm closer.

Sign in to reply to this post

Ray BorduinWebAssist

Yes, I was going to point you to the tutorial. If you are close and just stuck, post your page here and I can take a look to see if I can spot what you are doing wrong. FTP information and a URL to reproduce is an even better option to let me debug your issue.

If all else fails and you are in a hurry, I can help you get this done in a premier support ticket.

Sign in to reply to this post

Patrice

Thanks Ray. I was just working with a test one, not the actual. I will start fresh tomorrow with it. But one hint please: Do I use the "insert" DA page as the start, or just make a new page with a simple form and apply all the steps to that, as the tutorial shows? I used the test one and thought I had it right, but the data never got to the database. But I'll try again.

Thanks!

Sign in to reply to this post

Ray BorduinWebAssist

I'd follow the tutorial directly instead of using the DA insert page.

Sign in to reply to this post

Patrice

Success!

Sign in to reply to this post

Ray BorduinWebAssist

I'm glad it worked out. Multiple updates and inserts are a bit confusing, which is why we created the tutorial, but once you do a few you can get the hang of it.

Sign in to reply to this post

Patrice

Client thinks I walk on water now. :-)
Thanks again.

Sign in to reply to this post
loading

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