Please post your problem here:

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

Here is the forum for the Open Source version, but you use the comertial one.

Regards

Tony

Before start sorry for language I'm french

I try tu use the queryGrid(); function but I can't make it work. Look at an example :

//code before

//define params

$param1 = 2;

//REQUETE

$grid->SelectCommand = "SELECT activite.code, activite.id_activite, travaux.id_travaux

FROM activite INNER JOIN travaux ON activite.id_activite = travaux.id_activite

WHERE travaux.id_activite = ?";

// Set the table to where you update the data

$grid->table = 'activite';

// Set output format to json

$grid->dataType = 'json';

$grid->queryGrid(null, array($param1));

//code after

The page don't load, just send me file name "*******.part" 

_____________________________________________________________________________________________

But if I replace ? by my value (2) and del  queryGrid()  it's works, page load and grid get good value :

//code before

//REQUETE

$grid->SelectCommand = "SELECT activite.code, activite.id_activite, travaux.id_travaux

FROM activite INNER JOIN travaux ON activite.id_activite = travaux.id_activite

WHERE travaux.id_activite = 2";

// Set the table to where you update the data

$grid->table = 'activite';

// Set output format to json

$grid->dataType = 'json';

//code after

Any idea ? I have read the doc http://www.trirand.net/documen.....m and I do exactly the same things

_________________________________________________________________________________________

I add all my code when it's not work : 

<?php

// INCLUDES LIB PHP FILES ***************************************************

// jqGrid.php

// jqGridPdo.php

require_once("include_php_files.php");

// START CONNEXION WHITH DB ***************************************************

$PARAM_hote = "localhost";

$PARAM_nom_bd = "cra";

$PARAM_utilisateur = "root";

$PARAM_mot_passe = "";

// try to connect with DB

try

{

$conn = new PDO('mysql:host='.$PARAM_hote.';dbname='.$PARAM_nom_bd, $PARAM_utilisateur, $PARAM_mot_passe);

}

catch(Exception $e)

{

echo "Erreur : impossible d'&eacute;tablir la connexion avec la base de donn&eacute;es dans connexion_bdd_PDO : ".$e->getMessage().'<br />';

}

// GRID CONSTRUCTOR ***************************************************

$grid = new jqGridRender($conn);

//parameters

$param1 = 2;

// REQUEST

$grid->SelectCommand = "SELECT activite.code, activite.id_activite, travaux.id_travaux

FROM activite INNER JOIN travaux ON activite.id_activite = travaux.id_activite

WHERE travaux.id_activite = ?";

// The praymery key to be set

$grid->setPrimaryKeyId('activite.id_activite');

// Defines if the primary key is serial (autoincrement)

$grid->serialKey = false;

// Set the table to where you update the data

$grid->table = 'activite';

// Set output format to json

// XML or Json

$grid->dataType = 'json';

//add parameters to the requuest

$grid->queryGrid(null, array($param1));

// debug mode

$grid->debug = true;

// COLUMN HEADINGS SECTION ********************************************

// Let the grid create the model

$grid->setColModel();

// GRID OPTIONS SECTION ***********************************************

// Set the url from where we obtain the data

$grid->setUrl('AJAX/AJAX_jquery_jgrid_3.php');

// Set some grid options

$grid->setGridOptions(array( "rowNum" => 10,

"rowList" => array(10,20,30),

"sortname" => "id_activite"

));

// Set ColProperty

$grid->setColProperty( 'code' , array(

"editoptions" => array("readonly"=>true))

);

$grid->setColProperty( 'id_activite' , array( "editable" => true)

);

// EDITING SECTION *****************************************************

// Enable navigator

$grid->navigator = true;

// Enable only editing

$grid->setNavOptions('navigator', array(

"excel" => false,

"add" => false,

"edit" => true,

"del" => false,

"view" => true,

"search"=> false

));

// Close the dialog after editing

$grid->setNavOptions('edit',array(

"closeAfterEdit" => true,

"editCaption" => "Update Customer",

"bSubmit" => "Update"

));

// FIELD PROPERTIES SECTION *****************************************************

$grid->setColProperty("code", array("width"=>300));

// Enjoy

$grid->renderGrid('#grid','#pager',true, null, null, true,true);

$conn = null;

?>