* This is the modus mailing list * Don't remove the null option...just set a value of 1 in the Spamcount field.
John > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Lapo Nustrini > Sent: Wednesday, November 12, 2003 3:48 PM > To: [EMAIL PROTECTED] > Subject: [Modus] Spam counter on a website? > > * This is the modus mailing list * > > > The funny thing is that I originally tried: > Update tblCounter > set SpamCount = 100 > > And I still got a "(0 row(s) affected)" response... > I even went into the table and edited the field, removing the > NULL option. > > Still no go... > > > Lapo > > > On Wednesday, November 12, 2003, at 12:36 PM, ISOC Network Operations > wrote: > > > * This is the modus mailing list * > > > > Hmm that is odd, only thing I can think of is if the field > Spamcount > > is empty it might act like that but not sure. > > > > Try editing the value for spamcount to 1 then see if you can do the > > update in QA and get it to update it to 2, if so then I would think > > the trigger will start working. > > > > John > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Lapo Nustrini > > Sent: Wednesday, November 12, 2003 3:33 PM > > To: [EMAIL PROTECTED] > > Subject: [Modus] Spam counter on a website? > > > > * This is the modus mailing list * > > > > Hello John, > > > > thanks for the instructions. I just tried implementing them, but I > > can't get it to work. > > > > I setup the new table (tblCounter) > > Created a new Field (SpamCount, int, Null) And created the > Trigger on > > tblMsgCatalog. (If I try to edit the trigger in Query > Analyzer, I get > > the following text to edit: > > > > ALTER TRIGGER [SpamCounter] ON [dbo].[tblMsgCatalog] > > FOR INSERT > > AS > > Update tblCounter > > set SpamCount = SpamCount + 1 > > > > This appears correct to me, however, nothing is happening. > > I think there may be something wrong with the table itself, as if I > > simply run: > > > > Update tblCounter > > set SpamCount = SpamCount + 1 > > > > I get a "(0 row(s) affected)" response. > > > > Do you have any idea what I may have done wrong? > > > > Thanks, > > > > Lapo > > > > > > On Wednesday, November 12, 2003, at 11:44 AM, ISOC Network > Operations > > wrote: > > > >> * This is the modus mailing list * > >> > >> Yup, read my other post, that is exactly what I am doing. > >> > >> John > >> > >> -----Original Message----- > >> From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > >> Behalf Of Lapo Nustrini > >> Sent: Wednesday, November 12, 2003 2:32 PM > >> To: [EMAIL PROTECTED] > >> Subject: [Modus] Spam counter on a website? > >> > >> * This is the modus mailing list * > >> > >> My initial thought was that it would be simplest to setup > the counter > >> in the SQL database itself, and increment it each time a > message is > >> quarantined. > >> A simple query could then be run to check the counter, without > > actually > >> counting the number of records. > >> > >> This would also show the total number of messages caught, > rather than > >> what is currently in the quarantine. > >> > >> However, I really don't know much about MS SQL, so there may be a > >> better idea. > >> (I also don't know how to accomplish this. Probably > something to do > >> with triggers...) > >> > >> Thanks, > >> Lapo > >> > >> > >> On Wednesday, November 12, 2003, at 11:15 AM, Darryl Dunkin wrote: > >> > >>> * This is the modus mailing list * > >>> > >>> I've considered doing this also, but have not had an > accurate way to > >> do > >>> it. The SQLDB only stores the quarantine, so a simple > count of your > >>> current spam quarantine is: > >>> > >>> select count(*) from tblMsgCatalog where msgtype = 2 > >>> > >>> This counter doesn't change much depending on your > expiry, as I keep > > 7 > >>> days worth, I keep around 100k messages. This should match up with > >> what > >>> you see in the console. > >>> > >>> It may be more reasonable to parse out the stats logfile over a > > period > >>> of time instead, although I have not looked into it yet. I am not > > sure > >>> how rebooting or restarting the services effects these numbers. > >>> > >>> -----Original Message----- > >>> From: Lapo Nustrini [mailto:[EMAIL PROTECTED] > >>> Sent: Wednesday, November 12, 2003 11:08 > >>> To: [EMAIL PROTECTED] > >>> Subject: [Modus] Spam counter on a website? > >>> > >>> * This is the modus mailing list * > >>> > >>> > >>> I'd like to setup a (live) counter on our website, > showing how much > >>> spam has been stopped. > >>> However, I'm not sure what the best way to get the data > from the SQL > >>> quarantine is. > >>> > >>> Any suggestions or examples? > >>> > >>> > >>> Thanks, > >>> > >>> Lapo Nustrini > >>> > >>> Seanet Corporation > >>> > >>> 701 Fifth Ave, Suite 6801 > >>> Seattle > >>> 98104 WA > >>> (206) 343 7828 > >>> http://www.seanet.com > >>> > >>> > >>> ** > >>> To unsubscribe, send an Email to: > [EMAIL PROTECTED] with the > >>> word "UNSUBSCRIBE" in the body or subject line. > >>> > >>> ** > >>> To unsubscribe, send an Email to: > [EMAIL PROTECTED] with the > >>> word "UNSUBSCRIBE" in the body or subject line. > >>> > >> > >> > >> ** > >> To unsubscribe, send an Email to: [EMAIL PROTECTED] > with the > >> word "UNSUBSCRIBE" in the body or subject line. > >> > >> > >> ** > >> To unsubscribe, send an Email to: [EMAIL PROTECTED] > with the > >> word "UNSUBSCRIBE" in the body or subject line. > >> > > > > > > ** > > To unsubscribe, send an Email to: [EMAIL PROTECTED] with the > > word "UNSUBSCRIBE" in the body or subject line. > > > > > > ** > > To unsubscribe, send an Email to: [EMAIL PROTECTED] with the > > word "UNSUBSCRIBE" in the body or subject line. > > > > > ** > To unsubscribe, send an Email to: [EMAIL PROTECTED] > with the word "UNSUBSCRIBE" in the body or subject line. ** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line.
