500 JSON erlaubt keine nicht-endlichen Zahlen

Question

<\/HEAD>Wir erhalten diesen Fehler von einer Anwendung NUR wenn sie ein bestimmtes Textfeld abfragt und der Wert den Buchstaben "E" enthält.<\/P> Wenn wir den Wert "75E003300011" abfragen, erhalten wir den Fehler. Aber wenn wir "750C17200011" abfragen, gibt die App einen Datensatz zurück. Wenn wir dieselben Daten in ArcGIS desktop abfragen, erhalten wir keinen Fehler.<\/P><\/BODY><\/HTML>

HillaryBjorstrom · Answer

Also i was able to query outside of my application. Directly in the Rest Service fine. It seems to happen in the application itself.

HillaryBjorstrom · Answer

Yes i think it is. I have seen this before in sql when converting data in a view. To get past it there I would use a a cast or convert function in the view. i think something simliar would work here. I am asking our programmer if he can add it into our application. Another option that may help you get by would be to add another field and add a letter in the front like S7E054546110. That may help too.

KimMcDonough · Answer

Yes!~ Another voice crying out in the wilderness! This is NOT a problem with the data. For some reason, Arc is interpreting the text field as an Exponential number when it sees an "E". This has to be a bug!