Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 25, 2013 09:12 AM by CruzerB
Jan 25, 2013 05:40 AM|LINK
I am binding my jquery to stored procedure.
SELECT * FROM
SELECT a.*, rownum r_
SELECT * FROM ORDERS WHERE CustomerID LIKE 'A%'
ORDER BY OrderDate DESC, ShippingDate DESC
WHERE rownum < ((pageNumber * pageSize) + 1 )
WHERE r_ >= (((pageNumber-1) * pageSize) + 1)
Initially I am passing page number as 1 and page size as 10.
But although I have thousands of records it displays 10 records as desired but my next page button is disabled...
how can i fix this
Jan 25, 2013 09:12 AM|LINK
Since ROWNUM always start from 1.