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

Pagination doesn't work for my DataAssist pages

Thread began 4/28/2016 2:38 pm by Yvonne | Last modified 6/24/2016 3:41 pm by Ray Borduin | 130 views | 7 replies |

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
Sign in to reply to this post

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.

Sign in to reply to this post

Yvonne

Reply in PM

Sign in to reply to this post

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.

Sign in to reply to this post

Yvonne

That is awesome, thanks!!

Sign in to reply to this post

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.

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post

Yvonne

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

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