Can anyone help me with this. I am trying to make a tree control from JSON data, where the third column in the result set will be the value when a user clicks on the node.
SQL Select is
I need to end up with
SQL Select is
Code:
SELECT Company, Job, REF_NO from all_jobs
Code:
[COLOR=#0000FF][FONT=Courier New][[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] {[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] html: 'Balfour Beatty',[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] children: [[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] {[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] html: ' No 10, Downing Street',[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] [/FONT][/COLOR][COLOR=#0000FF][FONT=Courier New] value: 1023[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] },[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] {[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] html: ' Buckingham Palace',[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] value: 1205[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New][/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] }[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] ][/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] },[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] {[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] html: 'BAM', [/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New]children: [[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] {[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] html: ' 17, The Parade',[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] [/FONT][/COLOR][COLOR=#0000FF][FONT=Courier New] value: 987[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] }[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] ][/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New] }[/FONT][/COLOR] [COLOR=#0000FF][FONT=Courier New]][/FONT][/COLOR]