------=_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">
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