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.

For more information about this list (including removal) go to: