Subtotal: $95,472.00
I have managed to find info in the videos on how to set paging up in the Visualizer when the data source is SQL.
Select * from ( Select ROW_NUMBER() over (order by ID) as rownum, * from members WHERE categories like'%[SelectCategory]%' ) as x Where rownum between [StartRecord] and [EndRecord] Order by Member
I would like to change the number of items per page to be 20...
How can I accomplish that??
Please specify 20 on the place of [EndRecord] token in the query:
Select * from ( Select ROW_NUMBER() over (order by ID) as rownum, * from members WHERE categories like'%[SelectCategory]%' ) as x Where rownum between [StartRecord] and 20 Order by Member
This does not work.
Using MSSQL Server Profiler I get:
Select * from ( Select ROW_NUMBER() over (order by member) as rownum, * from members ) as x Where rownum between 01 and 20
change page I get
Select * from ( Select ROW_NUMBER() over (order by member) as rownum, * from members ) as x Where rownum between 11 and 20
Next page query:
Select * from ( Select ROW_NUMBER() over (order by member) as rownum, * from members ) as x Where rownum between 21 and 20
The End row value has to increment so it has to be a variable number that is always 20 records above the StartRecord value. The variable is being set by a formula some where in code. I need to either have a way to change this value or a different way to page the data.
Please open a support ticket regarding your concern through https://www.mandeeps.com/support/standard so that we can take a look.
Your browser doesn't have Flash, Silverlight or HTML5 support.