Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Pagination doesn't work for my DataAssist pages

Pagination doesn't work for my DataAssist pages

Thread began 4/28/2016 11:38 am by Yvonne | Last modified 6/24/2016 12:41 pm by Ray Borduin | 1409 views | 7 replies |

4/28/2016 11:38 am | #1 Yvonne

Pagination doesn't work for my DataAssist pages

I have used DataAssist to build search, update, detail, results pages (php) and the search works but pagination does not. When clicking the next page button the results page refreshes but there are not results found, 1st page is 1-20 of 71 records, pages 2 and 3 show now records [cap_results3.php?pageNum_WADAcapturepages=2&totalRows_WADAcapturepages=0&userName=&userEmail=&userBrokerid=&Search=Search]. Please let me know what needs to be done to get pagination working.

Attached Files

cap_results3.php

4/28/2016 2:20 pm | #2 Ray BorduinWebAssist

I'd have to debug it, but maybe the repeated recordset code is causing issues.

Try deleting the code on rows 160-210 and see if that fixes it. If not, please post a url where I can see the page and FTP access if possible and I'll debug it directly.

Did this help? Tips are appreciated...

4/28/2016 3:03 pm | #3 Yvonne

Reply in PM

4/28/2016 3:27 pm | #4 Ray BorduinWebAssist

The code that builds the next page link was too high on the page... it needs to be below the recordset, so I moved it to lines 167-183. The page appears to be working now. Just get the version I uploaded.

Did this help? Tips are appreciated...

4/28/2016 3:32 pm | #5 Yvonne

That is awesome, thanks!!

6/23/2016 12:32 pm | #6 Yvonne

I had to rebuild the pages, we added new fields, and the same problem cropped up again. I cannot see the code you moved in the previous file in the current results page. I cannot see where the function executes prior to the record set.

6/23/2016 4:18 pm | #7 Ray BorduinWebAssist

Move lines 53-69 down below line 183... just before the <!doctype html>

Did this help? Tips are appreciated...

6/24/2016 9:53 am | #8 Yvonne

Thanks, works like a charm. I really appreciate your help.

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.