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]>

Reply via email to