> -----Original Message-----
> From: Johnny Le [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 29, 2005 7:56 AM
> To: CF-Talk
> Subject: Re: Best practice question?
>
> Is there a way to capture a row? For example, if you know the value of a
> cell, can you do some structure or array search that would return the row?
> I know we can use query of queries to find it, but I wonder if you know
> another way using array or structure functions.
There really isn't any "magic" way that I know off. I've tried things like
"queryname[rownumber]" and the like but they just don't work (not that you'd
really expect them too).
You're pretty much stuck either doing a QoQ or looping over the row
something like this:
<cfset MyRow = ArrayNew(1) />
<cfloop list="#QueryName.ColumnList#" index="CurColumn">
<cfset ArrayAppend(MyRow, QueryName[CurColum][RowNumberYouWant] />
</cfloop>
I've not been able to get it much smaller/faster than that.
Jim Davis
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200640
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
