Last 100 FCC License Grants

Status
Not open for further replies.

captclint

Mentor
Premium Subscriber
Joined
Dec 31, 2005
Messages
2,452
Location
Mountaintop, PA
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.
 

click23

Member
Joined
Aug 8, 2003
Messages
365
Location
Athens, Tennessee
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
 
Status
Not open for further replies.
Top