Count items in reslutset?

Thread view:

WJ - 24 Apr 2008 18:52 GMT

Hi all,

Is it possible to get the number of rows in a resultset using SQL?

If I execute a statement like: SELECT COUNT(*) FROM table1 WHERE ID=12,

I dont know how to assign the result to an integer...

Thanx,
WJ

Reply to this Message

Donkey Hot - 24 Apr 2008 19:07 GMT

WJ <wjz@wirehub.nl> wrote in news:e1c38$4810c8fc$3ec2c5b8$6409
@news.chello.nl:

> Hi all,
>
[quoted text clipped - 6 lines]
> Thanx,
> WJ

ResultSet rs ;
int count ;

....

count = rs.getInt(1) ;

Reply to this Message

Uwe Seimet - 24 Apr 2008 19:50 GMT

> ResultSet rs ;
> int count ;
>
> ....
>
> count = rs.getInt(1) ;

One should probably add that this row count cannot be used to determine
the number of rows of a subsequent SELECT statement that selects actual
row data (not just the count) from the same table. Between the two
SELECT statements the number of rows may have changed.

Signature

-----------------------------------------------------------------------
Dr. Uwe Seimet http://www.linkbylink.net/

Reply to this Message

Lew - 25 Apr 2008 00:40 GMT

>> ResultSet rs ;
>> int count ;
[quoted text clipped - 7 lines]
> row data (not just the count) from the same table. Between the two
> SELECT statements the number of rows may have changed.

Depending on the semantics of the transaction type in which you wrap the
multiple statements.

Signature

Lew

Reply to this Message

Count items in reslutset?

Free Magazines