Re: StructFindKey Path and evaluate

2006-04-21 Thread Denny Valliant
Wow. Cubes and rollup sound nifty. I'll have to google up a bit, as I was like "what?". Sad, I know. But all that aside, I think you should think about restructuring your data. Specifically your task logic. You can't do something different? Are you in charge of the DB or is someone forcing this f

RE: StructFindKey Path and evaluate

2006-04-20 Thread Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions
ginal Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 5:22 AM To: CF-Talk Subject: Re: StructFindKey Path and evaluate Yes, I was thinking that a cube of this would probably provide most of the desired info in a query (although I haven't looked closely e

Re: StructFindKey Path and evaluate

2006-04-20 Thread James Holmes
Yes, I was thinking that a cube of this would probably provide most of the desired info in a query (although I haven't looked closely enough to be sure). Does your DB do cube and rollup? On 4/20/06, Thomas Chiverton <[EMAIL PROTECTED]> wrote: > On Wednesday 19 April 2006 17:24, Bruce, Rodney S C-E

Re: StructFindKey Path and evaluate

2006-04-20 Thread Thomas Chiverton
On Wednesday 19 April 2006 17:24, Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions wrote: > If there is a better way to do this, please let me know. I don't really > like the way I am doing it, but unfortunetly I havent come up with anything > better and I do seem to do things the hard way. Get

RE: StructFindKey Path and evaluate

2006-04-19 Thread Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions
>Ya know if that tree was flattened into a few database tables, it'd all be >much easier :-) >-- >Tom Chiverton >Advanced ColdFusion Programmer The information comes from 4 tables. There's many more fields in each table, but here is the short break down. Project_table Proj_id Proj_name WorkPl

Re: StructFindKey Path and evaluate

2006-04-19 Thread Thomas Chiverton
On Monday 17 April 2006 17:07, Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions wrote: > So I am not going to the very bottom of the structure, the value at > MyStruct.ProjectA.Task1.Task1.3, would be a structure not a simple value. Ya know if that tree was flattened into a few database tables, i

RE: StructFindKey Path and evaluate

2006-04-17 Thread Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions
: CF-Talk Subject: Re: StructFindKey Path and evaluate Most likely I missed something, because doesn't structFindKey return a value as well as the path to the key? Unless you're talking about getting the "path" to another key, not the one you just found.? XPath only works wit

Re: StructFindKey Path and evaluate

2006-04-16 Thread S . Isaac Dealey
> Most likely I missed something, because doesn't > structFindKey return a value as well as the path > to the key? Unless you're talking about getting > the "path" to another key, not the one > you just found.? The native function only works on the keys of an individual structure. The issue Bruce

Re: StructFindKey Path and evaluate

2006-04-16 Thread Denny Valliant
Most likely I missed something, because doesn't structFindKey return a value as well as the path to the key? Unless you're talking about getting the "path" to another key, not the one you just found.? XPath only works with XML documents, neh? Hmm... must need more coffee... missing something obvio

RE: StructFindKey Path and evaluate

2006-04-14 Thread Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions
Isaac, Thanks for the

Re: StructFindKey Path and evaluate

2006-04-14 Thread S . Isaac Dealey
> Hi all > I have a structure I am using StructFindKey with. > Which returns an array/Structure. > One of keys returned is Path, which is a dot separated > list of the path thru > the structure to the key your looking for. > Something like: MyStruc.item1.item2.item3.item4 (find key > Item4),