DATAPROCESSOR returning sid=null,tid=null.HEEEEEEELP

I don’t know the cause but update,insert & delete are not working.i am using the latest version 3.5…help
Log file results

====================================
Log started, 17/03/2013 10:03:17
====================================

DataProcessor object initialized
null_fname => Beatrice
null_gender => Female
null_national_id => 27214190
null_nationality => Kenya
null_married => 0
null_height => 
null_mname => Marsha
null_dob => 1989-03-05 00:00:00
null_mobile => 0700110110
null_address => 40
null_spouse => Kenneth Ojode
null_religion => Christianity
null_lname => Wathikwa
null_email => beatricewathikwa@gmail.com
null_postal_code => 00908
null_kin => Benson Michael
null_city => Mombasa
null_name => Benson Michael
null_eaddress => 59
null_relationship => Friend
null_emobile => 0789135638
null_dname => Brian Michael
null_allergy => Wheat
null_bloodgrp => AB+
null_daddress => 68
null_medical_cdt => None
null_dmobile => 0712345345
null_current_cdt => Healthy
null_hiredate => 2010-01-04 00:00:00
null_grpname => C
null_departmentid => 160
null_active => Activated
null_startpos => Cashier
null_level => Employee
null_employeeid => 178
null_endpos => Cashier
null_commuter => 500.00
null_medical => 550.00
null_house => 900.00
null_salaryscale => 9500
null_termdate => N/A
null_department_name => Women's Attire
null_!nativeeditor_status => updated
ids => null

Row data [null]
fname => Beatrice
gender => Female
national_id => 27214190
nationality => Kenya
married => 0
height => 
mname => Marsha
dob => 1989-03-05 00:00:00
mobile => 0700110110
address => 40
spouse => Kenneth Ojode
religion => Christianity
lname => Wathikwa
email => beatricewathikwa@gmail.com
postal_code => 00908
kin => Benson Michael
city => Mombasa
name => Benson Michael
eaddress => 59
relationship => Friend
emobile => 0789135638
dname => Brian Michael
allergy => Wheat
bloodgrp => AB+
daddress => 68
medical_cdt => None
dmobile => 0712345345
current_cdt => Healthy
hiredate => 2010-01-04 00:00:00
grpname => C
departmentid => 160
active => Activated
startpos => Cashier
level => Employee
employeeid => 178
endpos => Cashier
commuter => 500.00
medical => 550.00
house => 900.00
salaryscale => 9500
termdate => N/A
department_name => Women's Attire
!nativeeditor_status => updated

UPDATE `login` INNER JOIN employee USING(`loginid`) INNER JOIN `contract`USING(`employeeid`) INNER JOIN  `department` USING(`departmentid`) INNER JOIN `emergency` USING(`employeeid`) INNER JOIN  `medical` USING(`employeeid`) INNER JOIN `job_grp`  USING(`grpid`) INNER JOIN allowance USING(`grpid`) SET emobile='0789135638',level='Employee',active='Activated',city='Mombasa',employeeid='178',departmentid='160',endpos='Cashier',commuter='500.00',mname='Marsha',lname='Wathikwa',spouse='Kenneth Ojode',kin='Benson Michael',medical='550.00',house='900.00',grpname='C',salaryscale='9500',name='Benson Michael',eaddress='59',relationship='Friend',fname='Beatrice',gender='Female',dob='1989-03-05 00:00:00',gender='Female',national_id='27214190',married='0',mobile='0700110110',hiredate='2010-01-04 00:00:00',termdate='N/A',startpos='Cashier',endpos='Cashier',department_name='Women\'s Attire',nationality='Kenya',address='40',city='Mombasa',postal_code='00908',email='beatricewathikwa@gmail.com',medical_cdt='None',current_cdt='Healthy',dname='Brian Michael',daddress='68',dmobile='0712345345',allergy='Wheat',bloodgrp='AB+' WHERE employeeid='null' AND (employeeid = '178')

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

Done in 0.01616096496582s

JAVASCRIPT CODE[code]

[/code] FORM INITIALISATION [code] //initialise the leaveForm function initLeaveForm(){ //leaveForm.formId = "12900"; leaveForm.enableLiveValidation(true); leaveForm.attachEvent("onValidateError", function (input, value, result){ dhtmlx.message({type:"error", text:leaveForm.getItemLabel(input).replace(/\*+/g,'')+" is missing!"}); }); leaveForm.attachEvent("onUploadFail",function(realName){ dhtmlx.message({type:"error", text:realname +" not uploaded,either the file is too big or not the right type\nAllowed Types:PDF,word document\nAllowed Size: Less than 5MB"}); }); leaveForm.attachEvent("onUploadFile",function(realName,serverName){ dhtmlx.message(realName+" being uploaded.."); }); leaveForm.attachEvent("onUploadComplete",function(count){ dhtmlx.message(count + " document succesfully uploaded.."); }); leaveForm.attachEvent("onFileRemove",function(realName,serverName){ dhtmlx.message(realName + " has been removed from the list.."); }); //leaveForm.resetDataProcessor("inserted"); //leaveForm.load("./../php/apply_leave2.php?action=insert");
		leaveFormDP = new dataProcessor("./../php/apply_leave2.php");
		//leaveFormDP.setTransactionMode("POST", true);
		leaveFormDP.attachEvent("onAfterUpdate", function() {
			//dhtmlx.message("Leave Applied succesfully");
	        rich_message();
			return true;
		});
		leaveFormDP.init(leaveForm); 

}//END initLeaveForm()

[/code]

It seems you are using render_sql with multiple tables join as source of data - it will not work for data saving automatically. You need to define a single table for data saving, or assign custom data saving SQL or code.

docs.dhtmlx.com/doku.php?id=dhtm … ex_queries

u dd nt understand my problem…i tried custom update bt the id sent z null…NULL is my main problem since t won’t allow any update,which needs an id

I’m not sure how you are loading data in form, but you can use code like next

form.formId = id; form.resetDataProcessor("updated");

Which will set id for the record in form, and set the next form saving operation as update

i am using a single grid to load data on 5 different forms each having a dataprocessor.the forms are loaded usin the grid’s onRowSelect event…how do i tackle the problem from there bearin in mind that each form has a seperate php script for CRUD

When loading data in form you are using something like

[code]grid.attachEvent(“onRowSelect”, function(id){

form.load(“some.url”)

});[/code]

You can change it as

[code]grid.attachEvent(“onRowSelect”, function(id){

form.load(“some.url”)
form.formId = id; // id of record which will be loaded in form

});[/code]