17 Jun
2008
17 Jun
'08
2:33 a.m.
El Martes, 17 de Junio de 2008, David Villasmil escribió:
select *, UNIX_TIMESTAMP(AcctStartTime) as timestamp
from radacct where
(1=1) and Normalized = '0' and AcctStopTime != '0000-00-00 00:00:00'
and
(ConnectInfo_stop is not NULL or MediaInfo is NULL or MediaInfo != '')
MediaInfo (after update from mediaproxy) is NOT null... the rest of the
fields are ok.
Look again at the SQL query of above:
MediaInfo is NULL or MediaInfo != ''
It's not needed that MediaInfo is NULL, it can be any value except NULL or
empty string.
--
Iñaki Baz Castillo