Grid not updating

Suite and Optimus Suite 5
#1

New to this so thanks for the support

I have 2 grids on a page working with dynamic connectors with php. Im in an IIS 7 with MSSql database.
My Grids updated row goes bold

The dataprocessor debug shows
row 1002 marked [updated,valid]
Initiating data sending for 1002
Initiating data sending for all rows

Never gets past initiating

My grids are set up like this

mygrid = new dhtmlXGridObject(‘mygrid_container’);
mygrid.setImagePath(“dhtmlxGrid/imgs/”);
mygrid.setHeader(“ID,Name,Street,City,State,Zip,Contact,Account,Phone,Fax,Cell,Email”);
mygrid.setInitWidths(“,,,,,,,,,,,”);
mygrid.setColAlign(“left,left,left,left,left,left,left,left,left,left,left,left”);
mygrid.setColTypes(“ed,ed,ed,ed,ed,ed,ed,ed,ed”);
mygrid.setSkin(“dhx_skyblue”);
mygrid.setAwaitedRowHeight(25);
//mygrid.parse(“php/project_data.php”,“json”);

mygrid.init();
mygrid.clearAll();	
mygrid.load("php/connector_Vendor.php");
mygrid.setColSorting("connector,connector,connector,connector,connector,connector,connector,connector");
    mygriddp = new dataProcessor("php/connector_Vendor.php");
mygriddp.init(mygrid);
mygriddp.setUpdateMode("cell",true)	
mygriddp.setDataColumns("true,true,true,true,true,true,true,true,true,true,true");


//mygrid.init();	

Custgrid = new dhtmlXGridObject('Customergrid_container');
    Custgrid.setImagePath("dhtmlxgrid/codebase/imgs/");
     Custgrid.setHeader("Name,Street,City,State,Zip,Phone,Fax,Cell,Email");
     Custgrid.setInitWidths("*,*,*,*,*,*,*,*,*,*,*");
     Custgrid.setColAlign("left,left,left,left,left,left,left,left,left,left,left");
     Custgrid.setSkin("sbdark");
//mygrid.parse("php/project_data.php","json");          
Custgrid.load("php/connector_Customer.php");
    Custgrid.init();	
    var Custdp = new dataProcessor("php/connector_Customer.php");
Custdp.init(Custgrid);
Custdp.init(mygrid);
Custdp.setUpdateMode("cell",true)	
Custdp.setDataColumns("true,true,true,true,true,true,true,true,true,true,true");

My connector for the first grid is

<?php include("global_vars.php"); ?> <?php require_once("../dhtmlx/dhtmlxConnector_php/codebase/grid_connector.php"); require_once("../dhtmlx/dhtmlxConnector_php/codebase/db_mssql.php"); $res = mssql_connect($myServer, $myUser, $myPass); mssql_select_db($myDBName, $res); $grid = new GridConnector($res,"MsSQL"); $grid->enable_log("c:/temp/temp.log",true); //$grid->render_table("Employees", "ID", "FirstName,LastName,EmailAddress,PhoneNumber,CellNumber,Address,City,ZipCode,State,BirthDate"); $grid->render_table("Vendors", "VendID", "VendID,Name,Street,City,State,ZipCode,Contact,AccountNumber,Phone,FaxNumber,CellNumber,Email"); ?>

I’m sure I’m missing a step here can you help…

Thanks in advance
Dave

#2

a) You are calling init two times for dataprocessor - but it must be called only once
b) Be sure that connector.js is included on the page ( after dataprocessor.js )

Also there must be some error in server side code
Try to load the php/connector_Customer.php directly in browser - do it shows some error?
What is the content of c:/temp/temp.log?

#3

Thanks for the quick response.

I am calling the dataprocessor twice but it is to different instances Custdp And Venddp
This is my includes

This is my log contents

====================================
Log started, 22/08/2012 05:08:12

SELECT VendID,VendID,Name,Street,City,State,ZipCode,Contact,AccountNumber,Phone,FaxNumber,CellNumber,Email FROM Vendors

Done in 0.0019948482513428s

====================================
Log started, 22/08/2012 05:08:39

SELECT VendID,VendID,Name,Street,City,State,ZipCode,Contact,AccountNumber,Phone,FaxNumber,CellNumber,Email FROM Vendors

Done in 0.0019021034240723s

====================================
Log started, 22/08/2012 07:08:05

SELECT VendID,VendID,Name,Street,City,State,ZipCode,Contact,AccountNumber,Phone,FaxNumber,CellNumber,Email FROM Vendors

Done in 0.002065896987915s

====================================
Log started, 23/08/2012 08:08:00

SELECT VendID,VendID,Name,Street,City,State,ZipCode,Contact,AccountNumber,Phone,FaxNumber,CellNumber,Email FROM Vendors

Done in 0.0022139549255371s

====================================
Log started, 23/08/2012 09:08:48

SELECT VendID,VendID,Name,Street,City,State,ZipCode,Contact,AccountNumber,Phone,FaxNumber,CellNumber,Email FROM Vendors

Done in 0.0019791126251221s

Thanks
Dave

#4

Sorry i see the double call I have eliminated the entire second grid

Didn’t help

In calling the connector I get a good XML output.

row 1002 marked [updated,valid]
Initiating data sending for 1002
Initiating data sending for all rows
Initiating data sending for all rows

Thanks
Dave

#5

Thank you for your help Appears I have an issue with just the vendor table.

Ill be back with you if i need more help (which Im sure i will)

Thanks
Dave