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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Update Multiple Records - Bindings value drop down empty

Thread began 2/01/2017 8:39 am by Justin@AdventDesign | Last modified 2/02/2017 4:17 pm by Ray Borduin | 194 views | 5 replies |

Justin@AdventDesign

Update Multiple Records - Bindings value drop down empty

I'm following the multiple records update tutorial from Frank Jay. I can go through everything just fine save for one issue... On the bindings values, the drop downs are empty so I can't select the value the record should be updated with. I've made sure to swap out the generic DreamWeaver repeat region for the WebAssist repeat region so that doesn't appear to be the problem. Page attached. Repeat region in question starts at line 392.

Attached Files
tbl_master_results_update.php
Sign in to reply to this post

Ray BorduinWebAssist

Your input tag isn't closed. You have:
<td class="WADAResultsTableCell"><input name="multi_publish" type="text" value="<?php echo($row_WADAtbl_master['publish']); ?>"</td>

it should be:
<td class="WADAResultsTableCell"><input name="multi_publish" type="text" value="<?php echo($row_WADAtbl_master['publish']); ?>"></td>

Sign in to reply to this post

Justin@AdventDesign

Doh!

*Face palm* - Sorry for the wasted time. Should have more carefully checked the basics!

Sign in to reply to this post

Justin@AdventDesign

Hmm... that fixed that part but it's still not updating...

OK not wanting to be caught with another stupid mistake, I’ve gone round and round with this thing checking everything I can think of. After fixing the closing tag, I was able to select the proper value from the drop down menu. However, updating fields and pressing the button does not update the database. The animated processing gif runs, and the page is redirected (I have it set to redirect after the update) so I know it’s running the multiple update code.

I’ve gone through the tutorial 3x:
- Verified data assist repeat selection, verified sequential numbering is working by checking code view
- Verified proper settings in the Update Multiple dialogs including individual bindings
- And yes, I moved the Update Multiple PHP code above the recordset request.

The only thing different I’ve done is set the repetitions to ALL rather than a limit, as I want the entire recordset displayed on one page regardless of length.

How do I go about debugging further?

Attached Files
tbl_master_results_update.php
Sign in to reply to this post

Ray BorduinWebAssist

The server behavior was supposed to create a hidden form element in your repeated region to keep track of which record to update. It appears that wasn't created. It might have something to do with the original problem while inserting the behavior since it only creates it the first time.

It is probably easiest to correct the problem manually at this point. Just add this somewhere inside your repeated content:

<input type="hidden" size="1em" name="WADA_RepeatID_id_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo($row_WADAtbl_master['id']); ?>">

Sign in to reply to this post

Justin@AdventDesign

That did it!

Thanks Ray. Just to note for anyone else that finds the above helpful, it should be <input type="hidden"... as you don't want the ID field updatable.

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