Form options type not sending data to DB

Suite and Optimus Suite 5
#1

i have an,form items of type select (options) are not sending data to the GridConnector when i bind the form as shown.
PS: I have dhtmlxprocessor.js and the debug.js included, this code has been shortened for other updates which are working.The form input type items are working properly.

//JS CODE
  var str = [
      { type:"block" , name:"block_one", offsetLeft:"30", list:[   
      { type:"select" , name:"departmentid", label:"Department", validate:"ValidInteger",    inputWidth:143, required:true, offsetTop:"10", position:"label-top",connector:"./.. /php/servers.php?options=true&department=2" },
{ type:"select" , name:"acctive", label:"Account Activation", labelWidth:170, inputWidth:143, required:true, offsetTop:"15", position:"label-top", options:[
 { value:"Activated", text:"Account Activated" },
 { value:"Deactivated", text:"Deactivate Account" }
                 ] },
 { type:"label" , name:"lab2", label:"Account Access Rights"  },
{ type:"select" , name:"payroll_priv", label:"Privileges On Payrolls", validate:"ValidAplhaNumeric", labelWidth:170, inputWidth:143, required:true, offsetTop:"10", position:"label-top", options:[
      { value:"n", text:"No Privileges" },
      { value:"e", text:"Edit Only" },
      { value:"c", text:"Create & Edit" },
      { value:"a", text:"Full Control" }
         ] },
{ type:"select" , name:"employee_priv", label:"Privileges On Employees", validate:"ValidAplhaNumeric", labelWidth:170, inputWidth:143, required:true, offsetTop:"10", position:"label-top", options:[
      { value:"n", text:"No Privileges" },
      { value:"e", text:"Edit Only" },
      { value:"c", text:"Create & Edit" },
      { value:"a", text:"Full Control" }
         ] }
      ]  }
   ];


      var admins_form = admins_form_cell.attachForm(str);
            admins_form.enableLiveValidation(true);
            admins_form.attachEvent("onValidateError", function (input, value, result){
           
                   dhtmlx.message({type:"error", text:admins_form.getItemLabel(input).replace(/\*+  /g,'')+" is missing!"});                     
         });
        admins_form.bind(admins_grid);

#
#PHP CODE
#
<?php
session_start();
require("../config.php");
require("./connector/db_mysqli.php");
require("./connector/grid_connector.php");
   
$dbc= new mysqli(DB_SERVER ,DB_USER,DB_PASS, DB_NAME);

function  update($data){
               $departmentID = trim(intval($data->get_value('departmentid')));            
               $emp_priv     = trim(strval($data->get_value('employee_priv')));
               $pay_priv     = trim(strval($data->get_value('payroll_priv')));
               $active       = trim(strval($data->get_value('active')));
         
               $lid          = $data->get_id();
              
             global $grid;
              

$grid->sql->query("UPDATE admin_priv SET     departmentid=".$departmentID.",employee_priv='".$emp_priv."',payroll_priv='".$pay_priv."' WHERE  loginid=".$lid." LIMIT 1");
           

$grid->sql->query("UPDATE login SET email='".$email."',password=SHA1('".$password."'),active='".$active."' WHERE loginid=".$lid." LIMIT 1");      

$data->success();
         }//END update

/*CRUD processing triggers*/
$grid->event->attach("beforeUpdate",   "update");
$grid->enable_log("./admins_grid.txt",true);
         
$loadSQL  = "SELECT * FROM department  INNER JOIN admin_priv USING(departmentid)  INNER JOIN login USING(loginid) WHERE login.level='A' ";
         $grid->render_sql($loadSQL,"loginid",",fname,lname,email,national_id,department_name,employee_priv,payroll_priv,active","password,level,departmentid,loginid");


PS: I have dhtmlxprocessor.js and the debug.js included,  this code has been shortened for other updates which are working
#2

Does new value updated in grid after saving in for?
Can you enable server side logs and provide their result for the problematic operation ?

#3

The new value does nt update bt for other item types it does…the options item sends the current grid value even when i select another

#4

in my log file i am seeing that the server receives the current grid value…n my grid coro types r nt sendin either

#5

in my log file i am seeing that the server receives the current grid value…n my grid coro types r nt sendin either

#6

Can you post the log in question here ?

#7

====================================
Log started, 20/02/2013 09:02:56

A session had already been started - ignoring session_start() at C:\wamp\www\captcha\php\connector\xss_filter.php line 178

DataProcessor object initialized
39_gr_id => 39
39_c0 => 4
39_c1 => Marow
39_c2 => Meko
39_c3 => marowmeko@gmail.com
39_c4 => 599211000
39_c5 => Women’s Attire
39_c6 => c
39_c7 => c
39_c8 => Activated
39_c9 => 12345678
39_c10 => 160
39_!nativeeditor_status => updated
ids => 39

Row data [39]
loginid => 39
=> 4
fname => Marow
lname => Meko
email => marowmeko@gmail.com
national_id => 599211000
department_name => Women’s Attire
employee_priv => c
payroll_priv => c
active => Activated
password => 12345678
departmentid => 160
!nativeeditor_status => updated

BEGIN

Incorrect field name used: level

data
loginid => 39
=> 4
fname => Marow
lname => Meko
email => marowmeko@gmail.com
national_id => 599211000
department_name => Women’s Attire
employee_priv => c
payroll_priv => c
active => Activated
password => 12345678
departmentid => 160
!nativeeditor_status => updated

UPDATE admin_priv SET fname=‘Marow’,lname=‘Meko’,departmentid=160,national_id=599211000,employee_priv=‘c’,payroll_priv=‘c’ WHERE loginid=39 LIMIT 1

UPDATE login SET email=‘marowmeko@gmail.com’,password=SHA1(‘12345678’),active=‘Activated’ WHERE loginid=39 LIMIT 1

Event code for update processed

COMMIT

Edit operation finished
0 => action:updated; sid:39; tid:39;

Done in 0.18881797790527s

#8

a) check that ids of columns in grid is exactly the same as names of form fields
b) if those are the coro fields in grid - check that they have the same values for options as selects in grid ( they must have not only labels but values as well )

#9

Here is my source code.please advice accordingly

[code]//the form items
{ type:“select” , name:“payroll_priv”, label:“Privileges On Payrolls”
validate:“ValidAplhaNumeric”, labelWidth:170, inputWidth:143, required:true, offsetTop:“10”, position:“label-top”, options:[
{ value:“n”, text:“No Privileges” },
{ value:“e”, text:“Edit Only” },
{ value:“c”, text:“Create & Edit” },
{ value:“a”, text:“Full Control” }
] },
{ type:“select” , name:“employee_priv”, label:“Privileges On Employees”, validate:“ValidAplhaNumeric”, labelWidth:170, inputWidth:143, required:true, offsetTop:“10”, position:“label-top”, options:[
{ value:“n”, text:“No Privileges” },
{ value:“e”, text:“Edit Only” },
{ value:“c”, text:“Create & Edit” },
{ value:“a”, text:“Full Control” }
] }
] }
];

//and my grid
admins_grid.setColumnIds(",fname,lname,email,national_id,department_name,employee_priv,payroll_priv,active,password,departmentid");

//server-side
$grid->set_options(“payroll_priv”,array(“a” => “ALL”, “e”=>“EDIT”,“c” => “CREATE ONLY”));
$grid->set_options(“employee_priv”,array(“a” => “ALL”, “e”=>“EDIT”,“c” => “CREATE ONLY”));
$grid->render_table(“gridtable”,“item_id”,“payroll_priv,employee_priv”);

[/code]

#10

Working sample sent by PM