That's definately a clever way to crack that nut, thanks Charlie. In this case
the source query won't be too big.
But it seems odd that after all this time with we still don't have a
Query(); function.
-Original Message-
From: Charlie Stell [mailto:charlie.st...@gmail.com]
Sent: Wednesday, May 26, 2010 2:18 AM
To: cf-talk
Subject: Re: Retrive query cell value by key/value pair instead of row number?
When I've had to deal with the same situation previously, I usually created a
"lookup" structure based on the column ill use as a handle - mystruct[value I
want to ref by]=row index from query (this struct would get populated by
looping over whole query) . This index then can be used to get at that row... I
do seem to remember however that there's now a cfscript verion of cfquery (I
don't remember if it supports query of querys). If that doesn't work, you could
write a function that takes a colname, col value and query name, and perform a
qoq- assuming the function will have access to the original query...
Hope that helps!
On 5/26/10, Jon Sala wrote:
>
> Is it possible to retreive from a query in memory a cell value by a
> key value pair, ie other than the usual row number: myquery.columname[i]?
> Something like myquery.columname[myquery.keyval:thisquery.Id]
> For example, in a block I'm looping through a query, and
> under certain conditions I need to retrieve a cell value from a
> previous query using a current keyval.
>
> I guess the real problem is I'm looking for a simple equivalent to
> usable inside . Is
> coldfusion.server.ServiceFactory the only way out?
>
> Don't even know if any of this makes sense... I think I need to get
> some sleep.
>
> --
> Jon
>
> This message and any attached documents are only for the use of the
> intended recipient(s), are confidential and may contain privileged
> information. Any unauthorized review, use, retransmission, or other
> disclosure is strictly prohibited. If you have received this message
> in error, please notify the sender immediately, and then delete the original
> message. Thank you.
>
>
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334005
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
