Links in Grid populated by data connector

Suite and Optimus Suite 5
#1

I am using the dhtmlxConnector to populate my grid, I’d like to link one of the columns and open a dhtmlxWindow with the database id column, which is not shown in the grid and two other fields that are visible in the grid. When i specifiy the column type as link nothing happens for one and how do I modify the link to put in the id of the row?

Here is a code sample.

var dhxGrid;
	
	parent.dhxLayout.cells("a").setWidth(200); 
	
	dhxGrid = parent.dhxLayout.cells("b").attachGrid();
	dhxGrid.setImagePath("/js/dhtmlxSuite2.6/dhtmlxGrid/codebase/imgs/");
	
	dhxGrid.setHeader("Username, Email Address, IP Address, Date, Active");
	dhxGrid.attachHeader("#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter")
	dhxGrid.setInitWidths("100,*")
	dhxGrid.setColTypes("ro,ro,ro,ro,link");
	
	dhxGrid.setColSorting("connector,connector,connector,connector,connector")
	dhxGrid.enableSmartRendering(true)
	dhxGrid.enableMultiselect(true)
	dhxGrid.init();
	dhxGrid.loadXML("connectors/userAdmin.php");
	var dp = new dataProcessor("connectors/userAdmin.php");
	dp.init(dhxGrid);
<?php require_once("../config.php"); $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass); mysql_select_db($mysql_db); require("../js/dhtmlxSuite2.6/dhtmlxConnector/codebase/grid_connector.php"); $grid = new GridConnector($res); $grid->enable_log("temp.log",true); $grid->dynamic_loading(100); $grid->render_table("tz_members","id","usr,email,regIP,dt,userActive"); ?>
#2

You can use “onRowSelect” event. docs.dhtmlx.com/doku.php?id=dhtm … nrowselect

#3

What I would like to do is to add a column to the grid with an edit icon image that has the database id of the record, is this possible to do using the dataprocessor?

#4

What I would like to do is to add a column to the grid with an edit icon image
You can use “img” excell type. Please check more information here docs.dhtmlx.com/doku.php?id=dhtm … xcells#img

To format data before it loaded to the grid you can use “beforeRender” event of dhtmlxConnector object.
docs.dhtmlx.com/doku.php?id=dhtm … re_loading
API of DataItem object which passed at “beforeRender” event handler listed here docs.dhtmlx.com/doku.php?id=dhtm … tem_object
docs.dhtmlx.com/doku.php?id=dhtm … m_specific

that has the database id of the record
If your row had id which is equal to database id of the record you can get it with “onRowSelect” event of dhtmlxGrid object