w2xq
Mentor
I was searching in NJ/Burlington for only Expired and Cancelled licenses, and an SQL error message popped up. Hope this helps.
"error on FCC Count Query-> AND EN.entity_name NOT REGEXP "New Jersey, STATE OF" AND EN.entity_name NOT REGEXP "New Jersey STATE OF" AND () AND FR.class_station_code NOT IN ("MO","MO2","MO3","MO8") AND (FR.frequency_assigned < "806.0000" OR FR.frequency_assigned > "851.0000")
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.class_station_code NOT IN ("MO","MO2","MO3","MO8") AND (FR.' at line 12"
"error on FCC Count Query-> AND EN.entity_name NOT REGEXP "New Jersey, STATE OF" AND EN.entity_name NOT REGEXP "New Jersey STATE OF" AND () AND FR.class_station_code NOT IN ("MO","MO2","MO3","MO8") AND (FR.frequency_assigned < "806.0000" OR FR.frequency_assigned > "851.0000")
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.class_station_code NOT IN ("MO","MO2","MO3","MO8") AND (FR.' at line 12"