Hi Jose,
Do you log every e-mail that users send in a database? You could do a count on
everything sent in the past 24 hours before entering the next message.
In SQL Server something like this would work:
IF SELECT count(emailid) FROM EmailTable WHERE user = X AND dateentered > DATEADD(hh,
-24, getdate()) > 5000
return 0
ELSE
BEGIN
insert e-mail
return 1
END
------------------------------------------------------
Marc Lichtenfeld
Senior Programmer/Technology Lead
www.bigdough.com
-----Original Message-----
From: Jose Gosende [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 10:50 AM
To: inFusion Support List
Subject: RE: [iMS] capping outgoing mail
cfx_imsMail
thnx, jose
-----Original Message-----
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 10:44 AM
To: inFusion Support List
Subject: Re: [iMS] capping outgoing mail
What I mean is - how do the mails get into the queue? From the SMTP or
Relay server? From the cfx? Something else?
Regards,
Howie
----- Original Message -----
From: "Jose Gosende" <[EMAIL PROTECTED]>
To: "inFusion Support List" <[EMAIL PROTECTED]>
Sent: Thursday, January 16, 2003 10:33 AM
Subject: RE: [iMS] capping outgoing mail
> I want to restrict the amount of emails a user
> can send over time (haven't decided if within
> a day or over a week, month, etc.). If it makes
> it easier for you, you can use the daily example.
> ie: John Doe can only send 5,000 emails a day.
>
> thanks Howie.
>
> Jose
>
==^=======================================================
This list server is Powered by iMS
"The Swiss Army Knife of Mail Servers"
--------------------------------------
To leave this list please complete the form at
http://www.coolfusion.com/iMSSupport.cfm
Need an iMS Developer license? Sign up for a free license here:
http://www.coolfusion.com/iMSDevelopers.cfm
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
Note: You are subscribed as [email protected]
==^=======================================================
