500 JSON n'autorise pas les nombres non finis

Question

<\/HEAD>Nous obtenons cette erreur d'une application UNIQUEMENT lorsqu'elle interroge un champ texte particulier et que la valeur contient la lettre "E".<\/P> Si nous interrogeons la valeur "75E003300011", nous obtenons l'erreur. Mais si nous interrogeons "750C17200011", l'application renvoie un enregistrement. Si nous interrogeons ces mêmes données dans ArcGIS desktop, nous n'obtenons aucune erreur.<\/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!