Re: DataObject, DataGrid and joins

Hi, Prue wrote: > Please help. I've tried all sorts of combinations and the results just get > weirder. > Firstly, if I create the DG with only one DO, it produces the correct > output. As soon as I attempt to join another table, the only things output > are the column headings. Please advise if I've used the wrong syntax to > call the fields > > Next, with "$dg->renderer->setFilename(datagrid.xls');" two Excel > spreadsheets are created. If I use > "$dg->renderer->setFilename(datagrid.xls',false);" as recommended in the > Changelog for 0.6.3 then no spreadsheets are created. Both behaviours are > repeatable. > > At one point, when using "$dg->renderer->setFilename(datagrid.xls');" two > DIFFERENT spreadsheets were created. One was as per the defined columns and > another with the same columns PLUS the name of one of the 'joined' tables > and an extra linked id field from the DO that called the join?????? This > also was repeatable until I rebooted the PC. > > Please advise how to fix. > The SDG version is 0.6.3 and my code is: Can you try this with the latest CVS ? You can check it out with : $ cvs -d:pserver:cvsread@cvs.php.net:/repository login (use "phpfi" as password) $ cvs -d:pserver:cvsread@cvs.php.net:/repository co pear/Structures_DataGrid -- og