SQL query error

Status
Not open for further replies.

w2xq

Mentor
Joined
Jul 13, 2004
Messages
2,024
Location
Burlington County, NJ
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"
 

Cloydlane

Newbie
Joined
Sep 27, 2011
Messages
2
U should go through ur new MySql server version manual..there might be change in the syntax of count function..
 
Status
Not open for further replies.
Top