Re: StructFindValue Question...

2006-10-10 Thread Deanna Schneider
-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

RE: StructFindValue Question...

2006-10-10 Thread Dan G. Switzer, II
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

StructFindValue Question...

2006-10-09 Thread Che Vilnonis
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 1s are returned in the query *w/o looping through

RE: StructFindValue Question...

2006-10-09 Thread Dan G. Switzer, II
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

RE: StructFindValue Question...

2006-10-09 Thread Che Vilnonis
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

RE: StructFindValue Question...

2006-10-09 Thread Ben Nadel
. .. 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

RE: StructFindValue Question...

2006-10-09 Thread Che Vilnonis
: 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

Re: StructFindValue Question...

2006-10-09 Thread Aaron Rouse
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