Search-queries return SQL-code instead of "zero records found"

[QDP2012]

Good morning RRDBAs,

In case it matters, the following 3 comparisons are examples of searches that display SQL-code instead of the standard "zero-records-found" message, when different choices/buttons are selected in the FCC License Search tool.

• Comparison 1:
  
  This link:

  http://www.radioreference.com/apps/db/?action=fccLicenses&ctid=1179&os=0&s=ent&bf=24

  
  properly shows zero-records-returned.
  
  But, this link:

  http://www.radioreference.com/apps/db/?action=fccLicenses&ctid=1179&os=0&s=ent&bf=536

  
  returns SQL-code as a system-error
  
  
  
• Comparison 2:
  
  This link

  http://www.radioreference.com/apps/db/?action=fccLicenses&ctid=1179&os=0&s=ent&bf=16

  
  properly shows zero-records-returned
  
  But, this link

  http://www.radioreference.com/apps/db/?action=fccLicenses&ctid=1179&os=0&s=ent&bf=528

  
  returns SQL-code as a system-error.
  
  
  
• Comparison 3:
  
  This link

  http://www.radioreference.com/apps/db/?action=fccLicenses&ctid=1179&os=0&s=ent&bf=8

  
  properly shows zero-records-returned
  
  But, this link:

  http://www.radioreference.com/apps/db/?action=fccLicenses&ctid=1179&os=0&s=ent&bf=520

  
  returns SQL-code as a system-error.

Thanks for your time and consideration.


Hope this helps,

 

[a417]

problem seems to follow the "expired license" toggle being set, when the query should return a 0.

 

[QDP2012]

problem seems to follow the "expired license" toggle being set, when the query should return a 0.

That's what I was seeing as well...
1) that if the search for a specific type with "Expired = off" should return zero records, then that same search with the "Expired = on" returns the SQL-code, and
2) If the search with "Expired = off" should return at least one record, then the same search with the "Expired = on" will not show the SQL-code.

At least that is what I've seen so far with this one target system, without doing extensive search-testing on other systems. There might be other combinations of search-choices which would also show SQL-code. If anyone finds other such combinations, please feel free to post the information in this thread.

Thanks,

 

[blantonl]

Fixed!

 

[QDP2012]

Thank you sir.