On 20.12.19 04:45, No.1 Perfect wrote:
I've read the full page instructions of JSON1, But I don't know how to use
JSON1 to query multiple layers JSON data.
The Data as follows :
{
id: 1,
data: {
customer: 1,
goods: [
{ id: 1, name: "apple", price: 12, num: 10,
amount: 120 },
{ id: 2, name: "perl", price: 10, num: 5,
amount: 50 }
]
}
}
(snipped...)
Two suggestions come to mind:
1. Normally, JSON data is not displayed directly in a web page, so all
the (entity references for non-breaking space) shouldn't be in
there (and probably is not valid JSON, anyway).
2. If you do need to display the JSON code for some reason, use regular
spaces and line feeds and wrap it in HTML <pre></pre> tags.
Unfortunately, I never used JSON queries with SQLite, so others will
have to help after this point.
HTH,
Bob Hairgrove
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
