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
