Number of table rows?

Thread view:

Thread rating:

ryansebiz - 28 Mar 2007 23:44 GMT

How can I find the number of table rows returned as a number?

Dan Bracuk - 29 Mar 2007 01:12 GMT

select count(*) as somenumber
from yourtable

ryansebiz - 29 Mar 2007 01:45 GMT

> select count(*) as somenumber
> from yourtable

Thanks Dan, works perfect.

Azadi - 29 Mar 2007 01:33 GMT

> How can I find the number of table rows returned as a number?

#yourqueryname.recordcount# maybe? kind of hoping you knew that one
already...

Signature

Azadi Saryev
Sabai-dee.com
Vientiane, Laos
http://www.sabai-dee.com

ryansebiz - 29 Mar 2007 01:46 GMT

>> How can I find the number of table rows returned as a number?
>
> #yourqueryname.recordcount# maybe? kind of hoping you knew that one
> already...

It's not part of a query. I'm using it in a UDF to determine random
numbers and need the total db rows for the "to" number.

Webmaster Forum / ColdFusion / Getting Started / March 2007