Hi Chris I would set this up with an inbetween many to many table. This table would have Service\ or ProductId & keyword and a date changed and user who updated it. The Service or ProductId would be an integer code with the detail in a lookup table. Keyword would be a varchar field unless there were going to be lots of repeats.
This would be faster for searches for the field could be indexed. A search on a memo or field with a "select ... where keyword like ... " would have to be slower. Then again this all depends on how many records you have. If you were not doing any searching then the comma list could work. Chris Ham wrote: > > 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. > > Chris > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: "Chris Ham" <[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) -- Cheers Glenn Shukster (Logic Fundamentals Inc.) Thornhill, Ont. Canada Phone:(905)771-6458 Fax:(905)771-6819 www.logicfundamentals.com President of TDUG www.tdug.com - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: Glenn Shukster <[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)
