Select option box in grid problem

Suite and Optimus Suite 5
#1

Hi,
I leaved a question that select box with OptionConnector isn’t working :
viewtopic.php?f=2&t=24959
Searching how to solve this problem found that :
viewtopic.php?f=19&t=24833

This option documented here :
docs.dhtmlx.com/doku.php?id=dhtm … ns_in_grid

It seems that exist problem to do select box in grid from other table with OptionConnector. Though documentation is saying that this easy and simple … :slight_smile:

Both questions are not solved .

So I’m asking again - how to do select option with OptionConnector from other table ?

Mine source :

<?php
   require_once( "config.php" );
   require( "php/codebase/grid_connector.php" );
   require( "php/codebase/db_mysqli.php" );
   
   $slc_fld = $_REQUEST[ 'lauku_eile' ];
   $link  = new mysqli( $myServ, $myUser, $myPasw, $myDb );
   if ( $link->connect_errno )
      die( 'Conection error !' );

   $grid = new GridConnector( $link, "MySQLi" );
   $grid->dynamic_loading( 100 );

   $grid->enable_log( "temp.log", true );

   $slct = new OptionsConnector( $link );
   $slct->render_sql( "select preke,pav_lt from prekes where prek_tipas = 'Gaminys' order by preke", "", "preke(value),pav_lt(label)" );
   $grid->set_options( "preke", $slct );
   $grid->render_table( "uzsakym", "uzsak", $slc_fld );
?>
      var mygrid = tabbar.cells( tabbar.getActiveTab() ).attachGrid();
      mygrid.setImagePath( "codebase/imgs/" );
      mygrid.setSkin( "dhx_skyblue" ); 
      mygrid.setColumnIds( slc_fld )  // slc_fld = "uzsak,preke,telkinys,uzs_kiekis,specai,svarbus...
      mygrid.setHeader( grd_set[ 1 ] );
      mygrid.attachHeader( grd_set[ 2 ] );
      mygrid.setColTypes( grd_set[ 3 ] ); // "ro,co,ed,ed,chch..."
      mygrid.setColSorting( grd_set[ 4 ] );
      mygrid.setInitWidths( grd_set[ 5 ] )
      mygrid.setColAlign( grd_set[ 6 ] )
      mygrid.setColumnsVisibility( grd_set[ 7 ] );
      mygrid.setNumberFormat( "00000", kiek_col );
      mygrid.setDateFormat( "%Y.%m.%d" );

      mygrid.enableSmartRendering( true, 100 );
      mygrid.init();
      mygrid.load( "uzs1.php?lauku_eile=" + slc_fld );
      myDp = new dataProcessor( "uzs1.php?lauku_eile=" + slc_fld );
      myDp.init( mygrid );

      mygrid.enableMultiselect( true );
      mygrid.enableHeaderMenu();
      mygrid.enableColumnMove( true );
      mygrid.enableUndoRedo();

Select option box is empty .

Here log data :

====================================
Log started, 13/07/2012 05:07:08
====================================
SELECT  preke,pav_lt FROM prekes WHERE ( prek_tipas = 'Gaminys') ORDER BY `preke` ASC

mysql_query() expects parameter 2 to be resource, object given at C:\wamp\www\engel\php\codebase\db_common.php line 916

mysql_fetch_assoc() expects parameter 1 to be resource, null given at C:\wamp\www\engel\php\codebase\db_common.php line 926

SELECT DISTINCT `svarbus` as value FROM uzsakym

SELECT DISTINCT `specai` as value FROM uzsakym

SELECT DISTINCT `mazi` as value FROM uzsakym

SELECT DISTINCT `uzs_data` as value FROM uzsakym

SELECT DISTINCT `uzs_sav` as value FROM uzsakym

SELECT DISTINCT `graz_data` as value FROM uzsakym

SELECT DISTINCT `graz_sav` as value FROM uzsakym

SELECT DISTINCT `fakt_data` as value FROM uzsakym

SELECT DISTINCT `fakt_sav` as value FROM uzsakym

SELECT DISTINCT `kerpa` as value FROM uzsakym

SELECT DISTINCT `subrang` as value FROM uzsakym

SELECT DISTINCT `aud_nuras` as value FROM uzsakym

SELECT DISTINCT `frn_nuras` as value FROM uzsakym

SELECT DISTINCT `invc_nuras` as value FROM uzsakym

SELECT DISTINCT `nav_nuras` as value FROM uzsakym

SELECT DISTINCT `pasel_prad` as value FROM uzsakym

SELECT DISTINCT `pokav_prad` as value FROM uzsakym

SELECT `uzsak`,`uzsak`,`telkinys`,`preke`,`uzs_kiekis`,`svarbus`,`specai`,`mazi`,`uzs_spalv`,`uzs_data`,`uzs_sav`,`graz_data`,`graz_sav`,`fakt_data`,`fakt_sav`,`pastabos_ord`,`zymos`,`kerpa`,`sukirp_lap`,`subrang`,`aud_nuras`,`frn_nuras`,`invc_nuras`,`nav_nuras`,`pasel_prad`,`pokav_prad`,`plan_modelis`,`pastabos_buh`,`pastabos_zs` FROM uzsakym LIMIT 0,100

SELECT COUNT(*) as DHX_COUNT  FROM uzsakym

Please help to solve problem .

Suite Pro version, 110713 build .

#2

a) change

$slct->render_sql( “select preke,pav_lt from prekes where prek_tipas = ‘Gaminys’ order by preke”, “”, “preke(value),pav_lt(label)” );

as

$slct->render_sql( “select preke as value,pav_lt as label from prekes where prek_tipas = ‘Gaminys’ order by preke”, “”, “preke(value),pav_lt(label)” );

b) change

$slct = new OptionsConnector( $link );

as

$slct = new OptionsConnector( $link, “MySQLi” );