Hi Use count(*) function eg select count(*) from tablename Regards :-) Kanojia Jogesh(Senior Web Developer) IG Technologies Ltd,Mumbai We are in Web Development and B2B and B2C Solution provider > ----- Original Message ----- > From: Neal Cabage <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, August 16, 2000 7:03 AM > Subject: JDBC - recordcount > > > > Does anyone know how to return a recordCount when using JDBC? For > instnace, > > in ADO (Microsoft world) recordCount is simply a property of the recordSet > > object. Is there something that provides a similar functionality? I need > > that value *prior* to moving through the records so simply incrementing a > > value is not an option. > > > > Also, can anyone recommend a driver (and/or method) for accessing a > > Microsoft DB such as SQL server, that does not require the JDBC:ODBC > bridge? > > > > > > Thanks. > > Neal > > > > > =========================================================================== > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". > > 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 > > > =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". 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