Hi Jeremy. I've never used these but perhaps ListContains and ListContainsNoCase. The nocase one as you can probably guess is NOT case sensitive whereas the other is.
Out of curiosity, why keep these values in a list as opposed to a "match" table?.... for example a table with userids and provincecodes, countrycodes and the other matchable values, and just use a true/false value in the "codes" columns. Then you can use the match table for a comparison. Karl > From: Jeremy Oudit <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Thu, 16 May 2002 06:50:01 -0700 > To: [EMAIL PROTECTED] > Subject: [CFTALKTor] Multiple variable comparisons. > > I'm trying to build something for a client that will allow people to match > up with each other based on a variety of different criteria. > > Each person fills out the same form but they are allowed to make multiple > selections for each criteria. For example if one person chose ON, NS, QU as > their Provinces and another person chose ON, MN, BC. That would register as > a match. Here is the tricky bit. the Client wants to allow the user to be > able to choose multiple Countries and about 8 other variables are also going > to have more than 1 possible answer. I'm not sure how to handle this. > > Another Question. > Right now all of the multiple variables are stored in the same field as > comma delimitated lists. Is there a way I can compare a list to a list? If I > can do that I'll be set. > > > - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "A. Karl Zarudny" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
