reading total number of row with preparedstatement

Expert Exchange

Is there a way to read the total number of rows from a select satement using prepared statement, instead of having to loop throght the data and count as you go?
 rs1 = getIP.getResultSet();
 while (rs1.next())
    packIP(rs1.getString(1));

but instead

int total =  command

Thanks
tfbsrAsked:
Who is Participating?
 
TimothyInAfricaCommented:
Hello,

I suggest you set the result set to last and then you get the row number, this should give you the number of rows that was selected with your statement.

 rs1 = getIP.getResultSet();
 rs1.last();
 int rows = rs1.getRow()

//if  you need to go to the first again
rs1.first();

Hope this helps.

Cheers

Timothy
0
 
pitsterCommented:
You can try:
Select Count(myTable.*) as Total
From myTable

That should return 1 row with a value and a column header 'Total'



Good Luck!!!
0
 
vbStrikerCommented:
What language are you using?  Most have something like rs1.RecordCount as a function that can be referenced once the rs1 has been populated.
0
 
tfbsrAuthor Commented:
Using Java
0
 
vbStrikerCommented:
Sorry - don't know much about Java.  pitster's initial response will work for any query language so if you can't find another way it should get you there.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.