Hi, Assuming this is the SQL you want to submit:
> > try{ > stmt = con.createStatement(); > rs = stmt.executeQuery("SELECT empno from > db2admin.employee"); shouldn't it be if( rs.next() ){ do{ count++; out.println( " empno is "+rs.getString( 1 ) ); }while( rs.next() ); } or something along those lines? (rather than the !rs.next() ) > > try{ > if(!rs.next()) > { > count = count +1; > String a = rs.getString(1); > > out.println(" empno is " + a ); > out.println("<BR><BR>While Count is"+ count); > } -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>