Nope, as far as I know that's how you do it, and believe me you really haven't seen a stupid question until you've been to my hamster bulletin board... :) http://www.hamsterific.com/BBS/BulletinBoard.cfm -Ken
-----Original Message----- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 5: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 Get the mailserver that powers this list at http://www.coolfusion.com
