I have inserted in FG_var_trunk.inc two "sql" forms, but in result I can to add elements, but can't to delete any. Where is my mistake or this is a bug of forms constructor?
$DBHandle_max = DbConnect(); $numrow = 0; $resmax = $DBHandle_max -> Execute("SELECT * FROM cc_trunk"); if ( $resmax ) <------>$numrow = $resmax -> RecordCount( );
if ($numrow>0) { <------>$HD_Form -> AddEditElement (gettext("RANDOM TRUNKS")." A", <------><------>"randomtrunksa", <------><------>'$value', <------><------>"SELECT", <------><------>'size="15" multiple="multiple"', <------><------>"", <------><------>"", <------><------>"sql", <------><------>"cc_trunk_rand_a", <------><------>"provider_name, id", <------><------>"", "", "%1 : (%2)", "", "", "cc_trunk_rand_a:trunk_depend:cc_trunk LEFT JOIN cc_trunk_rand_a ON cc_trunk.id_trunk=cc_trunk_rand_a.trunk_depend:DISTINCT cc_trunk.trunkcode, cc_trunk.id_trunk: cc_trunk_rand_a.trunk_id = %id:trunk_id:%2 - (%1)::::%1:id='%1'"); }
$DBHandle_maxb = DbConnect(); $numrowb = 0; $resmaxb = $DBHandle_maxb -> Execute("SELECT * FROM cc_trunk"); if ( $resmaxb ) <------>$numrowb = $resmaxb -> RecordCount( );
if ($numrowb>0) { <------>$HD_Form -> AddEditElement (gettext("RANDOM TRUNKS")." B", <------><------>"randomtrunksb", <------><------>'$value', <------><------>"SELECT", <------><------>'size="15" multiple="multiple"', <------><------>"", <------><------>"", <------><------>"sql", <------><------>"cc_trunk_rand_b", <------><------>"provider_name, id", <------><------>"", "", "%1 : (%2)", "", "", "cc_trunk_rand_b:trunk_depend:cc_trunk LEFT JOIN cc_trunk_rand_b ON cc_trunk.id_trunk=cc_trunk_rand_b.trunk_depend:DISTINCT cc_trunk.trunkcode, cc_trunk.id_trunk: cc_trunk_rand_b.trunk_id = %id:trunk_id:%2 - (%1)::::%1:id='%1'"); }
Second question. How to view UNsorted added elements ?
Yours, Nixon.
|