Hi George,
Thanks for the input.
Well, the data is converted to json by php from a nested array after
extracting the data from a database thus the reason why there's flowerset
and flowers.
Im finally through with it, it looks kinda complicated in the nesting
element but it somehow while retreiving the data it was easy remebering the
various "layers".
On the same breath will be looking into streamlining it and making it thin
as you have outlined.
Thanks
Regards
Jason
On Thu, Dec 18, 2008 at 4:42 PM, George <george.bea...@googlemail.com>wrote:
>
> Hi Jason,
>
> Forgive me if I've misunderstood the question, but hopefully this
> might help.
>
> As far as I know, you can infinitely nest your JSON data if that's
> what you want to do. I've noticed some fundamental problems with your
> JSON you pasted in your post which may just be typos, but need to be
> cleared up before your code will work. Firstly the items in your
> 'flowerset' are not enclosed in square brackets. Secondly your names
> (eg groupCode) do not need to be enclosed in quotations although this
> won't break things. Thirdly, in my opinion, you could break this down
> and request a much smaller and less complex dataset from the server
> (maybe just the group names first, then depending on what the user
> clicked on get the flower names and so on) Thus putting less load on
> the server and reducing bandwidth. Also, I'd say to have everything
> nested under the name rsJson just adds another unnecessary dimension
> of complication.
>
> Think of JSON as just a long bunch of name value pairs [{name:value}]
> separated by commas where a value can be a number, string or another
> array. If your value is another array, then it must be enclosed in
> square brackets. As such, there should never be a curly bracket
> immediately after a colon ( [{name:{name:value, name:value},
> name:value}] ) is wrong. [{name:[{name:value, name:value}],
> name:value}] is correct.
>
> I've cleaned up a little bit of your data just to demonstrate the
> correct syntax:
>
> {rsJson:
> [
> {groupCode:"1",groupName:"Roses",flowerSet:[
> {flowers: [
> {flowerCode:"15",flowerName:"Roses"}
> ]}
> ]},
> {groupCode:"2",groupName:"Carnations",flowerSet:[
> {flowers:[
> {flowerCode:"16",flowerName:"Spray Carnations"},
> {flowerCode:"17",flowerName:"Standard Carnations"}
> ]}
> ]}
> ]}
>
> To get to your data do something like this:
>
> myDataSetVar[0].rsJson[0].groupCode (would give you "1")
> myDataSetVar[0].rsJson[1].flowerSet[0].flowers[1].flowerName (would
> give you "Standard Carnations")
>
>
> Really hope that helps and I haven't confused things further.
>
> All the best
>
> George
>
>
> On Dec 18, 9:04 am, "jason maina" <jason.ma...@gmail.com> wrote:
> > Thanks Ryan guess was kind of tired had failed looking at some of the
> points
> > rather was not getting the point. Finally I'm through this is the final
> > product:
> >
> >
> {"rsJson":[{"groupCode":"1","groupName":"Roses","flowerSet":{"flowers":[{"flowerCode":"15","flowerName":"Roses"}]}},{"groupCode":"2","groupName":"Carnations","flowerSet":{"flowers":[{"flowerCode":"16","flowerName":"Spray
> > Carnations"},{"flowerCode":"17","flowerName":"Standard
> >
> Carnations"}]}},{"groupCode":"3","groupName":"Perennials","flowerSet":{"flowers":[{"flowerCode":"2","flowerName":"Aster"},{"flowerCode":"3","flowerName":"Alstromeria"},{"flowerCode":"10","flowerName":"Gysophila"},{"flowerCode":"12","flowerName":"Limonium
> >
> Perezzi"}]}},{"groupCode":"4","groupName":"Annuals","flowerSet":{"flowers":[{"flowerCode":"1","flowerName":"Ammi
> >
> Majus"},{"flowerCode":"4","flowerName":"Bupleurum"},{"flowerCode":"5","flowerName":"Carthamus"},{"flowerCode":"6","flowerName":"Chinese
> >
> Aster"},{"flowerCode":"7","flowerName":"Chrysantemum"},{"flowerCode":"8","flowerName":"Delphinium"},{"flowerCode":"13","flowerName":"Lisianthus"},{"flowerCode":"14","flowerName":"Molucella"},{"flowerCode":"18","flowerName":"Statice"},{"flowerCode":"19","flowerName":"Stocks"}]}},{"groupCode":"5","groupName":"Bulbs","flowerSet":{"flowers":[{"flowerCode":"9","flowerName":"Freesia"},{"flowerCode":"11","flowerName":"Lilies"}]}}]}
> >
> > kind regards
> > Jason
> >
> > On Wed, Dec 17, 2008 at 8:04 PM, jason maina <jason.ma...@gmail.com>
> wrote:
> > > What im wondering out of the reply is I cant have a nested JSON object
> with
> > > the following layout?
> >
> > > groupID, groupName, groupItems(array of items)
> >
> > > similar example:
> >
> > >http://labs.adobe.com/technologies/spry/samples/data_region/JSONDataS.
> ..
> >
> > > Regards,
> > > Jason
> >
> > > On Wed, Dec 17, 2008 at 7:02 PM, Ryan Gahl <ryan.g...@gmail.com>
> wrote:
> >
> > >> typo... "...with NO properties"
> >
> > >> On Wed, Dec 17, 2008 at 10:02 AM, Ryan Gahl <ryan.g...@gmail.com>
> wrote:
> >
> > >>> Here are your problems... I'll remove the bulk of the data to make it
> > >>> more clear:
> >
> > >>> rsJson: {[{...}]}
> >
> > >>> what you have is illegal. You're essentially saying you have an
> anonymous
> > >>> object with not properties and filling it with an array (that's
> probably not
> > >>> even totally accurate)... the bottom line is, you can't have a curly
> brace
> > >>> immediately followed by a square brace. And going further you have it
> all
> > >>> just sitting in a property floating in space. The first thing you
> need to do
> > >>> is wrap the property in curlies so you're actually returning an
> object...
> >
> > >>> {rsJson: ...}
> >
> > >>> Now, this other issue of putting a square bracket right inside a
> curly...
> > >>> You can either a) remove the outer curlies and just make rsJson be an
> array,
> > >>> or b) add a property name which then becomes the array.
> >
> > >>> a)
> > >>> {rsJson: [{}, {}, ...]}
> >
> > >>> b)
> > >>> {rsJson: {myArray: [...]}}
> >
> > >>> On Wed, Dec 17, 2008 at 9:53 AM, jason maina <jason.ma...@gmail.com
> >wrote:
> >
> > >>>> Hi all,
> > >>>> Below is JSON encoded(php) data. After evaluating and sanitizing it
> im
> > >>>> not capable of extracting its contents im just not sure what im
> doing wrong:
> >
> > >>>> [php output]
> >
> > >>>>
> rsJson:{[{"groupCode":"1","groupName":"Roses","flowers":[{"flowerCode":"15","flowerName":"Roses"}]},
> > >>>>
> {"groupCode":"2","groupName":"Carnations","flowers":[{"flowerCode":"16","flowerName":"Spray
> > >>>> Carnations"
> > >>>> },{"flowerCode":"17","flowerName":"Standard
> > >>>> Carnations"}]},{"groupCode":"3","groupName":"Perennials"
> >
> > >>>>
> ,"flowers":[{"flowerCode":"2","flowerName":"Aster"},{"flowerCode":"3","flowerName":"Alstromeria"},{"flowerCode"
> > >>>>
> :"10","flowerName":"Gysophila"},{"flowerCode":"12","flowerName":"Limonium
> > >>>> Perezzi"}]},{"groupCode":"4"
> > >>>>
> ,"groupName":"Annuals","flowers":[{"flowerCode":"1","flowerName":"Ammi
> > >>>> Majus"},{"flowerCode":"4","flowerName"
> > >>>>
> :"Bupleurum"},{"flowerCode":"5","flowerName":"Carthamus"},{"flowerCode":"6","flowerName":"Chinese
> > >>>> Aster"
> >
> > >>>>
> },{"flowerCode":"7","flowerName":"Chrysantemum"},{"flowerCode":"8","flowerName":"Delphinium"},{"flowerCode"
> >
> > >>>>
> :"13","flowerName":"Lisianthus"},{"flowerCode":"14","flowerName":"Molucella"},{"flowerCode":"18","flowerName"
> >
> > >>>>
> :"Statice"},{"flowerCode":"19","flowerName":"Stocks"}]},{"groupCode":"5","groupName":"Bulbs","flowers"
> >
> > >>>>
> :[{"flowerCode":"9","flowerName":"Freesia"},{"flowerCode":"11","flowerName":"Lilies"}]}]}
> >
> > >>>> [php output]
> >
> > >>>> var jsonObj = res.responseText.evalJSON(true);
> > >>>> alert(jsonObj);
> >
> > >>>> will not even popup, on firebug no errors showing up.
> >
> > >>>> Kind regards
> > >>>> Jason
> >
> > >>> --
> > >>> Ryan Gahl
> > >>> CEO
> > >>> Nth Penguin, LLC
> > >>>http://www.nthpenguin.com
> > >>> --
> > >>> WebWidgetry.com / MashupStudio.com
> > >>> Future Home of the World's First Complete Web Platform
> > >>> --
> > >>> Inquire: 1-920-574-2218
> > >>> Blog:http://www.someElement.com
> > >>> LinkedIn Profile:http://www.linkedin.com/in/ryangahl
> >
> > >> --
> > >> Ryan Gahl
> > >> CEO
> > >> Nth Penguin, LLC
> > >>http://www.nthpenguin.com
> > >> --
> > >> WebWidgetry.com / MashupStudio.com
> > >> Future Home of the World's First Complete Web Platform
> > >> --
> > >> Inquire: 1-920-574-2218
> > >> Blog:http://www.someElement.com
> > >> LinkedIn Profile:http://www.linkedin.com/in/ryangahl
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Prototype & script.aculo.us" group.
To post to this group, send email to prototype-scriptaculous@googlegroups.com
To unsubscribe from this group, send email to
prototype-scriptaculous+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/prototype-scriptaculous?hl=en
-~----------~----~----~----~------~----~------~--~---
