Che, >Dan, unfortunately, I gave a stripped down example. The main query is more >complex (has 10 or so columns w/multiple WHERE clauses) and would not work >well with a Q of Q as dynamic values are passed to it. Any other ideas?
The complexity of the original query doesn't really matter. The QoQ functionality allows you to take a query object and then break that query down farther by using T-SQL based statements. If your original query was named "queryName", the original code I posted (which is below) would do exactly what you wanted to do w/the StructFind() function. ><cfquery name="getCount" dbtype="query"> > select > count(OptNurseryOnly) > from > queryName > where > OptNurseryOnly = 1 ></cfquery> -Dan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256101 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4