Re: [WebDNA] JSONStore Levels
This WebDNA talk-list message is from 2020
It keeps the original formatting.
numero = 115104
interpreted = N
texte = 2733To answer the questions: =E2=80=A2 Will the code work for nested arrays? Yes, it will flatten the array and save it in the database with =the full path name for each node. =E2=80=A2 Will it allow for JSON that has colons - or any character =- in the node names? Everything should be fine except tabs/linefeeds/etc.Using that example (adding double quotes around duration to make the =JSON valid), it would be saved in the database with the following column =names=3Dvalueslist:0:points.bean.pointsBase:0:time=3D2000list:0:points.bean.pointsBase:0:caption=3Dcaption textlist:0:points.bean.pointsBase:0:duration=3D5000list:0:points.bean.pointsBase:1:time=3D6000list:0:points.bean.pointsBase:1:caption=3Dcaption textlist:0:points.bean.pointsBase:1:duration=3D3000The improved JSON parsing would take care of the bugs on the test suite =page. The unwanted whitespace would be fixed, and I believe the escaped =quotes would be handled correctly too.What would we call this? The behavior will be quite different than the =original [JSONSTORE] : should we name it something else like =[JSONSTOREPLUS], or replace the original?- chris=---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us.
Associated Messages, from the most recent to the oldest:
2733To answer the questions: =E2=80=A2 Will the code work for nested arrays? Yes, it will flatten the array and save it in the database with =the full path name for each node. =E2=80=A2 Will it allow for JSON that has colons - or any character =- in the node names? Everything should be fine except tabs/linefeeds/etc.Using that example (adding double quotes around duration to make the =JSON valid), it would be saved in the database with the following column =names=3Dvalueslist:0:points.bean.pointsBase:0:time=3D2000list:0:points.bean.pointsBase:0:caption=3Dcaption textlist:0:points.bean.pointsBase:0:duration=3D5000list:0:points.bean.pointsBase:1:time=3D6000list:0:points.bean.pointsBase:1:caption=3Dcaption textlist:0:points.bean.pointsBase:1:duration=3D3000The improved JSON parsing would take care of the bugs on the test suite =page. The unwanted whitespace would be fixed, and I believe the escaped =quotes would be handled correctly too.What would we call this? The behavior will be quite different than the =original
[JSONstore] : should we name it something else like =[JSONSTOREPLUS], or replace the original?- chris=---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us.
christophe.billiottet@webdna.us
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Help ..... with better explanation (2001)
Menu Syntax on Edit/Add templates (1998)
quotes and truncating? (1997)
[WebDNA] two ideas for running a cluster of WebDNA servers (2019)
carriage returns in data (1997)
Creating folders and deleting files (1997)
RE: WebCat cannot handle compatible search parameters? (1997)
Cart Numbers (1997)
browser info.txt and SSL (1997)
Making webcam movies (2003)
creator code (1997)
[WebDNA] [OT] iTools FTP question (2010)
Extended [ConvertChars] (1997)
Fwd: Problems with Webcatalog Plug-in (1997)
creator code (1997)
[ShowIf] and empty fields (1997)
[Webcat 2]Next (1997)
new WebDNA 5 command reference (2003)
RE: Checkboxes to add to cart... (1998)
& not allowed in db by definition? (1999)