Count items in reslutset?

From: WJ <wjz@xxxxxxxxxx>
Date: Thu, 24 Apr 2008 19:52:11 +0200

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
.

Follow-Ups:
- Re: Count items in reslutset?
  - From: Donkey Hot

Prev by Date: The All Popular Swiss Movado Watches
Next by Date: Re: Count items in reslutset?
Previous by thread: The All Popular Swiss Movado Watches
Next by thread: Re: Count items in reslutset?
Index(es):
- Date
- Thread