Hmmm. I'm just trying to use what code has the least amount of overhead. Perhaps I would be better just using the ValueList function instead of Q of Q?
Thanks, Che -----Original Message----- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Monday, October 09, 2006 5:20 PM To: CF-Talk Subject: RE: StructFindValue Question... I agree with Dan... No matter how complex the query is, query of queries should be able to handle it. I doubt any sort of StructFind type thing would be more powerful than a query of queries. Maybe if you gave us more info, we could help you construct your query of queries. ....................... Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -----Original Message----- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Monday, October 09, 2006 5:14 PM To: CF-Talk Subject: RE: StructFindValue Question... 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? -----Original Message----- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Monday, October 09, 2006 5:11 PM To: CF-Talk Subject: RE: StructFindValue Question... 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:256030 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4