Going on my nerf with Invalid cursor state

Hi all,

It's going to make me mad : i can't retrieve value from resultset

for(int t=0;t<Integer.parseInt(request.getParameter("ResList"));t++)

{

ran=(int)(Math.random()*(maximum-minimum))+(minimum+1);

System.out.println("Voici le chiffre randomiser : " + ran);

renstr=entete+ran;

System.out.println("Voici le str randomiser : " + renstr);

psQuery= " SELECT Case_ID_, create_time, Requester_Name_,Description from aradmin.helpdeskcases where Case_ID_='" + renstr + "'";

System.out.println("La reQ :" + psQuery);

rs=statement.executeQuery(psQuery);

//num=rs.getString("Case_Id_");

//System.out.println("Contenu de num : " + num);

result[t]=rs.getString(1);

System.out.println("Le tabl:" + result[t]);

//n++;

//result[n]=rs.getString("Requester_name_");

//n++;

//result[n]=rs.getString("Description");

}>

[953 byte] By [LearningSTF] at [2007-9-26 2:37:38]