It seems you use the commertial PHP jqGrid.

Please post your problem here:

http://www.trirand.net/forum/

Regards

Also my table has two primary keys how would that work?

What am I doing wrong here?

here is my code.

//require_once 'jq-config.php';
// include the jqGrid Class

require_once "php/jqGrid.php";
require_once "php/jqGridSqlsrv.php";

// include the PDO driver class

$connectionInfo = array("Database"=>"CDO_master_res","CharacterSet" => "utf-8","ReturnDatesAsStrings" => true);
$serverName = "NYSQL1";
$conn = sqlsrv_connect( $serverName, $connectionInfo);
// Create the jqGrid instance
$grid = new jqGridRender($conn);

$grid->debug = true;
// Write the SQL Query castselect cast(checkid as varchar(5))+'_'+cast(updateid as varchar(6))as pkid,
$grid->SelectCommand = "select checkid , updateid , pass , threshold , detail , CONVERT(nvarchar(20), update_date, 101) as update_date , duration, notes from qa_checks_results_pre";
// set the ouput format to json
$grid->dataType = 'json';
$grid->table = 'dbo.qa_checks_results_pre';
$grid->setPrimaryKeyId('checkid');
$grid->serialKey = false;

// Let the grid create the model

$Model = array(
            array("name"=>"checkid", "label"=>"checkid", "width"=>20, "align"=>"right","editable"=>false),//, "editable"=>false
            array("name"=>"updateid",  "label"=>"updateid", "width"=>100,"editable"=>false),
            array("name"=>"pass", "label"=>"pass", "width"=>100),
            array("name"=>"threshold", "label"=>"threshold", "width"=>150,"editable"=>false),
            array("name"=>"detail", "detail"=>"tested", "width"=>250,"editable"=>false),
            array("name"=>"update_date", "label"=>"update_date", "width"=>150,"editable"=>false),
            array("name"=>"duration", "label"=>"duration", "width"=>150,"editable"=>false),
            array("name"=>"notes", "label"=>"notes", "width"=>300)
);

$grid->setColModel($Model );
// Set the url from where we obtain the data
$grid->addCol(array(
    "name"=>"actions",
    "formatter"=>"actions",
    "editable"=>false,
    "sortable"=>false,
    "resizable"=>false,
    "fixed"=>true,
   "width"=>60,
   "formatoptions"=>array("keys"=>true)
    ), "first");
$grid->setUrl('myfirstgrid.php');
// Set grid caption using the option caption
// Enable navigator
$grid->setColProperty('checkid', array("editrules"=>array("required"=>true)));
$grid->setColProperty('updateid', array("editrules"=>array("required"=>true)));

$grid->navigator = true;
$grid->setNavOptions('navigator', array("excel"=>true,"add"=>true,"edit"=>true,"del"=>true,"view"=>true));
$grid->setNavOptions('edit',array("closeAfterEdit"=>true,"editCaption"=>"Edit QA Results","bSubmit"=>"Submit"));
$grid->setGridOptions(array(
    "caption"=>"QA MACRO",
    "rowNum"=>20,
    "sortname"=>"updateid",
    "hoverrows"=>true,
    "height"=>"auto",
    "width"=>900,
    "rowList"=>array(20,40,60)
    ));
// Change some property of the field(s)
//$pkid = jqGridUtils::GetParam('pkid');
//$checkid = jqGridUtils::GetParam('checkid');
//$updateid= jqGridUtils::GetParam('updateid');
//$notes = jqGridUtils::GetParam('notes');
//$pass= jqGridUtils::GetParam('pass');

//if ($_SESSION['updateid']){
//$sql = "UPDATE qa_checks_results_pre SET pass ='". $pass ."',notes = '".$notes."' where cast(checkid as varchar(5))+'_'+cast(updateid as varchar(6))".$pkid.";" ;
//$_SESSION['sql'] = $sql ;
//$grid->setAfterCrudAction('edit',"UPDATE qa_checks_results_pre SET pass ='". $pass ."',notes = '".$notes."' where cast(checkid as varchar(5))+'_'+cast(updateid as varchar(6))=".$pkid.";" );
//}
////"UPDATE qa_checks_results_pre SET pass =?, notes = ? where updateid=? and checkid =?;",array($pass, $notes, $updateid, $checkid  )

$grid->toolbarfilter = true;
$grid->setFilterOptions(array("stringResult"=>true));
// Enjoy
$grid->renderGrid('#grid','#pager',true, null, null, true,true);
$conn = null;