json parsing error

esmondb · 2012-03-10 09:56:08

My browser if giving an 'invalid number' parsing error. It's being caused by a rawUTF8 field containing a single minus sign. I guess this is being treated as an integer so the quotes are missing. Can this be changed?

ab · 2012-03-10 21:21:00

It is not easy to understand what is wrong here.

Could you post some code here in order to reproduce the problem?

RawUTF8 fields are always transmitted as JSON strings (with quotes).

So you are perhaps mixing types, in an unexpected way.

esmondb · 2012-03-12 08:11:15

I might have got my code in a tangle.

As soon as I've time I'll put together an example.

Thanks

esmondb · 2012-03-13 12:18:49

Looking at it again the function

function IsJSONString(P: PUTF8Char): boolean;

in SynCommons.pas is returning false if '-' or '+' is passed.
can plus or minus on it's own be regarded as a string?

esmondb · 2012-03-13 12:24:15

BTW my code which caused the problem was:

Table := TSQLTableDB.Create(db,RecordClassesToClasses([TSQLRec, TSQLFTSRec]),SQLQuery,true);
aParams.Resp := Table.GetJSONValues(true);

ab · 2012-03-13 13:47:33

You were perfectly right.

There was several issues in the string recognition pattern.
The IsJSONString() implementation and use was incorrect in some cases.

It should be fixed by now (and corresponding regression tests have been added).
See http://synopse.info/fossil/info/7444f84ec1

Thanks for the feedback.

mORMot Open Source

#1 2012-03-10 09:56:08

json parsing error

#2 2012-03-10 21:21:00

Re: json parsing error

#3 2012-03-12 08:11:15

Re: json parsing error

#4 2012-03-13 12:18:49

Re: json parsing error

#5 2012-03-13 12:24:15

Re: json parsing error

#6 2012-03-13 13:47:33

Re: json parsing error

Board footer