This is actually a SQL question instead of JDBC - if your database engine
supports it, you can use the LIMIT parameter to your select query which
will limit the result set to the specified number of responses. Check your
database engine documentation for details.
Michael
At 12:32 PM 1/2/01 -0600, you wrote:
>Happy New Year to All!
>
>Hi, I have a JDBC question.
>
>I have a database and I need to retrive the latest 100 transactions into my
>jsp page. I am planning to do it this way:
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
