Off the top of my head. If you set it up as a DSN you could (in theory)
query it using COUNT(SomeColumn) AS myRowCount. That assumes that a DSN
using Excel supports the COUNT() function.
HTH,
G
On Tue, Oct 11, 2011 at 4:26 PM, Brook Davies cft...@logiforms.com wrote:
Hey Everyone,
Anyone
Ad hoc SQL datasources may be an option if you have sufficient privleges on
a sql server and the account running sql has permissions to access the file.
On Tue, Oct 11, 2011 at 2:26 PM, Brook Davies cft...@logiforms.com wrote:
Hey Everyone,
Anyone know a way to count the rows in an excel
thanks for your help
richard
hi is there a way to count an array/list element occurences
e.g. list=1,2,12,12
find occurences for '12' would return '2'
thanks
~|
Want to reach the ColdFusion community with something they
Try this UDF:
http://cflib.org/udf/REListFindNoCaseMultiple
Here's the UDF code and a quick example:
cfset list = '1,2,2,12,12,15'
cfdump var=#REListFindNoCaseMultiple('12',list)#
cfscript
/**
* When given a list of values, returns a list of element locations that
match a given regular
find occurences for '12' would return '2'
For lists try the ListValueCount/ListValueCountNoCase functions
cfoutput
#ListValueCount(list, 12)#
/cfoutput
-Leigh
~|
Want to reach the ColdFusion community with
If it's a form posting you could simply add a hidden variable and
increment it each time the page gets hit:
cfparam name=form.submitCount default=0
form
...
input type=hidden name=submitCount value=#form.submitCount+1#
Otherwise you could just use a session variable if you have then
enabled.
cfparam name=session.pagecount default=0
cfset session.pagecount = session.pagecount + 1
On Fri, Feb 20, 2009 at 9:47 AM, Priya Koya priya23...@gmail.com wrote:
Hi All,
I need to count the number of times a page was submitted continuously with
a single user. If I set a count in the page
Thanks for your help!
cfparam name=session.pagecount default=0
cfset session.pagecount = session.pagecount + 1
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
Pls confirm which of the two ways is more efficient or more
recommended- please advise if it even makes a difference. Thanks!
SELECT count(fieldname) as thecount
OR
SELECT fieldname
..
..
cfset countfromquery = queryname.recordcount
If you don't need the actual records, COUNT.
Count(primaryKey) is definitely better. Less information returned from
the database so less bandwidth is used, plus the result can be
obtained instantly from the index (I suppose this depends on the db).
-Mike Chabot
On 9/6/06, Michael E. Carluen [EMAIL PROTECTED] wrote:
Pls confirm which of
one returns a single integer with the count.
the other returns every single fieldname in the table
I would think the first would always be quicker.
On the other hand, if you need the list of fields anyway, option 2
comes free with the query.
On 9/6/06, Michael E. Carluen [EMAIL PROTECTED]
Thanks Dave W., Mike!
-Original Message-
From: Mike Chabot [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 06, 2006 3:35 PM
To: CF-Talk
Subject: Re: COUNT() versus .recordcount
Count(primaryKey) is definitely better. Less information returned from
the database so less
I've been tied up with stuff lately, but I finally have a bit of a breather, so I'm ready to tackle this thing once and for all.I just want to get some feedback on what I plan on doing:
On my site, UserID (an integer) is a session variable.I'll create a structure that has the following three
yes but you can also run the update to knock out past connections when you update the current time, that is what I do.
-Original Message-
From: Sung Woo [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 07, 2004 8:23 AM
To: CF-Talk
Subject: Re: Count Online Users Conundrum
I've been
Excellent.So there are two instructions on the structure update:
1) update my time
2) kill any connections older than 15 minutes
I'd still need to run a cleanup script every fifteen minutes, just to clean up any last connections, right?Otherwise, there will always be 1 person logged on, I'd
I run through my login script whenever someone logs on, I do not schedule it myself. Seems to work just fine.
-Original Message-
From: Sung Woo [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 07, 2004 9:44 AM
To: CF-Talk
Subject: Re: Count Online Users Conundrum
Excellent.So
Thanks.I ran your script and sure enough, right now, it
says there are 99 users when it probably should be something
like 20.I'm not sure if I'm understanding you completely --
I'm thinking that I need to add to the following snippet that
already exists:
What are you actually trying to
What are you actually trying to do?I'm assuming you're attempting to
see who's currently using the system, and basically discounting anyone
who's not been active in the last 15 minutes?
If this is the case let me know and I'll knock a little code out for
you!Can't do it today, stupid firewall
Hi Ryan,
Here are my results:
4
12
14
10
11
15
8
5
3
8
10
12
10
7
4
13
14
14
14
13
15
7
6
3
12
0
6
11
5
6
11
4
4
12
6
11
4
4
11
6
14
13
15
10
9
9
3
15
9
6
2
12
9
10
13
8
11
5
3
13
3
3
3
2
2
4
2
2
5
2
2
12
3
2
4
9
2
15
4
7
2
9
6
10
1
5
14
1
1
13
8
11
14
14
1
1
15
6
9
4
8
5
7
1
1
1
1
6
1
12
0
0
0
Ray, is there any way I could streamline the locks?This is in the application.cfm page, so it's being hit quite often, and I'd like it to be as efficient as possible.Thanks!
- Sung
Not that it helps much, but that is some pretty awful code. The locks
are too much and the code generating cfid
Sung,
What happens is that at the end of the day (I run an intranet where
there
are about 200 peak users), around midnight, it still shows 80 or so
users
online!What do you think could be causing this?
Does the code you run to report on the user sessions run the code you
posted first?By this
Hi Tim,
Thanks so much for the breakdown.I got the code from easycfm.com and didn't think to really analyze it.I'll make the changes you suggested and let you know if I run into anything.Thanks again!
- Sung
Sung,
What happens is that at the end of the day (I run an intranet where
there
are
One thing:
What you'll need to do is add *two* timestamps to each user -- one for
when they first accessed the system, and one when they last requested
a
page.Your 15 minute check should then use the difference between
these values to determine whether the user has been inactive for 15
My apologies -- this will give you their total session time.To work
out if they've been inactive for more than 15 minutes you'll have to do
a time check comparing the last active timestamp and the current time
using now().
Hi Tim,
Thanks.I ran your script and sure enough, right now, it says
cfloop collection=#Application.UsersInfo# item=itmUser
cfset userActiveTime = Evaluate(DateDiff(n,
StructFind(Application.UsersInfo, itmUser), Now()))
#userActiveTime#
/cfloop
Ryan Duckworth
Macromedia ColdFusion Certified Professional
Uhlig Communications
10983 Granada Lane
Overland Park,
Not that it helps much, but that is some pretty awful code. The locks
are too much and the code generating cfid seems quite wack.
On Tue, 17 Aug 2004 15:39:58 -0500, Ryan Duckworth [EMAIL PROTECTED] wrote:
cfloop collection=#Application.UsersInfo# item=itmUser
cfset userActiveTime =
I think you have a situation where the sessions are staying active long
after the user logs off.Run that loop and let me know what you get
back.Your problem will probably be obvious then.
Ryan Duckworth
Macromedia ColdFusion Certified Professional
Uhlig Communications
10983 Granada Lane
There are a few different ways to do this. There is a ServiceFactory
method that will help. This article,
http://www.findarticles.com/p/articles/mi_m0MLU/is_10_5/ai_109039749,
written by myself, shows code that Sam Neff wrote. You can also do
tracking in application.cfm by doing (pseudo-code)
To: CF-Talk
Subject: Re: Count logged in user sessions
There are a few different ways to do this. There is a ServiceFactory
method that will help. This article,
http://www.findarticles.com/p/articles/mi_m0MLU/is_10_5/ai_109039749,
written by myself, shows code that Sam Neff wrote. You can also do
-Original Message-
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED]
Sent: Monday, August 09, 2004 9:23 AM
To: CF-Talk
Subject: RE: Count logged in user sessions
Does anyone know the performance cost of things like the
SessionTracker
code?
[Todays
the session not die when the browser was closed, it started a completley NEW session when the browser came back (weird)
- Original Message -
From: Raymond Camden
To: CF-Talk
Sent: Monday, August 09, 2004 8:44 AM
Subject: Re: Count logged in user sessions
There are a few different ways
, 2004 9:43 AM
To: CF-Talk
Subject: RE: Count logged in user sessions
You don't need to keep track of sessions, CF does it for you:
Access session vars from outside the session
http://www.rewindlife.com/archives/46.cfm
HTH,
Sam
Blog http
depressedpress.com
If you'd like to see the code let me know.I still consider it beta, but
so far it's working okay (although I've still some bugs track down).
Jim Davis
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED]
Sent: Monday, August 09, 2004 9:23 AM
To: CF-Talk
Subject: RE: Count logged
make me want to remove this feature.
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED]
Sent: Monday, August 09, 2004 8:23 AM
To: CF-Talk
Subject: RE: Count logged in user sessions
Does anyone know the performance cost of things like the SessionTracker
code?
Without
On Sat, 7 Aug 2004 18:15:08 -0400, Ewok [EMAIL PROTECTED] wrote:
This has got to be possible. Seems like I remember the question being asked before but can't seem to word it right in the archives to get any results. Anyone know a link or a solution?
I am using sessions to log people in and
Looks promising, I'll give it a whirl. Thanks for the link
- Original Message -
From: Dave Carabetta
To: CF-Talk
Sent: Saturday, August 07, 2004 6:21 PM
Subject: Re: Count logged in user sessions
On Sat, 7 Aug 2004 18:15:08 -0400, Ewok [EMAIL PROTECTED] wrote:
This has got
Depending on the database you are using, you can use the built in functions.
For example, in MS SQL Server you do this:
SELECTCOUNT(*) AS THECOUNT, MONTH(EnteredDate) AS THEMONTH,
year(EnteredDate) AS THEYEAR
FROMORDER
GROUP BY YEAR(EnteredDate), MONTH(EnteredDate)
To get a list of the year,
Neal,
Book Recommendation :Sams Teach Yourself SQL in 21 Days:
http://www.amazon.com/exec/obidos/tg/detail/-/0672324512/qid=1073328907//ref
=sr_8_xs_ap_i3_xgl14/104-5044138-6895159?v=glance
http://www.amazon.com/exec/obidos/tg/detail/-/0672324512/qid=1073328907//re
sr. web applications architect
navtrak, inc.
[EMAIL PROTECTED]
www.navtrak.net
office 410.548.2337
fax 410.860.2337
-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 10:41 PM
To: CF-Talk
Subject: RE: count and strip words from string
cfset firstWordBreak = find(' ',search,1)
cfif firstWordBreak
cfset secondWordBreak = find('
',search,firstWordBreak)
/cfif
cfif isDefined(secondWordBreak) and secondWordBreak
cfset thirdWordBreak = find('
cfset firstWordBreak = find(' ',search,1)
cfif firstWordBreak
cfset secondWordBreak = find('
',search,firstWordBreak)
/cfif
cfif isDefined(secondWordBreak) and secondWordBreak
cfset thirdWordBreak = find('
',search,secondWordBreak)
Try (and adapt) this:
CFSET test=skateboarding atlanta half-pipe
CFSET oper =
CFQUERY DATASOURCE=DSN
SELECT myColumn FROM myTable
WHERE
CFLOOP INDEX=word LIST=#test# DELIMITERS=
#oper# myColumn LIKE '%#word#%' CFSET oper = OR
/CFLOOP
/CFQUERY
off the top of head
-
Cfset stringToFind = test
cfset startPos = 1
cfset foundCount = 0
cfloop from=1 to=1000 index=i step=1
cfif FindNoCase(stringToFind,cfhttp.fileContent,startPos)
cfset foundCount = incrementValue(foundCount)
I located a simple UDF at CFLIB.
Thanks
-Original Message-
From: Neil Middleton [mailto:[EMAIL PROTECTED]
Sent: Friday, July 18, 2003 9:13 AM
To: CF-Talk
Subject: RE: Count string occurances in an html file.
off the top of head
-
Cfset
Hmm, hadn't thought of doing that way...quite neat
Neil
-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]
Sent: 18 July 2003 14:28
To: CF-Talk
Subject: RE: Count string occurances in an html file.
I located a simple UDF at CFLIB.
Thanks
I have a table that has one field that holds numbers 1 thru
9. Can I run a single query that will give me the count(*)
of 1's, count(*) of 2's, etc. or do I have to run a separate
query for each?
Do you want them in one row, or one row per number?
The SQL is a lot bigger for one row, but
You could do something like this:
SELECT TOP 1 (select count(qty) from items where qty = 1) AS num_1s, (select
count(qty) from items where qty = 2) AS num_2s
FROM items
GROUP BY qty
I'm sure there's a more efficient way to do this, but this should work.
- Original Message -
From:
SELECT Count(NumbersField) AS CountOfField
FROM table1
GROUP BY NumbersField
That does it, I tried it.
Matt Small
-Original Message-
From: Hawkes, Keith A CIV [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 7:18 AM
To: CF-Talk
Subject: Count(*) Query
I have a table that has
SELECT Count(NumbersField) AS CountOfField
FROM table1
GROUP BY NumbersField
That does it, I tried it.
But you only get the Count, so you don't know what it's a count of...
~|
Archives:
You're right, I didn't see your query when I wrote this one.
-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 9:52 AM
To: CF-Talk
Subject: RE: Count(*) Query
SELECT Count(NumbersField) AS CountOfField
FROM table1
GROUP BY NumbersField
SELECT number, count(*) FROM table
GROUP BY number
I have a table that has one field that holds numbers 1 thru 9. Can I run a
single query that will give me the count(*) of 1's, count(*) of 2's, etc. or
do I have to run a separate query for each?
Thanks to all,
Keith
nevermind
i peeped my head outta my ass i got it
Dave
- Original Message -
From: Dave Lyons [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, February 15, 2003 12:53 AM
Subject: count down code is buggin
the code i got to work last night on the auction count down is
AFAIK I think you can only do distinct on 1 field. Try it with just one
field - (not the key as this should be distinct anyway)
Kola
-Original Message-
From: cftalk [mailto:[EMAIL PROTECTED]]
Sent: 22 March 2002 18:32
To: CF-Talk
Subject: OT: count(distinct) in MS Access
Hi,
Anyone?
Why do you think I can't get the Rowcount AS Deleted in cfoutput?
DELETE from Orders WHERE
Product_id=#val(Product_id)#
SELECT ROWCOUNT AS Deleted
error cfoutput#QuerynameDeleted#/cfoutput
__
Get Your Own
SET NOCOUNT ON
DELETE from Orders WHERE
Product_id=#val(Product_id)#
SELECT Deleted = ROWCOUNT
SET NOCOUNT OFF
__
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant
That did it! Thanks Paul.
- Original Message -
From: Paul Hastings [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 12:34 PM
Subject: Re: count delete [anyone?]
SET NOCOUNT ON
DELETE from Orders WHERE
Product_id=#val(Product_id)#
SELECT Deleted
Use an instead of trigger. Check the books online for mssql. Search for
create trigger.
Good luck,
Alexander Sicular
Chief Technology Architect
Neurological Institute of New York
Columbia University
as867 [at] columbia {dot} edu
|-Original Message-
|From: [EMAIL PROTECTED]
I'm sorry, how will triggers help?
- Original Message -
From: Sicular, Alexander [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 1:17 AM
Subject: RE: count delete
Use an instead of trigger. Check the books online for mssql. Search for
create trigger
|-Original Message-
|From: Jason Davis [mailto:[EMAIL PROTECTED]]
|Sent: Thursday, February 28, 2002 6:27 PM
|To: CF-Talk
|Subject: Re: count delete
|
|
|I'm sorry, how will triggers help?
|
|- Original Message -
|From: Sicular, Alexander [EMAIL PROTECTED]
|To: CF-Talk [EMAIL PROTECTED
)#
SELECT @@ROWCOUNT AS Deleted
error cfoutput#Queryname.Deleted#/cfoutput
- Original Message -
From: Sicular, Alexander [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 1:32 AM
Subject: RE: count delete
A trigger is like a sneaky piece of code that lurks
Count(fileId) will be faster, but don't take my word for it, run the query
in Query Analyzer and check it out. The count(*) has to first figure out
what columns it needs to count on, then do the count, the count(fileId) your
telling it which one to count on and it saves time, which on a large
I've always assumed that any SQL command where you give it a
specified field
or fields, rather than (*) is faster. I haven't done any testing
with this
particular statement, though.
Evan
-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18,
Which is faster?
COUNT(*) or COUNT(fileID)
assuming fileID is a regular INT, that is also my primary key
First, you have to understand that they do different things;
Count(*) returns the number of rows (total) in the table
Count(fileID) returns the number of non-NULL entries in that field
I think this depends on the DBMS that you are using. In SQL Server I
think
COUNT(field) is faster, and in Access COUNT(*) is faster.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
It's important to note that if you use Count(field), you should do it on a primary key
or other required field. Count will not count fields that are blank.
Kevin
[EMAIL PROTECTED] 07/18/01 08:14AM
Count(fileId) will be faster, but don't take my word for it, run the query
in Query Analyzer
No straight answer, ha?
Thanks,
Michael
- Original Message -
From: Pete Freitag [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 18, 2001 5:58 PM
Subject: RE: COUNT(*)
I think this depends on the DBMS that you are using. In SQL Server
I
think
COUNT(field
Which is faster?
COUNT(*) or COUNT(fileID)
Can I just say one thing about this question that I forgot to add to
my
previous response
Make a template and test it... either use GetTickCount() or turn on
debugging - it might work differently on our setups than on yours...
Philip Arnold
first of all, i suggest you name all of your checkboxes the same, unless you
have a different reason, and you should assign the ID's to the values of the
checkboxes. the reason for this is that all of the boxes checked will come
out in one form variable in a comma delimited list of their
Change the form like so:
CFOUTPUT QUERY=MetList
TR
TDINPUT TYPE=checkbox NAME=MetCheck
VALUE=#Met_ID#/TD
TD#Met_ID#/TD
TD#FirstName# #LastName#/TD
Ann
A better way...
Define all checkboxes with the same name, but an unique value (the ID).
That way you get a list containing the values of all the checked Items,
The listLen() function will give you the number of checked boxes
for example:
input type=Checkbox name=MetCheck
Have you thought about giving the checkboxes all the same name, and setting
the value equal to the Met_ID? It's much easier to keep track of this way.
On your action page, you can view #form.checkboxname# and see all the values
that were checked. Then you can get a count with
Hi Ann,
I would do it like this: Name the checkbox fieldname the same for all 67
names.
input type=checkbox name=IDList value=#UniqueID1#
Then when posting the form just do a #ListLen(Form.IDList)# to get your
count of checked boxes.
~~
Why not name each check box the same name and use a different value???
CFOUTPUT QUERY=MetList
TR
TDINPUT TYPE=checkbox NAME=MetCheck
VALUE=#Met_ID#/TD
TD#Met_ID#/TD
TD#FirstName# #LastName#/TD
/TR
Thanks guys! One (or a combination) of your ideas worked. It's late.. maybe
I dreamed it up myself. NOT G
Ann
-Original Message-
From: Ann Harrell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 1:12 PM
To: CF-Talk
Subject: Count check boxes?
I have a list of 67 names
I want this statement to count how many people are in the class
by the date.
Please help me it keeps on kicking out this error.
Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in
query expression 'count(distinct cccustomer.clname)'.
cfquery name="qryGETSTUDENTS"
Without seeing the CFQUERY tag this is just a guess, but that error
usually occurs when a) you've mistyped a column name, b) missed single
quotes (or used them when you should not have), c) missed commas.
--- Ben
-Original Message-
From: Tom Harris [mailto:[EMAIL PROTECTED]]
Sent:
An example of the query that is failing, as it is being called would be
helpful for debugging purposes.
DC
- Original Message -
From: "Tom Harris" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, January 08, 2001 13:05
Subject: COUNT field incorrect
BlankHello --
BlankHello -- anyone know what this error refers to?
ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect
It started appearing in an app we are working on, we searched the code for
anything referring to "count" and there is
How about looping through the var def as a collection storing each
occurence of the words your looking for into an array. Then you can find out
how many times it occured using the ArrayLen() function.
HTH,
Mike
From: Eric Fickes [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk
Ok, Justin MacCarthy pointed out something for me to try. He suggested
using count(cfid) instead of count(*) which would yield the same results.
This table has like 944 records btw, here are the results of time in ms
taken to run 1000 queries of each over 5 tries:
Using count(cfid): 3313
: Wednesday, September 06, 2000 5:32 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: count() or recordcount
In my situation, I needed the data anyway, so the comparison was
Count() + data versus RecordCount + data.
Kevin
[EMAIL PROTECTED] 09/06/00 01:01PM
I tested this using CF 4.01 using
RecordCount + data, you are really just adding Count(), since
the
data and RecordCount is given with both of those.
Justin Kidman
-Original Message-
From: Kevin Miller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 5:32 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE
If you do a select * and then do a record count you have to perform 2
operations. Select count(*) is only one so I think you are right - count(*)
will be faster but it'll be negligible unless you have a huge amount of
records
--
Two totally different beasts. If you want to pull data back from the
database and then determine how many rows were returned, use
query.recordcount rather than going back to the database for a row count.
If you only want to find out how many rows but don't need the data, then
count() is your
Just ran a test using my CGLOBAL table that holds client variables in an
ODBC database. Over 1000 loops of a query grabbing cfid and using
recordcount, it took 20031 ms of time. To get the recordcount using the
count(*) method, over 1000 loops of the same table, it only took 3406 ms.
So, if you
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
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 9:17 AM
To: '[EMAIL PROTECTED]'
Subject: RE: count() or recordcount
If you do a select * and then do a record count you have to perform 2
operations. Select count(*) is only one so I think you
I tested this using CF 4.01 using a 9000+ record Access database.
Using Query.RecordCount was actually about 10-20% faster.
Kevin
[EMAIL PROTECTED] 09/06/00 09:16AM
If you do a select * and then do a record count you have to perform 2
operations. Select count(*) is only one so I think you
Kidman
-Original Message-
From: Justin Kidman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 9:24 AM
To: '[EMAIL PROTECTED]'
Subject: RE: count() or recordcount
Just ran a test using my CGLOBAL table that holds client variables in an
ODBC database. Over 1000 loops
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
---[ ]---
-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
If you do a select * and then do a record count you have to
perform 2 operations. Select count(*) is only one so I think
you are right - count(*) will be faster but it'll be negligible
unless you have a huge amount of records
Actually, the difference can be pretty significant even with
On 9/6/00, Dan Haley penned:
Two totally different beasts. If you want to pull data back from the
database and then determine how many rows were returned, use
query.recordcount rather than going back to the database for a row count.
If you only want to find out how many rows but don't need the
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--_=_NextPart_001_01C0182B.FDF468CC
Content-Type: text/plain;
charset="iso-8859-1"
Hello!
OT: Does anyone know how I can turn off MIME formatting
This is a multi-part message in MIME format.
--=_NextPart_000_0195_01C01830.46584260
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
RE: count() or recordcountI would love to have the answer to the same
question.
DC
-Origin
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--_=_NextPart_001_01C0182B.FDF468CC
Content-Type: text/plain;
charset="iso-8859-1"
Hello!
OT: Does anyone know how I can turn off MIME formatting
In my situation, I needed the data anyway, so the comparison was
Count() + data versus RecordCount + data.
Kevin
[EMAIL PROTECTED] 09/06/00 01:01PM
I tested this using CF 4.01 using a 9000+ record Access database.
Using Query.RecordCount was actually about 10-20% faster.
The thing is
I need obtain a few field counts but based on different criteria.
The following almost works but I need something like this:
(COUNT(cn) ='21') AS C21_COUNT AND
(COUNT(cn) ='20') AS C20_COUNT
I tried doing this in a UNION but could not get it working.
Can COUNT be used on a varchar
COUNT(*) AS source_count,
To save a possible headache later ... note that count(*) will include
nulls as well as live data. Count by reference to specific column
will exclude nulls., i.e. count(thiscolumn).
--
99 matches
Mail list logo
