[Proto-Scripty] Re: Nested JSON problem
No it just means that you can only nest your data to a depth of 512 on
the php server side. Imagine navigating that!
On Dec 18, 7:26 pm, jason maina jason.ma...@gmail.com wrote:
Is it to mean that it cant support a large 'recordset' ?
On 12/18/08, Richard Quadling rquadl...@googlemail.com wrote:
2008/12/18 jason maina jason.ma...@gmail.com:
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
[Proto-Scripty] Re: Nested JSON problem
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.comwrote:
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]
[Proto-Scripty] Re: Nested JSON problem
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.comwrote:
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
[Proto-Scripty] Re: Nested JSON problem
2008/12/18 jason maina jason.ma...@gmail.com:
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
[Proto-Scripty] Re: Nested JSON problem
You learn something every day! Many thanks for that Richard.
On Dec 18, 4:16 pm, Richard Quadling rquadl...@googlemail.com
wrote:
2008/12/18 jason maina jason.ma...@gmail.com:
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
[Proto-Scripty] Re: Nested JSON problem
Is it to mean that it cant support a large 'recordset' ?
On 12/18/08, Richard Quadling rquadl...@googlemail.com wrote:
2008/12/18 jason maina jason.ma...@gmail.com:
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,
[Proto-Scripty] Re: Nested JSON problem
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/JSONDataSetSample.html#Example5
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.comwrote:
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
-~--~~~~--~~--~--~---
