1. <cfset IDFound=false> <cfloop from=1 to=#ArrayLen(DiscArray)# index=i> <cfif DiscArray[i]=SearchID> <cfset IDFound=true> <cfbreak> </cfif> </cfloop>
2. <cfloop from=1 to=#ArrayLen(DiscArray)# index=i> <cfquery name=queryname datasource=ds> Query Statement </cfquery> </cfloop> > -----Original Message----- > From: Robert Harrison [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 08, 2008 2:41 PM > To: CF-Talk > Subject: Array Read / Output Help > > 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:296252 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4