ResultSet problem

Hello,

I have a problem with ResultSet. Here's a part of my code :

[...]

<jsp:useBean id="db" scope="request" class="SQLBean.DbBean" />

<jsp:setProperty name="db" property="*" />

<%@include file="checklogin.jsp"%>

<%!
ResultSet results = null ;
%>

[...]

results = db.execSQL("SELECT COUNT(*) FROM tbl_question_r WHERE cle_user="+cle_user);

[...]

execSQL is from DbBean.class, it basically takes a SQL command as an argument.
So when the SQL command is sthg like "SELECT * FROM table_name", all i have to do is results.getString("name_of_db_column")
However in this case, SELECT COUNT(*) FROM is a number. How can i get it? results.getString(0) doesn't work it seem.
Any help would be great

Remy

use getString(1).

i did so, but now i have this error :

org.apache.jasper.JasperException: Before start of result set



any guess?

if that can help, the bare code is basically :

stupid me i'm lacking the if result1.next() ... else exception.

now it works. thanks.

you could also use getInt(), 'cause you have a numeric value.