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:256026 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4