CallerID shows ok
ConnectInfo NOT SHOWING
CallsOnline View
if exists (select * from sysobjects where id = object_id('dbo.CallsOnline')
and sysstat & 0xf = 2)
drop view dbo.CallsOnline
GO
CREATE VIEW CallsOnline(NASIdentifier, NASPort, Username,AcctStatusType,
CallDate, FramedAddress, ConnectInfo, CallerID) AS
Select s.IPAddress, Port, Username, AcctStatusType, CallDate,FramedAddress,
ConnectInfo, CallerID
>From ServerPorts sp, Servers s
Where s.ServerID=sp.ServerID
GO
FIELD IS IN CALLS TABLE
ConnectInfo varchar 32
FIELD IS IN ServerPorts TABLE
ConnectInfo varchar 32
How do I get ConnectInfo to work what am I missing?
Regards David Moore
Moored@romtech.com.au