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 :)

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.

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 :)

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.

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.

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!

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.