Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by Dolzer on Feb 09, 2009 01:14
open dhtmlx forum
Error type: Configuration Description: Incorrect cell type: ed

HI, i have 3 problems.

The first one is that I can't run the page due to that Error "Error type: Configuration Description: Incorrect cell type: ed"
I have included all scripts which is included in your samples, too.

My second one is that, if i include the "dthmlxgrid_drag.js" script and add the line to activate drag & drop, both fields wouldn't be displayed. If i delete those lines, it will be displayed. How could that be?

The last one ist that the page doesn't work in IE. At Firefox it works but drag & drop.

That's my code & I hope, you are able to find a solution.

________________________________________________________________________________________________________

<html>
<head>
    <title>50,000 records in grid</title>

    <link rel="STYLESHEET" type="text/css" href="codebase/dhtmlxgrid.css">
    <script src="codebase/dhtmlxcommon.js"></script>
    <script src="codebase/dhtmlxgrid.js"></script>
    <script src="codebase/dhtmlxgridell.js"></script>
    <script src="codebase/excells/dhtmlxgrid_excell_link.js"></script>

    <script src="codebase/ext/dhtmlxgrid_srnd.js"></script>
    <script src="codebase/ext/dhtmlxgrid_drag.js"></script>


    
    <script language="JavaScript" type="text/JavaScript">
        function MM_findObj(n, d) {
            var p,i,x;
            if(!d) d=document;
            if((p=n.indexOf("?"))>0&&parent.frames.length) {
            d=parent.frames[n.substring(p+1)].document;
            n=n.substring(0,p);
        }
            if(!(x=d[n])&&d.all) x=d.all[n];
            for(i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
            for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
            if(!x && d.getElementById) x=d.getElementById(n);
            return x;
        }

        function MM_setTextOfTextfield(objName,x,newText) {
            var obj = MM_findObj(objName);
            if (obj) obj.value = newText;
            reloadGrid();
        }
    </script>
    
    <script>
    
    
        var mygrid;
        var mygrid2;
        var timeoutHnd;
        var flAuto = true;
        function doOnLoad(){
            mygrid = new dhtmlXGridObject('gridbox');
            mygrid.setImagePath("codebase/imgs/");

            mygrid.setHeader("UID,UNAME,NAME,EMAIL");
            mygrid.setInitWidths("50,150,150,150")
            mygrid.setColAlign("left,left,left,left")
            mygrid.setColTypes("ed,ed,ed,ed");    

         mygrid.setSkin("light");
        
         mygrid.enableDragAndDrop(true);
            mygrid.enableRowsHover(true,"grid_hover");
             mygrid.enableMultiline(false);
             mygrid.enableAlterCss("even","uneven");
             
             mygrid.setDropHandler(doOnRowDroppedGrid);



        
         mygrid.init();
         mygrid.enableSmartRendering(true);
        
        
        

            //available in Pro Edition only
            if (mygrid.setColspan) {
                 mygrid.attachEvent("onXLE",setCounter)
                
            }
            else{
                //code below written to support standard edtiton
//it written especially for current sample and may not work
                //in other cases, DON'T USE it if you have pro version
                
                mygrid.sortField_old=mygrid.sortField;
                mygrid.sortField=function(){
                    mygrid.setColSorting("str,str,str");
                    
    if (customColumnSort(arguments[0]))
                        mygrid.sortField_old.apply(this,arguments);
                }
                
                mygrid.sortRows=function(col,type,order){
                }
            }
            
         mygrid.loadXML("ajax_AdminTroubleTicketsNGAdminVerwaltung.php?un="+Date.parse(new Date()));

            showLoading()
            
        mygrid2 = new dhtmlXGridObject('gridbox2');
        mygrid2.selMultiRows = true;
        mygrid2.setImagePath("codebase/imgs/");
        var flds = "Alpha,Betta,Hallo,test";
        mygrid2.setHeader(flds);
        mygrid2.setInitWidths("100,150, 200, 200")
        mygrid2.setColAlign("right,left, left, left")
        mygrid2.setColTypes("ed,ed,ed,ed");
        mygrid2.setColSorting("int,str,str,str");
        mygrid2.setColumnColor("white,#d5f1ff,white,#d5f1ff");
        mygrid1.enableRowsHover(true,"grid_hover");
        mygrid1.enableMultiline(false);
        mygrid2.setMultiLine(false);
        //mygrid2.setDropHandler(doOnRowDroppedGrid1);
        //mygrid2.setOnRowDblClickedHandler(doOnRowDblClickedGrid1);

        //mygrid2.enableDragAndDrop(true);
    
        mygrid2.loadXML("ajax_AdminTroubleTicketsNGAdminVerwaltung.php?prod_mask="+prod_mask+"&box_mask="+box_mask+"&orderBy="+window.s_col+"&direction="+window.a_direction);
        mygrid2.init();
        }

        function setCounter(){
            var span = document.getElementById("recfound")
            span.style.color = "green";
            MyRows = mygrid.getRowsNum();
            if(MyRows > 0)
                span.innerHTML = MyRows;
            
            var span = document.getElementById("recausgab")
            span.style.color = "green";
            if(MyRows == 1)
                span.innerHTML = " User found";
            else
                span.innerHTML = " Users found";
        }
        function showLoading(){
            var span = document.getElementById("recausgab");
            span.style.color = "red";
            span.innerHTML = "";
            
            var span = document.getElementById("recfound")
            if(!!mygrid.setColspan){
                span.style.color = "red";
                span.innerHTML = "<b>Loading Users</b>";
                return;
            }

        }
        function doSearch(ev){
            if(!flAuto)
                return;
            var elem = ev.target||ev.srcElement;
            if(timeoutHnd)
                clearTimeout(timeoutHnd)
            timeoutHnd = setTimeout(reloadGrid,500)
        }
        function reloadGrid(){
            var box_mask = document.getElementById("search_box").value;
            var prod_mask = document.getElementById("search_prod").value;
            
            mygrid.clearAll();
            mygrid.loadXML("ajax_AdminTroubleTicketsNGAdminVerwaltung.php?prod_mask="+prod_mask+"&box_mask="+box_mask+"&orderBy="+window.s_col+"&direction="+window.a_direction);
            if (window.a_direction)
                mygrid.setSortImgState(true,window.s_col,window.a_direction);
            showLoading()
        }
        function enableAutosubmit(state){
            flAuto = state;
            document.getElementById("submitButton").disabled = state
        }
        function customColumnSort(ind){
            if (ind==1) {
                alert("Table can't be sorted by this column.");
                if (window.s_col)
                    mygrid.setSortImgState(true,window.s_col,window.a_direction);
                return false;
            }
            var a_state = mygrid.getSortingState();
            window.s_col=ind;
            window.a_direction = ((a_state[1] == "desc")?"asc":"des");
reloadGrid();
            return false;
        }

    </script>
</head>

<body onload="doOnLoad()">
<link rel='STYLESHEET' type='text/css' href='common/style.css'>

<table>
    <tr>
        <td>
            <div>
                Suche<br>
                    <input name="search_box" type="text" id="search_box" onkeydown="doSearch(arguments[0]||event)">
            </div>
        </td>
        <td>
            <div>
            <?php
                $DB = new MeineDBKlasse("", "testdolzer");
        
                $sql = "SELECT GruppenBez, Bez, ID FROM TTProdukt Order By GruppenBez asc, Bez asc";
                
                $row = $DB->SQL_SELECT_ARRAY($sql);
                $i = 1;
                $gesamtNum = count($row);
                
                echo "Produktauswahl<br>";
                echo "<select name=\"search_prod\" id=\"search_prod\" onchange=\"doSearch(arguments[0]||event)\" onkeyup=\"doSearch(arguments[0]||event)\">";
                echo "<option value=\"0\" SELECTED>* alle *</option>";
                while ($i < $gesamtNum) {
                    if($row[$i-1]['GruppenBez'] != $row[$i]['GruppenBez']) {
                        if($i > 1)
                            echo "</optgroup>";
                        $Gruppe = $row[$i]['GruppenBez'];
                        print("<optgroup label=");
                        print($row[$i]['GruppenBez']);
                        print(">");
                    }
                    print("<option value=\"");
                    print($row[$i]['ID']);
                    print("\">");
                    print($row[$i]['Bez']);
                    print("</option>");
                    $i++;
                }
            ?>
            </div>
        </td>    
    </tr>
</table>

<div id="gridbox" style="width:100%;height:300px;margin-top:20px;margin-bottom:10px;"></div>

<div><b><span id="recfound"></span><span id="recausgab"></span></b></div>

<table>
    <tr>
        <td>
            <p>test
        </td>
        <td>
            <div id="gridbox2" width="250px" height="250px" style="background-color:white;">jkhjkhjk kjhjkhkj</div>
        </td>
    </tr>
</table>

</body>
</html>
Answer posted on Feb 09, 2009 06:25

>>The first one is that I can't run the page due to that Error "Error type: Configuration Description: Incorrect cell type: ed" 
I have included all scripts which is included in your samples, too.
<script src="codebase/dhtmlxgridcell.js"></script>

>>My second one is that, if i include the "dthmlxgrid_drag.js" script and add the line to activate drag & drop, both fields wouldn't be displayed. If i delete those lines, it will be displayed. How could that be?

>>The last one ist that the page doesn't work in IE. At Firefox it works but drag & drop.

Please check if mygrid.loadXML("ajax_AdminTroubleTicketsNGAdminVerwaltung.php?un="+Date.parse(new Date())); returns correct xml.