[Emerald] CallerID

Malcolm Joosse ( (no email) )
Tue, 29 Feb 2000 22:53:15 +1100

Hello Dale and all,
Awhile back I asked how to enter into the call tables so I could see
callerID numbers in the Online section in Emerald.
I put in what Dale told me into the ISQL/w:
ALTER TABLE calls ADD CallerID varchar (20) NULL

And I got this error:
Msg 2705, Level 16, State 2
Column names in each table must be unique. Column name 'CallerID' in table
'calls' is specified more than once.

I checked and found that it was in the calls table, I still do not see any
CLID in Emerald/Online.
I then found an attribute in Accounts/Radius "caller ID" so I added it to a
test account.
I do not see the test user logged in EM/Online at all.
Am I missing something here ?
My SQL guy starts in 2 weeks and I need this sorted ASAP as we are getting
repeated dialins from an unknown person and I am hoping to catch his number.

Thank you

Malcolm

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart