hi Reumann
..still there will be problem as what r u trying is
that finding whether that table has got any record or
not ..BUT the query which u actually execute on that
table might not find the matching record ..it depends
on the query..so despite having records in ur table
there r chances that ur ResultSet is empty...
I really wonder how to solve this problem..
i've been trying with many things...BUT NOT
WORKING at all.....
anyway thanx for ur suggestion...let me know
if u could find some good solution....not many
persons responded to this query...i request all
of them to say something on this issue
thanx and regards,
rajesh
--- Reumann <[EMAIL PROTECTED]> wrote:
> I don't think your idea really works Oleg, because
> when I try that if
> the
> result set is empty you will get a null pointer
> exception. What I
> usually
> do when I have to know if it is empty or not is make
> an extra query
> to get
> a count of the rows. "SELECT COUNT(*) FROM
> TABLE..." Then if
> ( rs.next()
> ) {
> if ( rs.getInt(1) > 0 )
> {
> process and do next select statement or whatever
> }
> else
> {
> query was empty and no rows came back
> }
> }
>
> Maybe there is a better way to do it, but I'm not
> aware of it.
>
>
__________________________________________________
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/
===========================================================================
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
