I'm relatively new to ColdFusion so please bear with me. I'm sure there's probably a simple solution to this but I've literally spent hours online trying to find something but to no avail.
Anyway, all I'm trying to do is query a query using the count function.
<cfQuery name= "UserInfo"> Select Name, State, Phone, count <tblUser.Name> as Count from TblUser group by State </query>
Now what I need to do is only return the results from States that contain more than 50 records. I simplified the example but that's pretty much the gist of the problem I'm having.
Thanks for any help you can provide!