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
