Re: record count

2004-12-17 Thread Greg Morphis
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

Re: record count

2004-12-17 Thread Anthony Cooper
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

Re: record count

2004-12-17 Thread Ben Doom
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

RE: record count

2004-12-17 Thread Tim Laureska
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

RE: record count

2004-12-17 Thread Tim Laureska
- 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

RE: record count

2004-12-17 Thread Pascal Peters
[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

Re: record count

2004-12-17 Thread Greg Morphis
[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