So, I have a test feed working - great. But how do you set up paging? It's not even addressed anywhere in the tutorials or in the manual. In the setup for a a feed such as picasa, you can tell it how many per page, but how do you get paging controls onto the page so you can see the next page of records?

Hello Steve,

Please watch the following video tutorial: Creating Custom Navigation for the Detail Region here: www.dmxzone.com/go/21863/html5-data-bindings#videos

Thanks Teodor, but this provides paging at the record level. I am having trouble getting paging working between lists of records.

For instance, my test page loads the first page of results as expected and shows how many pages of items there are:
www.cheeptrims.com/sandbox/test1.asp

Then, I've used the control HTML5 data bindings behavior to create an onclick event over the "next" paging label using action: Refresh Data, and a database action of "go to next page". This all seems very logical and straightforward, but it's not working. Am I still missing something??

Hi Steve,

What database are you using?

MS SQL

What is the version of SQL server?

2000, but soon to be 2008

I see, the issue is you are using a server technology older than 10 years, which is unfortunately not supported by Database Connector. As soon as you update to 2008 the issue will be gone .

I will be addressing this with the web host. Thank you.

I will be addressing this with the web host. Thank you.

I am having this same issue with mySQL. Can't set paging for lists of data.

My example is I have a database of 3900+ clients. I want to display 50 at a time. I can get the first 50 no problem but can't get pagination working no matter what I do.

Hello,

Please check the following tutorial: www.dmxzone.com/go/22082/paging-options-in-the-dmxzone-database-connector

Pageing is not working for me. I tried for hours with different examples ... here is a test page, what's going wrong?

testserver.swf.ch/swf2013/test3.php

Thanks for any help

Hello Andre,
Your setup is wrong currently your setup uses:

Which is control for a detail region, but you do not have a detail region on your page.
You should be using this kind of behavior for the 3 records on your page:

Ahhhh ok ... ... Gracias
Please extend your documentation ...

Well it is already explained in our tutorials.. www.dmxzone.com/go/22082/paging-options-in-the-dmxzone-database-connector

It's still not working ...

Please download the extension from our website and reapply it. This will fix the issue you are having,

I'm already using:

HTML5 Data Bindings
Version: 1.3.0
(c) 2013 DMXzone.com
@build 30-10-2013 10:57:31

Is there a newer one around?

Please download the Data Bindings and the Database Connector from our website and reinstall them.

When I had this problem earlier it was something I was doing wrong in the repeat region - not the paging. Since I figured out how to do it by following that tutorial very closely it has been working perfectly.

I reinstalled both extension and uploaded all new files but it's still not working ...

If you downloaded the latest version of the DMXzone Database Connector and HTML5 Data Bindings, the version of the following file should be 1.0.2:

Quote

ScriptLibrary/dmxDatabaseConnector/sqlBuilder.php

If after the update it is not 1.0.2 please reapply the extension on your page.

I've downloaded and installed the extensionagain. Deleted the sqlBuilder files and reapplied the extension. But still 1.0.1 is being added not 1.0.2

Got the same problem also. I've downloaded and installed the extensionagain. Deleted the sqlBuilder files and reapplied the extension. But still 1.0.1 is being added not 1.0.2

Do it again and now i solve it