16 Jun
2008
16 Jun
'08
7:33 p.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