Thanks Anthony... but where is that any different from just doing another query such as ...
<cfquery dsn="whatever" name="count"> SELECT field FROM table WHERE Field NEQ "" OR field NEW NULL </cfquery> <cfoutput>#count.recordcount#</cfoutput> maybe just hopeful dreaming... -----Original Message----- 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 interrogate your results. e.g. <cfquery name="rsNew" dbtype="query"> SELECT COUNT( something ) AS somethingCount FROM rsExisting WHERE NOT something IS NULL </cfquery> Where 'rsExisting' is the name of your original recordset. HTH, Ant On 17 Dec 2004, at 17:28, 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 like to utilize an existing query that includes that particular > field already in the select statement (among many others) > > Is there an easy way to get a count of records obtained by a query > where > data is in a field I'm interested in > > Hope that makes sense > > Tim > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188031 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
