Grid data from connector does not show up in IE 7/ 8

Suite and Optimus Suite 5
#1

I am having an issue where grid data is not showing up in IE 8, but does show up in Chrome. I have a layout that has two grids that are attached on the onclick event of a toolbar. This works fine in chrome, but does not work.

Here is my master.php page:

[code]

PhotographyBee Administrator 
<link rel="stylesheet" type="text/css" href="/js/dhtmlxSuite2.6/dhtmlxLayout/codebase/dhtmlxlayout.css">
<link rel="stylesheet" type="text/css" href="/js/dhtmlxSuite2.6/dhtmlxLayout/codebase/skins/dhtmlxlayout_dhx_skyblue.css">

<link rel="stylesheet" href="/js/dhtmlxSuite2.6/dhtmlxConnector/samples/common/dhtmlx.css" type="text/css" charset="utf-8">
<link rel="stylesheet" type="text/css" href="/js/dhtmlxSuite2.6/dhtmlxGrid/codebase/skins/dhtmlxgrid_dhx_skyblue.css">

<link rel="stylesheet" type="text/css" href="js/dhtmlxSuite2.6/dhtmlxGrid/codebase/dhtmlxgrid.css">
<link rel="stylesheet" type="text/css" href="js/dhtmlxSuite2.6/dhtmlxGrid/codebase/skins/dhtmlxgrid_dhx_skyblue.css">
<link rel="stylesheet" type="text/css" href="js/dhtmlxSuite2.6/dhtmlxToolbar/codebase/skins/dhtmlxtoolbar_dhx_skyblue.css">



<script src="js/dhtmlxSuite2.6/dhtmlxLayout/codebase/dhtmlxcommon.js"></script>
<script src="js/dhtmlxSuite2.6/dhtmlxLayout/codebase/dhtmlxlayout.js"></script>

<script src="js/dhtmlxSuite2.6/dhtmlxGrid/codebase/dhtmlxgrid.js"></script>
<script src="js/dhtmlxSuite2.6/dhtmlxGrid/codebase/dhtmlxgridcell.js"></script>


<script src="/js/dhtmlxSuite2.6/dhtmlxConnector/samples/common/dhtmlx.js" type="text/javascript" charset="utf-8"></script>
<script src="/js/dhtmlxSuite2.6/dhtmlxConnector/codebase/connector.js" type="text/javascript" charset="utf-8"></script>

<script src="js/dhtmlxSuite2.6/dhtmlxToolbar/codebase/dhtmlxtoolbar.js"></script>

<script src="js/dhtmlxSuite2.6/dhtmlxLayout/codebase/dhtmlxcontainer.js"></script>

<div id="parentId" style="width: 100%; height: 100%; aborder: #B5CDE4 1px solid;"></div>
 
<script type="text/javascript" language="javascript">
	var dhxLayout,
	dhxToolbar,
	dhxGrid;

	dhxLayout = new dhtmlXLayoutObject("parentId", "2U");
	
	dhxLayout.cells("a").setWidth(200); 					
	dhxToolbar = dhxLayout.attachToolbar();
	dhxToolbar.setIconsPath("/js/dhtmlxSuite2.6/dhtmlxToolbar/samples/common/imgs/");
	dhxToolbar.loadXML("/_xml/toolbar_buttons.xml?" + new Date().getTime());
	dhxToolbar.attachEvent("onClick", function(id){   
		if ( id == "useradmin") {
			dhxLayout.cells("b").detachObject();
			//dhxLayout.cells("b").view("userList").attachURL("../userList.php");
			dhxLayout.cells("b").attachURL("../userList.php");
			dhxLayout.cells("a").setText("User List");
			//dhxLayout.cells("b").hideHeader();
			//dhxLayout.cells("b").detachToolbar();
			
			
			  
			
			
		}
		else if (id == "clients")
		{	dhxLayout.cells("b").detachObject();
			//dhxLayout.cells("b").progressOn();
			//dhxLayout.cells("b").view("clientList").attachURL("../clientList.php");
			dhxLayout.cells("b").attachURL("../clientList.php");
			dhxLayout.cells("a").setText("Client List");
			dhxLayout.cells("b").hideHeader();
			
			
			

			
		}
	});

				
	
</script>
<?php echo $pagemaincontent; ?> [/code]

here is one of the pages that has the grid definition referenced int he onclick handler. (userList.php):

[code]<script language="javascript" type="text/javascript">
	//alert("here - user"); 
	var dhxGridUser;
	
	parent.dhxLayout.cells("a").setWidth(200); 
			
	dhxGridUser = parent.dhxLayout.cells("b").attachGrid();
	dhxGridUser.setImagePath("/js/dhtmlxSuite2.6/dhtmlxGrid/codebase/imgs/");
	
	dhxGridUser.setHeader("Username, Email Address, IP Address, Date, Active");
	dhxGridUser.attachHeader("#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter");
	dhxGridUser.setInitWidths("100,*");
	dhxGridUser.setColTypes("ro,ro,ro,ro,link");
	
	dhxGridUser.setColSorting("connector,connector,connector,connector,connector");
	dhxGridUser.enableSmartRendering(true);
	dhxGridUser.enableMultiselect(true);
	dhxGridUser.init();
	dhxGridUser.loadXML("connectors/userAdmin.php");
	var dp = new dataProcessor("connectors/userAdmin.php");
	dp.init(dhxGridUser);
 	

</script>[/code]
#2

Link to page: http://admin.photographybee.com

I modified one of the samples that comes with the connector to test and I get the same results, no data in IE.
http://admin.photographybee.com/js/dhtmlxSuite2.6/dhtmlxConnector/samples/grid/01_basic.html

#3

Ok, so I now know what the problem is. One of my fields has an @ symbol, the email address. If I take that field out the grid renders fine. I tried to set the encoding, but that does not work.

$grid->set_encoding(“iso-8859-1”);

Any thoughts?

#4

Try to enable server side logging and send us output of the log file

#5

how do i turn on this logging?

Thanks.

#6

$gridConn->enable_log(“path to log file”);

docs.dhtmlx.com/doku.php?id=dhtm … nd_logging

#7

The server log does not show anything when I hit the page from IE, when I hit it from chrome i see that the successful query is logged.

#8

Problem can be caused by caching - try to add some random element to the url

#9

Adding random data to the attachurl function did not help:
win.attachURL(url + “?etc=” + new Date().getTime());

#10

Has anyone encountered this before?

Thanks.

#11

I received this response from support via email which solved my issues:

There are at least one problem in your js code
You have the next:

    dhxGridUser.setHeader("Column A,B,C"); 
    dhxGridUser.setInitWidths("100,*");

While correct code must look as:

    dhxGridUser.setHeader("Column A,B,C"); 
    dhxGridUser.setInitWidths("100,*,*");

The number of size parameters must be equal to the number of columns. (IE can just break script execution if there is no valid size for the column)

Similar for the second grid.

As for data encoding, be sure to put set_encoding command before render_table, or it will not have effect.