Re: [Emerald] Year 2000 problem
Dale E. Reed Jr. ( (no email) )
Tue, 21 Sep 1999 20:36:09 -0700
Emerald wrote:
>
> BTW Dale,
>
> The radusers in the \radius\beta directory has a problem.
>
> The stored procedures check and add the expire and overdue fields to the
> expire date and come up with the correct expire for the text file, but the
> select part of the script does not take expire and overdue into account when
> selecting so anyone who would be expired but has an extension doesn't get
> selected and so doesn't end up in the users file.
Ok. The check should be:
AND (DateAdd(Day, (ma.Extension+ma.OverDue+1), maExpireDate) >=
GetDate() or maExpireDate is NULL)
I'll update the archive.
--
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart