Re: structFindValue

2010-01-21 Thread Leigh
> How do I output a value in that structure? The same as usual, just a little more convoluted ;) #theArray[indexOfTheElementYouWant].owner.cost# ~| Want to reach the ColdFusion community with something they want? Let t

RE: structFindValue

2010-01-21 Thread Chad Gray
Thanks Jason! That worked. I would putting the [] in the wrong place. -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Thursday, January 21, 2010 12:52 PM To: cf-talk Subject: re: structFindValue I think you just want #myVar[1].Owner.Cost

re: structFindValue

2010-01-21 Thread Jason Fisher
I think you just want #myVar[1].Owner.Cost# ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message

structFindValue

2010-01-21 Thread Chad Gray
Ok... so structFindValue returns and array with a structure in it. How do I output a value in that structure? I CFDump it and it has this in it, hopefully you understand what I mean. Array 1 Struct 1 Key - Type Owner Struct Cost - 50

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

Re: StructFindValue Question...

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

Re: StructFindValue Question...

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

RE: StructFindValue Question...

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

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. The

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: select count(OptNurseryOnly) from queryName where OptNurseryOnly = 1 That would give you

RE: StructFindValue Question...

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

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 "1"s are returned in the query *w/o

Re: Problem with StructFindValue

2006-07-13 Thread Raymond Camden
I believe this may have been a bug in CF5. You may need to switch to a manual search, or see if there are hot fixes for CF5. On 7/13/06, Dave Francis <[EMAIL PROTECTED]> wrote: > Hi, > I'm on CF5.0 > > With StructFindValue(structName,"searchterm","ONE

RE: Problem with StructFindValue

2006-07-13 Thread Mark A Kruger
Post the actual code... -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: Thursday, July 13, 2006 11:15 AM To: CF-Talk Subject: Problem with StructFindValue Hi, I'm on CF5.0 With StructFindValue(structName,"searchterm","ONE"), everyth

Problem with StructFindValue

2006-07-13 Thread Dave Francis
Hi, I'm on CF5.0 With StructFindValue(structName,"searchterm","ONE"), everything is fine if the search term is one word. But when it is two (or more) words, I get this error: StructFindValue(): Illegal value string specifed. Value string: "AAA BBB"

structFindValue document bug or CFMX bug?

2002-11-05 Thread Chris Kief
>From reading the CFMX documentation (CFMX CFML reference book) I'm under the impression that the structFindValue function takes either a structure or an array from which to start the search. Pg. 631 - Parameter: Top, Description: ColdFusion object (a structure or an array) from which