Thank you Danny, that cleared up the lookup date issue. Now to get
ServerPorts working with Manual Calls Update or send stop record only
option in the Radius Admin GUI, I get this error.
SQL Statement: UPDATE Servers AS s, ServerPorts AS sp
SETAcctStatusType=2,UserName='lambie',FramedAddress='216
..94.224.70',CallDate='2000-04-30 11:25:39' FROM Servers s, ServerPorts
sp WHERE sp.ServerID = s.ServerID AND s
..IPAddress='216.94.224.3' and sp.Port=0 AND (DateAdd('s', 0-0,
'2000-04-30 11:25:39') >= sp.CallDate OR sp.Cal
lDate IS NULL)
ODBC Error [37000] -3503:[Microsoft][ODBC Microsoft Access 97 Driver]
Syntax error in UPDATE statement. [UPDAT
E Servers AS s, ServerPorts AS sp
SETAcctStatusType=2,UserName='lambie',FramedAddress='216.94.224.70',CallDate
='2000-04-30 11:25:39' FROM Servers s, ServerPorts sp WHERE sp.ServerID
= s.ServerID AND s.IPAddress='216.94.2
24.3' and sp.Port=0 AND (DateAdd('s', 0-0, '2000-04-30 11:25:39') >=
sp.CallDate OR sp.CallDate IS NULL) ]
Sending Accounting Ack of id 29 to d85ee003 (NAS-GAND)
Danny Sinang wrote:
> Assuming your datestart and dateend are of type Date, then your date
> values should be surrounded by the # character. Your SQL Statement
> would then look like this : sql="SELECT Sum([AcctSessionTime]) AS
> [SumDuration] FROM [calls] WHERE UserName='"_
> & username & "' AND CallDate >= #" & datestart & "# AND
> callDate <= #" &_
> dateend & "#"
> - Danny Sinang
--Mike KovacichSystem Administratorsysadmin@inter-pc.comInter-PC Internet ServicesWarpLink Communicationshttp://www.inter-pc.com
--------------184DAE10F8FE295C20DEA2F7Content-Type: text/html; charset=us-asciiContent-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
Thank you Danny, that cleared up the lookup date issue. Now to get ServerPortsworking with Manual Calls Update or send stop record only option in theRadius Admin GUI, I get this error.SQL Statement: UPDATE Servers AS s, ServerPorts AS spSETAcctStatusType=2,UserName='lambie',FramedAddress='216
.94.224.70',CallDate='2000-04-30 11:25:39' FROM Serverss, ServerPorts sp WHERE sp.ServerID = s.ServerID AND s
.IPAddress='216.94.224.3' and sp.Port=0 AND (DateAdd('s',0-0, '2000-04-30 11:25:39') >= sp.CallDate OR sp.Cal
lDate IS NULL)
ODBC Error [37000] -3503:[Microsoft][ODBC Microsoft Access97 Driver] Syntax error in UPDATE statement. [UPDAT
E Servers AS s, ServerPorts AS sp SETAcctStatusType=2,UserName='lambie',FramedAddress='216.94.224.70',CallDate
='2000-04-30 11:25:39' FROM Servers s, ServerPorts spWHERE sp.ServerID = s.ServerID AND s.IPAddress='216.94.2
24.3' and sp.Port=0 AND (DateAdd('s', 0-0, '2000-04-3011:25:39') >= sp.CallDate OR sp.CallDate IS NULL) ]
Sending Accounting Ack of id 29 to d85ee003 (NAS-GAND)
Danny Sinang wrote:
Assuming your datestartand dateend are of type Date, then your date values should be surroundedby the # character. Your SQL Statement would thenlook like this : sql="SELECT Sum([AcctSessionTime])AS [SumDuration] FROM [calls] WHERE UserName='"_
& username &"' AND CallDate >= #" & datestart & "# AND callDate <= #" &_
dateend & "#"- Danny Sinang--
Mike Kovacich
System Administrator
sysadmin@inter-pc.comInter-PC Internet Services
WarpLink Communications
http://www.inter-pc.com
--------------184DAE10F8FE295C20DEA2F7--