Also count() is really useful since its an aggregate.
When you were doing SubSelects which only needed to
count rows that matched certain criteria (like say
ranking criteria to rank most searched for items)
it becomes an invaluable tool :)
Jeremy Allen
[EMAIL PROTECTED]
Insert Quarter Here --->[ ]<---
-----Original Message-----
From: Jamie Keane [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 1:08 PM
To: [EMAIL PROTECTED]
Subject: Re: count() or recordcount
Furthermore, count() is just that, a tally of the rows as a query column in
and of itself. The RecordCount variable is an attribute of the query
object. Returning a query object assumes that you wish to do something with
it, other than count how many rows are returned. If you're just wishing to
count the items with x criteria, your intent is closer to count() anyway. :)
--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC 28270
www.solutionmasters.com
704.563.5559 x 228 Voice
704.849.9291 Fax
-----Original Message-----
From: Todd Ashworth <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, September 06, 2000 12:31 PM
Subject: Re: count() or recordcount
>In a direct comparison, I would think count() would be since it's run on
the
>SQL server.
>
>Todd Ashworth
>
>----- Original Message -----
>From: "Bud" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Wednesday, September 06, 2000 12:11 PM
>Subject: count() or recordcount
>
>
>| Which is faster? I'm presuming count() or what else would it be good for?
>| --
>|
>| Bud Schneehagen - Tropical Web Creations
>|
>| _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
>| ColdFusion Solutions / eCommerce Development
>| [EMAIL PROTECTED]
>| http://www.twcreations.com/
>| 954.721.3452
>| -------------------------------------------------------------------------
-
>----
>| Archives: http://www.mail-archive.com/[email protected]/
>| To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>|
>
>
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
