Steven, Option 2 sounds better to me. You certainly can use a scheduler but might be an overkill for that :) A simple cron job would do. Pat.
> From: pimpmaster <[EMAIL PROTECTED]> > Reply-To: <[email protected]> > Date: Sat, 15 Sep 2007 12:56:40 -0700 > To: OpenWFEru users <[email protected]> > Subject: [openwferu-users] Automated Mailings > > > Greetings Folks, > > I am working on an online music shop and plan on automating some > mailing actions. > > Currently in the planning phases and would love your input on the > following behavior. > > Albums have a :status attribute which will be filled with 3 options > from a select menu: > > 1. Exclusive Promo > When this is selected, emails get immediately sent to an exclusive > group of users to collect feedback. One week later, this field will > automatically change to option 2 and execute its actions > > 2. Public Promo > Album is displayed on the site as a promo release. (Users can buy it > for an elevated price before official release) Two weeks later this > field gets set to option 3. > > 3. Full Release > Album's price is lowered and email is sent out to subscribers. > > Before I tackle the issue of timing, I am trying to decide how to set > up my albums table. > At first glance, I thought that a :status field would do the trick, > but after thinking about it, I wonder if i should do this: > > exclusive_on:date > promo_on:date > release_on:date > > and have a scheduler work off these fields somehow > > Am I on the right track? > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "OpenWFEru users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/openwferu-users?hl=en -~----------~----~----~----~------~----~------~--~---
