How can resultset records be restricted to certain rows?

Location: jguru.com/faq/view.jsp?EID=15644 Created: Feb 18, 2000 Modified: 2000-02-19 04:19:02.43 Author: Govind Seshadri (http://www.jguru.com/guru/viewbio.jsp?EID=14) The easy answer is "Use a JDBC 2.0 compliant driver". With a 2.0 driver, you can use the setFetchSize() method within a Statement or a ResultSet object. For example, Statement stmt = con.createStatement(); stmt.

SetFetchSize(400); ResultSet rs = stmt. ExecuteQuery("select * from customers"); will change the default fetch size to 400. You can also control the direction in which the rows are processed.

For instance: stmt. SetFetchDirection(ResultSet. FETCH_REVERSE) will process the rows from bottom up.

The driver manager usually defaults to the most efficient fetch size...so you may try experimenting with different value for optimal performance. More.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.