I wrote something exactly like this. It sends out a single email per person each time new job is added in a category they have saved.
I don't save anything relating to when the user was mailed. <!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: Sunday, July 02, 2006 4:57 PM To: CF-Talk Subject: Getting the query right Hi guys, I have a job site which when users register they get to choose categories for work which may suit them. I would like to write a schedule that will email the users new jobs if they are in one of their chosen categories. Right now I have a table called UsersToWorkCategory which has the UserID and WorkCategoryID inside. Should I create a new table which will insert a record for everytime an email has been sent to a particular user notifying them of a new job which is one of their categories? Or, do you think it would be better to send out a mass email everytime a new job is added and email all the interested parties that way? Any advice i'd be more than grateful. Thanks, Stuart ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:245298 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
