Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by Ray on Oct 28, 2009 03:07
open dhtmlx forum
Strange error in IE 7 and IE 8

Hi,
i'm having a strange error in Internet Explorer and not in Mozilla about loading data in grid with connector:

In Mozilla the data are loaded correctly...but in IE a popup appear with entire content of xml generated by connector?

Why?

Thank u
Answer posted by Support on Oct 28, 2009 03:31
Pop up with entire content of xml can appear if dhtmlxcommon_debug.js file is attached. 
Answer posted by Ray on Oct 28, 2009 04:56
This is not my case.....i don't have dhtmlxcommon_debug.js attached....and why in internet explorer no data are displayed but only popup
and in mozilla all works correctly?

Answer posted by Support on Oct 28, 2009 09:20
Can you provide example or link where we can reproduce this issue?
Answer posted by Ray on Oct 28, 2009 09:48
this is container:

<div id="employee" style="width:780px; height:250px;"></div>
       
        <script>
        var employee_grid;
        employee_grid = new dhtmlXGridObject('employee');
        employee_grid.setImagePath('../../../includes/dhtmlxSuite/dhtmlxGrid/codebase/imgs/');
        employee_grid.setHeader("Matricola,Cognome,Nome,Filiale");
        employee_grid.setInitWidths("190,190,190,190");
        employee_grid.setColTypes("ro,ro,ro,ro");
        employee_grid.setSkin("light");
        employee_grid.attachHeader("#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_select_filter");
        employee_grid.setColSorting("connector,connector,connector,connector");
        employee_grid.init();
        employee_grid.attachEvent("onRowSelect",viewtimesheet);
        employee_grid.enableSmartRendering(true);
        employee_grid.load("../../../includes/DataProcessor/employee_grid_connector.php");
   
        var emp_dataprocessor = new dataProcessor("../../../includes/DataProcessor/employee_grid_connector.php");
        emp_dataprocessor.init(employee_grid);
        </script>

        <h4>Timbrature: (Doppio click sulla riga per modificarne i valori)</h4>

        <div id="timesheet" style="width:780px;height:250px;"></div>
       
        <br />
        <input type="button" name="delete_record" value="Elimina Record Selezionato" onclick="employee_timesheet.deleteSelectedItem()">
       
        <script>
        var employee_timesheet;
        employee_timesheet = new dhtmlXGridObject('timesheet');
        employee_timesheet.setImagePath('../../../includes/dhtmlxSuite/dhtmlxGrid/codebase/imgs/');
        employee_timesheet.setHeader("Orario In,Nota In,Orario Out,Nota Out,Stato");
        employee_timesheet.setInitWidths("*,*,*,*,*");
        employee_timesheet.setColTypes("ed,ed,ed,ed,ch");
        employee_timesheet.setSkin("modern");
        employee_timesheet.attachHeader("#connector_text_filter,#connector_select_filter,#connector_text_filter,#connector_select_filter,#connector_select_filter");
        employee_timesheet.setColSorting("connector,connector,connector,connector,connector");
        employee_timesheet.init();
        employee_timesheet.enableSmartRendering(true);
        </script>   

and this is the connector:

<?php

    require_once("../dhtmlxSuite/dhtmlxConnector/php/codebase/grid_connector.php");

    $res=mysql_connect("localhost","root","sandbgroup");
    mysql_select_db("hr_mysql");

    function bold_matricola($row)
    {
        $row->set_cell_style("employee_id","font-weight:bold;");
    }
   

    $employee_grid = new GridConnector($res);
    $employee_grid->set_encoding("ISO-8859-1");
    $employee_grid->enable_log("Log/employee_grid_connector.log",true);
    $employee_grid->dynamic_loading(100);
   
    $employee_grid->event->attach("beforeRender",bold_matricola);
       
    $employee_grid->render_sql ("SELECT  hs.loc_code, hs.loc_city, b.employee_id, b.emp_lastname, b.emp_firstname, a.emp_number " .
        "FROM hs_hr_location hs " .
        "JOIN (hs_hr_emp_locations a " .
        "JOIN hs_hr_employee  b " .
        "ON (a.emp_number=b.emp_number)) " .
        "ON (a.loc_code=hs.loc_code) " .
        "WHERE b.emp_status<>'EST009' AND b.emp_status<>'EST011'" .
        "AND (b.terminated_date LIKE" . "'" . date("Y-m") . "%" . "'"  .
        "OR b.terminated_date IS NULL)",
        "emp_number","employee_id,emp_lastname,emp_firstname,loc_city");
   
   
?>

as u can see part of code...( employee_grid.attachEvent("onRowSelect",viewtimesheet); ) is missing because the function is declared on another page....
forget it...
Answer posted by Support on Oct 28, 2009 10:32
What version of dhtmlxConnectors do you use? Please try to update it to the latest version. http://dhtmlx.com/docs/download/dhtmlxConnector_php.zip
Answer posted by Ray on Oct 28, 2009 12:41
my version is 2.5 with 0.95 connector...

the connector has been  modified by support ...u can see how in this link:

http://dhtmlx.com/docs/products/kb/index.php?s=normal&q=11843&a=19835