500 JSON no permite números no finitos

Question

<\/HEAD>Recibimos este error de una aplicación SOLO cuando consulta un campo de texto en particular y el valor contiene la letra "E".<\/P> Si consultamos el valor "75E003300011" obtenemos el error. Pero si consultamos "750C17200011" la aplicación devuelve un registro. Si consultamos estos mismos datos en ArcGIS desktop, no obtenemos ningún error.<\/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!