> 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.
hi jeremy so, as long as there's one match within the set? > 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. with ORs > 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? probably, but i would advise a separate table makes the sql so much simpler (e.g. the ORs i mentioned) rudy - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "rudy" <[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)
