have you tried to use using the column index
On 15 June 2010 10:27, marc <[email protected]> wrote: > Hi all > > I am getting an error on the following code when I want to access the > variable "TotalSale" out side the loop. > *************************************************************************** > ResultSet Rs = sta.executeQuery("SELECT n_totalprice,id FROM orders > WHERE ID = IDENT_CURRENT('orders')"); > > while (Rs.next()) { > float TotalSale = Rs.getFloat("n_totalprice"); > System.out.println(TotalSale);// no error > } > System.out.println(TotalSale);//Error TotalSale cannot be resolved > *************************************************************************** > > I am getting single value from the databse so i also tried with the > following code but still the result is same. > > *************************************************************************** > if (Rs.next()){float TotalSale = Rs.getFloat("n_totalprice");} > *************************************************************************** > > Can any body please help me.Thank you in advance > > -- > You received this message because you are subscribed to the Google Groups > "The Java Posse" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<javaposse%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/javaposse?hl=en. > > -- You received this message because you are subscribed to the Google Groups "The Java Posse" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/javaposse?hl=en.
