what dbms? mysql? mssql? oracle? access?
On Fri, 17 Dec 2004 12:28:34 -0500, Tim Laureska [EMAIL PROTECTED] wrote:
I'm looking for a way of obtaining a count of records from a query where
only one particular field has data...
I don't want to create a separate query for this just addressing
If I understand you correctly, you have already run the query in a
cfquery/ tag and have a recordset, no?
If so, you could do a simple Query of Queries on this to further
interrogate your results.
e.g.
cfquery name=rsNew dbtype=query
SELECT COUNT( something ) AS somethingCount
QofQ?
--Ben
Tim Laureska wrote:
I'm looking for a way of obtaining a count of records from a query where
only one particular field has data...
I don't want to create a separate query for this just addressing this
field (ie. do recordcount where field NEQ or some variation) but
would
access
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Friday, December 17, 2004 12:21 PM
To: CF-Talk
Subject: Re: record count
what dbms? mysql? mssql? oracle? access?
On Fri, 17 Dec 2004 12:28:34 -0500, Tim Laureska [EMAIL PROTECTED]
wrote:
I'm looking
-
From: Anthony Cooper [mailto:[EMAIL PROTECTED]
Sent: Friday, December 17, 2004 12:37 PM
To: CF-Talk
Subject: Re: record count
If I understand you correctly, you have already run the query in a
cfquery/ tag and have a recordset, no?
If so, you could do a simple Query of Queries on this to further
[mailto:[EMAIL PROTECTED]
Sent: 17 December 2004 19:05
To: CF-Talk
Subject: RE: record count
Thanks Anthony... but where is that any different from just doing
another query such as ...
~|
Special thanks to the CF Community
[mailto:[EMAIL PROTECTED]
Sent: Friday, December 17, 2004 12:37 PM
To: CF-Talk
Subject: Re: record count
If I understand you correctly, you have already run the query in a
cfquery/ tag and have a recordset, no?
If so, you could do a simple Query of Queries on this to further
interrogate your
7 matches
Mail list logo