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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Multiple records update and recordset paging

Thread began 3/17/2011 3:52 pm by sandy170299 | Last modified 3/18/2011 12:52 pm by Jason Byrnes | 2170 views | 6 replies |

sandy170299

Multiple records update and recordset paging

I'm not sure how to go about this. I have created a multiple records update page, but how can I add recordset paging to this? I can't use the built in dreamweaver recordset paging feature, because it requires a repeat region, and it won't work with the repeat selection server behavior. The recordset that I will be updating could contain as many as 500 records at a time, and that is just too many to display on the page at once. Hope I'm making sense :)

Sign in to reply to this post

Jason ByrnesWebAssist

the multiple record update behavior needs to have a _either_ a repeat region or repeat selection on the page.


this basically means that you need to set up the display of the multiple records including the Dreamweaver paging before applying the update record behavior to the page.

In other words, you can use the DW Paging controls, as long as you apply it before adding the update record behavior.

Sign in to reply to this post

sandy170299

Let me see if I understand this correctly... I would first create my recordset, then use the data assist repeat selection server behavior on the table row to output. How then would I specify a repeat region and number of records to show at one time? The instructions say to use the repeat region server behavior when updating multiple records, but that is incorrect. Ray said I need to use the repeat selection server behavior instead. Sorry, but now I'm confused :)

Sign in to reply to this post

Jason ByrnesWebAssist

sorry to confuse you, I thought it could use either.

when i try to add the DW Recordset paging controls to a page that only has the repeat selection on it, it will still add the controls, but give me a warning that it needs the repeat region.

really what this means is that there are two variable created by the repeat region that are missing


just before the recordset code, add the following:
$maxRows_<RecordsetName> = 5;
$pageNum_<RecordsetName> = 0;


where <RecordsetName> is the name of the recordset.

Sign in to reply to this post

sandy170299

Jason, I tried that, but it's not affecting the recordset at all. I'm going to zip the page to see if there is anything that jumps out at you.

Attached Files
WAERRORS.zip
Sign in to reply to this post

sandy170299

Jason, I just noticed that there were FOUR repeat regions on that page! I'm going to delete three of them and see what happens with the paging. That must have happened yesterday when Ray was trying to get the update multiple records server behavior to work.

By the way, the instructions for updating multiple records and deleting multiple records are wrong. It says use the repeat region server behavior, but the repeat selection server behavior is the one that is supposed to be used instead. That's why it wasn't working for me, FYI.

Well, even after deleting three of the four repeat regions, the recordset paging server behavior still doesn't work. Sorry!

Sign in to reply to this post

Jason ByrnesWebAssist

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

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