500 JSON nepovoluje nekonečná čísla

Question

<\/HEAD>Tuto chybu dostáváme z aplikace POUZE když dotazujeme konkrétní textové pole a hodnota v něm obsahuje písmeno "E".<\/P> Pokud dotazujeme hodnotu "75E003300011", dostaneme chybu. Ale pokud dotazujeme "750C17200011", aplikace vrátí záznam. Pokud stejná data dotazujeme v ArcGIS desktop, žádnou chybu nedostaneme.<\/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!