Hi all, I'm writing an app in Cold Fusion that is personalized for each user. I have an SQL Server database that contains user info. The user can enter keywords so that when new products or services arrive that match their keywords, an email will be sent to them about the new product.
I am wondering if I should have one large field in the db that contains a comma separated list of their keywords or if I should set one field for each keyword (up to a maximum of say 10 keywords). Also, when the admin of the site adds a new product to the db, they can enter keywords for that product. Then I would like to send an email to all users where any of the products keywords match any of the users keywords. How should I go about doing this? What would/should the sql statement be? Should each keyword be kept in it's own field or in one field containing all keywords? I don't want to bog down the db. Any ideas would be greatly appreciated. Thanks. Hammy - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Hammy" <[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)
