Che,
You can use Queries-of-Queries:
<cfquery name="getCount" dbtype="query">
select
count(OptNurseryOnly)
from
queryName
where
OptNurseryOnly = 1
</cfquery>
That would give you the count of the number of entries that had
OptNurseryOnly set to 1. (NOTE: If the OptNurseryOnly is a text field,
you'll want to use apostrophes around the value.)
-Dan
>-----Original Message-----
>From: Che Vilnonis [mailto:[EMAIL PROTECTED]
>Sent: Monday, October 09, 2006 5:05 PM
>To: CF-Talk
>Subject: StructFindValue Question...
>
>I *think* I need to use StructFindValue here. Not sure.
>
>I have a simple query. One of the columns is named OptNurseryOnly. The
>values returned from the db can only be a one or a zero. I'd like to use
>some type of conditional logic to know if any "1"s are returned in the
>query
>*w/o looping through the query or using a valuelist funtion* but I cannot
>quite get it to work. Something like:
>
><cfif StructFindValue(query.OptNurseryOnly, "1", "ALL")>
> do something
></cfif>
>
>What am I doing wrong?
>
>~Che
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:256027
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
