You can reference a query as a 2-D array.
> -----Original Message-----
> From: Brian Scandale [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 01, 2002 8:29 PM
> To: CF-Talk
> Subject: RE: Searching with ListFind
>
>
> Yeah, I know... stupid question. ;-(
>
> I was thinking that there was some internal list ready for
> use... that I just needed to know what and how to address it.
>
> Brian
>
> At 04:58 PM 10/1/02, you wrote:
> >Well, I suppose you don't have to define the list if you
> don't want to.
> >
> ><cfif ListFind(ValueList(query.colum),value)>Do Something
> Here If test
> >value Exists</cfif>
> >
> >
> >
> >-----Original Message-----
> >From: Brian Scandale [mailto:[EMAIL PROTECTED]]
> >Sent: Tuesday, October 01, 2002 2:40 PM
> >To: CF-Talk
> >Subject: Searching with ListFind
> >
> >I have a query that will return one column perhaps with 3 or
> four rows.
> >
> >I want to check the column for the existence of a specific
> test value.
> >
> >I do NOT want to loop over the query checking each value to see if it
> >matches the test value because I need to do this on every row output
> >from another query... perhaps as many as 300 rows.
> >
> >----------------------
> >I think I want to use:
> >
> ><cfif ListFind(list, value [, delimiters ])>Do Something Here If test
> >value Exists</cfif>
> >
> >However... How do I specify the list in the above function?
> Doesn't a
> >query have some predefined list I can use?
> >
> >
> >Or am I forced to first define the list like this?
> >
> ><cfset theList = ValueList(query.column [, delimiter ])>
> >
> >
> >Thanks,
> >Brian
> >
> >
> >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
