[Rodopi] No 'On Hold Late' on weekends

[Scott Collins]

Looks like someone's not paying attention to what thread they are responding to  :)  Then again, maybe it was my fault for responding to one and starting a new thread at virtually the same time.  :)   By the way, not that we need another change of subject, but does anyone know why my messages took so long to be distributed to the list.  I sent both messages yesterday just before 2PM local time (CDT) and they didn't arrive in my mailbox until just before 10AM this morning (which actually was 20 minutes AFTER Cary's reply).   Scott   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul Moore Sent: Thursday, June 03, 2004 6:01 PM To: [EMAIL PROTECTED] Subject: [Rodopi] No 'On Hold Late' on weekends Cary, By doing it on a radius profile it in effect removes Rodopi from the picture. What happens is that when the user dials in during a blackout time the user will be rejected, similarly as a simultanius login attempt (which is handled by radius not Rodopi). It doesn't actually suspend the account and thus no accounting issues a dependency on Rodopi to do billing correctly and on time. I haven't had a chance to actually test it and am not sure if it is the proper syntax (but looks good to me). In my case the user wants the account dissabled while they are at work so the kids can't get online and do what kids do. Not sure if they want it on weekend or not. hehe the power at my fingure tips. Guess I had better make a call. Paul Cary Fitch wrote: I don't do this type of programming.  BUT, from other experience, I assume it will block the SAT/Sun effects but,   Will it then actually do the suspend on Monday?   Also you may have to Block FRI/SAT not SAT/SUN because the proceedure runs at midnight,not "in the day" and it may need to be defeated then.   $0.02   Of course the proof of the pudding is in the eating!   Cary Fitch   ----- Original Message ----- From: Scott Collins To: [EMAIL PROTECTED] Sent: Thursday, June 03, 2004 1:49 PM Subject: [Rodopi] No 'On Hold Late' on weekends We use Rodopi 5.2 sp3 and I have been passed the request to NOT put customers on hold for late payment on the weekends when our accounting staff is not available.  I believe I have found the stored procedure that puts the accounts on hold but I wanted to check with some of you Rodopi and SQL gurus to be sure I'm looking in the right place, as well as make sure this should work and not cause any additional problems.  Below are the first dozen or so lines of the SP along with my simple edit.  If I am correct, this should prevent the procedure from running on Saturday and Sunday and if I am reading the procedure correctly, any users who would have went on hold over the weekend will be found and put on hold when the procedure runs on Monday.  Anyone see any errors in my thinking? CREATE Procedure Maint_OnHoldLateSuspend         @CustomerID int = NULL,         @Proc int = 0 output As set nocount on if datename(dw, getdate()) IN ('Saturday', 'Sunday')         return 0 select @Proc= 0 declare @DateLateSuspCC smalldatetime,                 @DateLateSuspCheck smalldatetime,                 @DateLateSuspACH smalldatetime,                 @DateLateSuspCorpCheck smalldatetime,                 @BillingDate smalldatetime