Hi All,
Is there a way to limit the number of rows returned by iBatis. 
I want to solve this scenario
Case 1)  The user clicks the Order Search link and i would like to show the user the top 100 orders by default even before the user enters the search criteria.  ie., instead of showing the search criteria i want to show the top 100 orders along with the search filter. 
Case 2) Now the user selects the search criteria and then on all the rows that match the search criteria should be returned.
Thanks in advance.
Prashanth Sukumaran

Yahoo! Music Unlimited - Access over 1 million songs. Try it free.