> > The SQL statement as requested follows:
> >
> > Select Start=DateAdd(Second, 0-AcctSessionTime, CallDate),
> > (AcctSessionTime/60)+1, (AcctInputOctets/1000)+1, (AcctOutputOctets/1000)+1,
> > Location, UserName, AcctTerminateCause, Server, NASPort From Calls, Servers
> > Where (Username='edi01034uurk') and CallDate >= '1/6/98' and CallDate <=
> > '2/6/98' and AcctStatusType=2 And NASIdentifier=IPAddress Order by Start
>
> The abve executes w/out error here (not returning any rows, though).
> If you use iswl_w to execute it against your database, what
> error is returned?
>
>
Hi Dale,
The reason why the SQL statement executed without error at your end and not at
ours is because of the field NASIdentifier. Our NAS reports this field as
NASIPAddress. Therefore we changed the fieldname in the RadAttributes table as
well as in the Calls table. Hence the field NASIdentifier does not exist in our
database. How can we get the query to use the name as defined in the dictionary???
--||||||||||||||||||||||||||||||||||||||||||/// /@ @\ ( ) ---o000----( )----000o-------
Elon Alonza RichardsBarbados External TelecommunicationsInternet Engineer
ear@caribsurf.com246 431 6130(w)pager: 246 429 7243 ,ID: 6130