[RadiusNT] RadiusNT v4.0.21 Update Serverports query

Serkan SUBASI ( (no email) )
Wed, 10 Jul 2002 16:08:26 +0300

This is a multi-part message in MIME format.

------=_NextPart_000_006F_01C2282C.08728470
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

May "Update Serverports" query like this (for MS SQL Server)

WITH (ROWLOCK)

this one comes from the current RadiusNT 4.0.21

UPDATE ServerPorts SET
UserName='bmese',NasPortType=0,AcctStatusType=1,AcctSessionID='379414340
',NASPortDNIS='2000024',FramedAddress='213.153.128.12',CallDate='2002070
8
13:5:30',AccountID=NULL,CallerID=NULL,ConnectInfo=NULL,AcctTerminateCaus
e=NULL,LastReset=NULL,RSPCheck=NULL,AscendDisconnectCause=NULL FROM
Servers s (NOLOCK), ServerPorts sp (NOLOCK) WHERE sp.ServerID =
s.ServerID AND COALESCE(sp.IPAddress,s.IPAddress)='212.156.29.244' AND
sp.Port=20216 AND ('20020708 13:5:30' >= sp.CallDate OR sp.CallDate IS
NULL)

I think the better one

UPDATE sp SET
UserName='bmese',NasPortType=0,AcctStatusType=1,AcctSessionID='379414340
',NASPortDNIS='2000024',FramedAddress='213.153.128.12',CallDate='2002070
8
13:5:30',AccountID=NULL,CallerID=NULL,ConnectInfo=NULL,AcctTerminateCaus
e=NULL,LastReset=NULL,RSPCheck=NULL,AscendDisconnectCause=NULL FROM
Servers s (NOLOCK), ServerPorts sp (ROWLOCK) WHERE sp.ServerID =
s.ServerID AND COALESCE(sp.IPAddress,s.IPAddress)='212.156.29.244' AND
sp.Port=20216 AND ('20020708 13:5:30' >= sp.CallDate OR sp.CallDate IS
NULL)

Serkan SUBASI
Turk Nokta Net

------=_NextPart_000_006F_01C2282C.08728470
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
Message

May "Update Serverports" query like this (for MS SQL=20Server)

WITH =(ROWLOCK)

this one comes=20from the current RadiusNT 4.0.21

UPDATE ServerPorts SET=20UserName=3D'bmese',NasPortType=3D0,AcctStatusType=3D1,AcctSessionID=3D'37=9414340',NASPortDNIS=3D'2000024',FramedAddress=3D'213.153.128.12',CallDat=e=3D'20020708=2013:5:30',AccountID=3DNULL,CallerID=3DNULL,ConnectInfo=3DNULL,AcctTerminat=eCause=3DNULL,LastReset=3DNULL,RSPCheck=3DNULL,AscendDisconnectCause=3DNU=LL=20FROM Servers s (NOLOCK), ServerPorts sp (NOLOCK) WHERE sp.ServerID =3D=20s.ServerID  AND =COALESCE(sp.IPAddress,s.IPAddress)=3D'212.156.29.244' AND=20sp.Port=3D20216 AND ('20020708 13:5:30' >=3D sp.CallDate OR =sp.CallDate IS=20NULL)

I think the better one

UPDATE sp SET=20UserName=3D'bmese',NasPortType=3D0,AcctStatusType=3D1,AcctSessionID=3D'37=9414340',NASPortDNIS=3D'2000024',FramedAddress=3D'213.153.128.12',CallDat=e=3D'20020708=2013:5:30',AccountID=3DNULL,CallerID=3DNULL,ConnectInfo=3DNULL,AcctTerminat=eCause=3DNULL,LastReset=3DNULL,RSPCheck=3DNULL,AscendDisconnectCause=3DNU=LL=20FROM Servers s (NOLOCK), ServerPorts sp  (ROWLOCK) WHERE sp.ServerID =3D s.ServerID  =AND=20COALESCE(sp.IPAddress,s.IPAddress)=3D'212.156.29.244' AND =sp.Port=3D20216 AND=20('20020708 13:5:30' >=3D sp.CallDate OR sp.CallDate IS =NULL)


Serkan=20SUBASI
Turk Nokta Net

------=_NextPart_000_006F_01C2282C.08728470--