Paging Stored Procedure - Page 2

petalyaa · #16 (**permalink**) 11-05-09, 23:03

Thanks blindman. I did analyze back my query and try to simplify it. Then i come to this short query. But, by default, Java will throw exception with this query because it took about 5 minutes to execute and sql server will response, server timeout. Then i try to set query timeout to unlimited with PreparedStatement object. Then, hey it work!!

Code:

SELECT TOP x * FROM (SELECT TOP [x*y] * FROM VPCSTINV AS T1 ORDER BY NAME DESC) AS T2 ORDER BY NAME ASC

x = Number of result to show
y = current page

Thanks all!! Cheers..

blindman · #17 (**permalink**) 11-09-09, 10:40

It is the job of your interface to determine how the data is displayed. The database has nothing to do with it.

petalyaa · #18 (**permalink**) 11-09-09, 20:38

Yeah, correct.. This must be done in the interface and nothing to do with database. U have to query your sql first and then get the title, write it in the page and add

Code:

JAVA
<a href="<%= link %>"><%= name %></a>

PHP
<a href="<?php echo $link ?>"><?php echo $name ?></a>

Internet Services

Web Development

Digital Marketing

Consumer Tech