Start Building Professional
Web Apps Today

v0.95 Connector upgrade, behaviour change

Hi,

I've just upgraded to v0.95, in order to handle complex sql within render_sql call.

However my grid is now refusing to display certain data, when it did so before the upgrade.

$gridConn->render_sql("Select institution,epsrc_ref,pi,start_date1,end_date1,scheme,ind_sector,value,title,url " . $FULLSQL , "id","institution,epsrc_ref,pi,start_date1,end_date1,scheme,ind_sector,value,title");

I've tracked this down to records that have a apostrophe within the data in "title" column. In these cases the data will not display.

Nothing else has changed within the application, apart from the upgrade.

Thanks
Jim.

Are you using co|coro columns or #connector_select_filter  in the grid ?
Data of the cells  is wrapped in CDATA sections , so content can't corrupt the output.

Please try to use the attached php files instead of the original one - they must resolve the problem is it was caused by select boxes in the grid.