Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 3.5 > ASP.NET 3.5 Professionals
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
ASP.NET 3.5 Professionals If you are an experienced ASP.NET programmer, this is the forum for your 3.5 questions. Please also see the Visual Web Developer 2008 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 3.5 Professionals section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old May 19th, 2009, 02:20 PM
Authorized User
 
Join Date: Jun 2006
Location: Chelmsford, MA, USA.
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
Default A/B testing 2 or more subject lines

Any idea how to update table with multiple subjects for one email distribution on % basis in ASP.NET/MySQL.

For example: We have a list of 1000 contacts (email addresses) and want to send email with different subjects on percentage basis.

Email body is same.

User selected # subjects, entered subject names and percentages.

Subject 1 : GPS on sale ------------ (user selected - 30%)
Subject 2: GPS Free------------ (user selected - 50%)
Subject 3: GPS - Upto 70% off------------ (user selected - 20%)

i.e

30% (300) of the emails should go out with Subject 1
50% (500) of the emails should go out with Subject 2
20% (200) of the emails should go out with Subject 3

-------------------------------------------------------------------------------------
Current Scenario:

1. All the above settings are stored in distributionsetup table (emailid, contactlistid, subject1,subject2,subject3, percent1,percent2,percent3,datetobesent etc....)
2. System will insert 1000 rows in distributionqueue table with subject1.
INSERT INTO distributionqueue (subject, fromname, fromemail, tofirstname,tolastname, toemail, company, datetobesent, sentstatus etc...)
SELECT 'GPS on sale' subject, fromname, fromemail, tofirstname,tolastname, toemail, company, '2009-05-20 10:00:00' FROM AddressBook where contactlistid= 1;
3. System will send email to 1000 contacts with the same subject (subject1)
------------------------------------------------------------------------------------

Requirement :

We need to update distributionqueue table randomly with following criteria.
50% (500) rows should get updated with Subject 2
20% (200) rows should get updated with Subject 3

Hope i explained well, let me know if you have any questions.

Any help highly appreciated.

Thank you

Last edited by ramuis78; May 20th, 2009 at 12:17 AM. Reason: Not mentioned clearly
  #2 (permalink)  
Old May 20th, 2009, 11:58 AM
Authorized User
 
Join Date: Jun 2006
Location: Chelmsford, MA, USA.
Posts: 85
Thanks: 0
Thanked 0 Times in 0 Posts
Default Update command?

Any idea how to write update command for the above scenario?
__________________
Rams
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to get support on this subject! retribution All Other Wrox Books 4 January 9th, 2009 09:09 AM
subject anabnl BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 0 August 16th, 2007 06:35 PM
test subject tanu80 ASP.NET 1.x and 2.0 Application Design 1 June 28th, 2007 05:08 AM
E-mail Subject mani_he Pro PHP 2 April 29th, 2005 12:32 PM



All times are GMT -4. The time now is 03:43 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.