-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
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
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
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
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
.
..
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
: 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
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
8 matches
Mail list logo