Hi , I need to limit the number of rows returned from the database after executing a query. for example ,say that i need to see only 5 rows out of my query but the original query returned 30 rows, how can i set this option?? i tried to use the setMaxRows() in the PreparedStatement interface , but it doesn't seems to work , if i use it , i will not get any rows back. can any one help please. thanks
A Software life cycle can be greater than its Developer's
"Maitham H", The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please log in again with a new name which meets the requirements. Thanks.