Thanks, but, in ISQL, I get an error: 'Msg 241, Level 16, State 3
Syntax error converting DATETIME from character string.' when running your
script. Where might the problem be?
Jim
At 01:42 PM 1/9/2000 -0800, you wrote:
>It's a bug in the RadGetUser stored procedure found in the install/upgrade
>scripts for RadiusNT databases.
>
>Replace the proc below with the one currently in your mssql db.
>
>(Don't do this if your using Emerald)
>
>CREATE PROCEDURE RadGetUser @user VARCHAR(64) , @password VARCHAR(32) AS
>SELECT sa.AccountID, sa.Login, sa.Password, NULL, sa.AccountType,
>sa.LoginLimit, sa.TimeLeft,
>MasterExpire=CASE WHEN maExpireDate IS NULL THEN NULL ELSE
>DATEDIFF(Day,'Jan
>11970',DATEADD(Day,ma.Extension+ma.OverDue,maExpireDate)) END,
>SubExpire=CASE WHEN saExpireDate IS NULL THEN NULL ELSE DATEDIFF(Day,'Jan
>1 1970',DATEADD(Day,sa.Extension,saExpireDate))
>END FROM SubAccounts sa, MasterAccounts ma
> WHERE sa.CustomerID = ma.CustomerID
> AND sa.Active <> 0
> AND ma.Active <> 0
> AND sa.Login = @user
> AND (@password IS NULL OR sa.Password = @password)
>GO
>
>ciao,
>Peter
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
----------------------------
hostmaster@interaxs.net
www.interaxs.net
InterNet Access Network
Voice: 937-461-3660 Fax:937-228-2773
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart