Dhtmlxconnector field not connected to database column?

I am currently loading grid using XML generated on server side.

[code]header(“Content-type: text/xml”);
echo(‘<?xml version="1.0" encoding="ISO-8859-1"?>’);
echo ‘’;
$sql = “SELECT * from $tblname”;
$res = mysql_query ($sql);

		echo ("<row id='".$row['id']."'>");
	echo '</rows>';

However, i would really like to use dhtmlxconnector for Grid for configuring the Grid as well as for loading and saving data. I am able to send “id” and “name” columns, but NOT the images.


How i can add columns which are NOT linked to the database table and send the images or text to the client-side.


Can be done through beforeRender handler

function format_data($action){ $action->set_value("image", "imgs/some.gif") }; $gridconn->event->attach("beforeRender", "format_data"); $gridconn->render_table("dbasetable","id","id,name,0(image)");

Sorry … but this did not work for me. Got an Error that column 0 could not be found.
Tried different combinations xxx(image), (image), 0(blah) ect … but everytime it complains the column cannot be found. I also update to the new connector codebase you gave out today … but still same error. Any hints?

[Thu Apr 11 10:53:32.130146 2013] [:error] [pid 824:tid 980] [client] PHP Fatal error: Uncaught exception ‘Exception’ with message ‘MySQL operation failed\nUnknown column ‘0’ in ‘field list’’ in C:\Program Files\EasyPHP-12.1\www\base\connector\db_common.php:991\nStack trace:\n#0 C:\Program Files\EasyPHP-12.1\www\dbase\connector\db_common.php(668): MySQLDBDataWrapper->query(‘SELECT `dbasetable_…’)\n#1 C:\Program Files\EasyPHP-12.1\www\base\connector\base_connector.php(531): DBDataWrapper->select(Object(DataRequestConfig))\n#2 C:\Program Files\EasyPHP-12.1\www\base\connector\base_connector.php(512): Connector->get_resource()\n#3 C:\Program Files\EasyPHP-12.1\www\base\connector\base_connector.php(409): Connector->render()\n#4 C:\Program Files\EasyPHP-12.1\www\base\php\app_grid_conn.php(29): Connector->render_table(‘dbasetable’, ‘id’, ‘id,name…’)\n#5 {main}\n thrown in C:\Program Files (x86)\EasyPHP-12.1\www\base\connector\db_common.php on line 991, referer:

Please try to change the above code as


Double-checked it locally - works as expected.