You've got the wrong data structure. If you want to look up a value and get it's key, you need a data structure that matches that use case: a CF struct.
<cfset s = structNew() /> <cfloop query="cur_disclaimers"> <cfset s[value] = currentRow /> </cfloop> cheers, barneyb On Jan 8, 2008 11:41 AM, Robert Harrison <[EMAIL PROTECTED]> wrote: > I'm creating an array. It's a list of record numbers to be looked up later. > This is the code. > > <cfset DiscArray = ArrayNew(1)> > <cfset disnum=1> > > > <cfloop query="cur_disclaimers"> > <cfset DiscArray[disnum]=#id#> > <cfset disnum=#disnum# +1> > </cfloop> > > > After the array is built it will be a list of key and id numbers, like below > (only much longer): > > Key Value > 1 17 > 2 24 > 3 37 > 4 8 > 5 32 > > I need to be able to do two things: > > 1. Look in the array to see if a value exists and, if so, return the > key. > > 2. Loop through the array, output the key and use the value in a > query. > > I've tried 300 things. None worked. Any ideas? > > > > > Robert B. Harrison > Director of Interactive services > Austin & Williams > 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 > T : 631.231.6600 Ext. 119 > F : 631.434.7022 > www.austin-williams.com > > Great advertising can't be either/or... It must be &. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296184 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4