I'm having a brain drain on a simple increment
I need to log and count who sends an email, how often it's sent, which
category its sent from and how many times a recipient gets it. I'm sure
theres a better way
===================================================
Sender Table:
Sender_id, Fname, lname, address, email, date, category, count
Recip Table:
Recip_id, Recip_Fname, Recip_lname, Recip_email,
Category_Count Table:
BlueGroup_id (int), Bluecreate_date, Bluecreate_time, Bluecount,
Bluesentby_email, BlueRecip_id
RedGroup_id (int), Redcreate_date, Redcreate_time, Redcount,
Redsentby_email, RedRecip_id
YellowGroup_id (int), yellowcreate_date, yellowcreate_time, yellowcount,
yellowsentby_email, YellowRecip_id
WhiteGroup_id (int), Whitecreate_date, Whitecreate_time, Whitecount,
Whitesentby_email, WhiteRecip_id
<Cfquery name="updateuser' >
Insert into sender (fname, lname, email, date, etc)
</cfquery>
<cfquery name='update_count">
UPDATE Category_Count
SET count = count +1
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320193
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
