RE: Searching with ListFind
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=listsbody=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
RE: Searching with ListFind
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=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
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=listsbody=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
RE: Searching with ListFind
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=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com