captclint
Mentor
Everything seems to be working with the FCC DB except Last 100 FCC License Grants. They were working this morning, so you may not be aware of this yet.
Last 100 FCC License Grants
- Thread starter captclint
- Start date
- Status
I am getting the error too. Here is what it says,
error on FCC Regular Query->
SELECT DISTINCT EN.entity_name,EN.call_sign, FR.frequency_assigned,FR.cnt_mobile_units,FR.cnt_mob_pagers,FR.class_station_code, HD.radio_service_code,HD.grant_date, LO.location_state,LO.location_city FROM EN,FR,HD,LO WHERE LO.ctid= AND FR.frequency_assigned > '30.0000' AND EN.unique_system_identifier=FR.unique_system_identifier AND EN.unique_system_identifier=HD.unique_system_identifier AND EN.unique_system_identifier=LO.unique_system_identifier AND FR.unique_system_identifier=LO.unique_system_identifier AND EN.entity_name != "" AND EN.entity_type != "CL" AND HD.license_status != "E" ORDER BY HD.grant_date DESC LIMIT 100 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND FR.frequency_assigned > '30.0000' ' at line 8
error on FCC Regular Query->
SELECT DISTINCT EN.entity_name,EN.call_sign, FR.frequency_assigned,FR.cnt_mobile_units,FR.cnt_mob_pagers,FR.class_station_code, HD.radio_service_code,HD.grant_date, LO.location_state,LO.location_city FROM EN,FR,HD,LO WHERE LO.ctid= AND FR.frequency_assigned > '30.0000' AND EN.unique_system_identifier=FR.unique_system_identifier AND EN.unique_system_identifier=HD.unique_system_identifier AND EN.unique_system_identifier=LO.unique_system_identifier AND FR.unique_system_identifier=LO.unique_system_identifier AND EN.entity_name != "" AND EN.entity_type != "CL" AND HD.license_status != "E" ORDER BY HD.grant_date DESC LIMIT 100 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND FR.frequency_assigned > '30.0000' ' at line 8
- Status
