I use data tables to display results of races that we time on a classic asp website (
https://www.gopherstateevents.com/results/fitness_events/results.asp?event_type=5&event_id=883&race_id=1516). This weekend the results of one of our bigger races showed a Data Table error until I figured out that one person's name was incorrectly entered, with a "/" inserted (ie: Johns/on). There were no issues in the way the results were calculated and displayed everywhere except in our data tables.
Here is my question: Are there other characters that will prevent JQuery data tables rendering? Also, should I build some error trapping in to prevent these characters (ie: Replace(FirstName, "/", ""). Seems like a lot of processing for something that is so unlikely to happen?
Thanks in advance.
I tried to reproduce without success.
Data is data, until producing invalid JSON, you should not have any issue. For some reason your JSON was not valid and it throw a JavaScript error, it's not about DataTables but about producing valid JSON data.