how would I add the ability to track the date and time of each email per
group (grp1, grp2, grp3)
would I add grp1_sendDate, grp1_sendTime, grp2_sendDate, grp2_sendTime,
grp3_sendDate, grp3_sendTime to listID(identity increment), fname, lname,
email, grp1, grp2, grp3,
<cfquery>
UPDATE MyEmailList
SET grp = grp1 + 1
</cfquery>
-----Original Message-----
From: Charlie Griefer [mailto:charlie.grie...@gmail.com]
Sent: 2009-02-13 13:50
To: cf-talk
Subject: Re: counting questions with cf
INT should work fine. unless you foresee going over 2,147,483,647 trackable
emails (which I suppose is possible... in which case bigint would work as
well... it'd just take up twice the space).
for the actual SQL, you'd want SET grp1 = grp1 + 1
On Fri, Feb 13, 2009 at 10:44 AM, cfcom <cf...@aceligent.com> wrote:
>
> I want to count each time an email is sent to a different group.
>
> I have listID(identity increment), fname, lname, email, grp1, grp2, grp3
> I have 3 groups (grp1, grp2, grp3) that I want to track
>
> My example email goes out to grp1:
>
> Would an UPDATE work for adding the counts
> <cfquery>
> Update MyEmailList
> Set sendcount = grp1 +1
> </cfquery>
>
> And would a dataType of BigInit be correct in the SQL?
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:319297
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
