|
Title: subgrid not showing data Post by: indyjoel on May 27, 2013, 03:32:47 AM hi
I have setup a grid that is showing the data ok. When I click on the plus to open the subgrid there is no data but the headings are shown. The query is returned ok and works ok in mysql. the json data is returned ok (below) but there is no data showing. Can anyone help please Query is SELECT l.`No`,l.`Category`, l.`lens` FROM `Lens` i INNER JOIN `lines` l ON i.`No` = l.`No` and i.`Category` = l.`Category` WHERE i.No = '1' and l.`Category` = 'st' [{"No":"1","Category":"st","lens":"stlens1"},{"No":"1","Category":"st","lens":"stlens2"}] |