Hello,
I’m using dhtmlxgrid ( dhtmlxSuite 2009 Rel.2 (DHTMLX 2.5) Professional edition build 91111 ) with connector (dhtmlxConnector for PHP v.0.96 ) and i can’t update one column.
this is my code:
var dhxGridStudy = dhxLayout.cells(“a”).attachGrid();
dhxGridStudy.setImagePath("./dhtmlxSuite/dhtmlxGrid/codebase/imgs/");
dhxGridStudy.setSkin(“dhx_black”);
dhxGridStudy.init();
dhxGridStudy.enableSmartRendering(true);
dhxGridStudy.loadXML(“php/getstudies_connector.php”,function(){
dhxGridStudy.setSelectedRow(1);
doOnRowSelectStudy(1,0);
});
myDataProcessor=new dataProcessor(“php/getstudies_connector.php”);
myDataProcessor.enableDebug(true);
myDataProcessor.enableDataNames(true);
myDataProcessor.setTransactionMode(“GET”);
myDataProcessor.init(dhxGridStudy);
////////////////////////
and for ‘getstudies_connector.php’:
require_once("…/dhtmlxSuite/dhtmlxConnector_php/codebase/grid_connector.php");
// Fichiers Include
include (“connexion.php”);
$gridConn = new GridConnector($resultConnection,“MySQL”);
//$gridConn->set_encoding(“iso-8859-1”);
$gridConn->dynamic_loading(40);
$gridConn->enable_log(“some.txt”);
$gridConn->event->attach(“beforeOutput”,“grid_header”);
$gridConn->event->attach(“beforeUpdate”,“doBeforeUpdate”);
$gridConn->render_sql(“SELECT study.ID as SID, StudyDescription, date_format(StudyDate,’%d/%m/%Y’) as sd, Modality as moda,ReferringPhysiciansName, NameOfPhysiciansReadingStudy,AccessionNumber, IDPatient, PatientID, PatientsName, PatientsSex, date_format(PatientsBirthDate,’%d/%m/%Y’) as pbd, ReferencedStudySequence, RTFReportPath FROM study INNER JOIN patient ON (study.IDPatient = patient.ID)”,"",“IDPatient,ReferencedStudySequence,ImagePGEType,PatientID,PatientsName,PatientsSex,pbd,SID,StudyDescription,sd,moda,nbSer,nbImg,ReferringPhysiciansName,NameOfPhysiciansReadingStudy,AccessionNumber”,"","");
function doBeforeUpdate($action){
$id = $action->get_value(“sid”);
$data = $action->get_value(“ReferencedStudySequence”);
mysql_query(“update study set ReferencedStudySequence=’”.$data."’ where study.ID=’".$id."’");
$action->success();
}
////////////////////////
Here my diff�rents logs:
some.txt:
====================================
Log started, 14/01/2010 09:01:10
====================================
SELECT study.ID as SID, StudyDescription, date_format(StudyDate,’%d/%m/%Y’) as sd, Modality as moda,ReferringPhysiciansName, NameOfPhysiciansReadingStudy,AccessionNumber, IDPatient, PatientID, PatientsName, PatientsSex, date_format(PatientsBirthDate,’%d/%m/%Y’) as pbd, ReferencedStudySequence, RTFReportPath FROM study INNER JOIN patient ON (study.IDPatient = patient.ID) LIMIT 0,40
SELECT COUNT(*) as DHX_COUNT FROM study INNER JOIN patient ON (study.IDPatient = patient.ID)
Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\php\getstudies_connector.php:4) at C:\xampp\htdocs\dhtmlxSuite\dhtmlxConnector_php\codebase\base_connector.php line 428
Done in 6.7949199676514s
====================================
Log started, 14/01/2010 09:01:19
====================================
DataProcessor object initialized
1263457871_1_gr_id => 1263457871_1
1263457871_1_IDPatient => 43
1263457871_1_ReferencedStudySequence => 1
1263457871_1_ImagePGEType => localhost/res/imgs/report_dis.gif
1263457871_1_PatientID => 012345678
1263457871_1_PatientsName =>
1263457871_1_PatientsSex => f
1263457871_1_pdb => 11/00/2020
1263457871_1_SID => 52
1263457871_1_StudyDescription =>
1263457871_1_sd =>
1263457871_1_moda => CR
1263457871_1_nbSer => 1
1263457871_1_nbImg => 1
1263457871_1_ReferringPhysiciansName =>
1263457871_1_NameOfPhysiciansReadingStudy =>
1263457871_1_AccessionNumber => 1234
1263457871_1_!nativeeditor_status => updated
ids => 1263457871_1
Row data [1263457871_1]
Incorrect field name used: sid
data
Incorrect field name used: ReferencedStudySequence
data
Event code for update processed
Edit operation finished
0 => action:updated; sid:1263457871_1; tid:1263457871_1;
Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\php\getstudies_connector.php:4) at C:\xampp\htdocs\dhtmlxSuite\dhtmlxConnector_php\codebase\dataprocessor.php line 206
Done in 0.0035309791564941s
and dataprocessor debug:
Log:
row 1263457871_1 marked [updated,valid]
Initiating data sending for 1263457871_1
Initiating data sending for all rows
Sending all data at once
Server url: php/getstudies_connector.php?editing=true parameters
1263457871_1_gr_id=1263457871_1
1263457871_1_IDPatient=43
1263457871_1_ReferencedStudySequence=1
1263457871_1_ImagePGEType=http%3A%2F%2Flocalhost%2Fres%2Fimgs%2Freport_dis.gif
1263457871_1_PatientID=012345678
1263457871_1_PatientsName=
1263457871_1_PatientsSex=f
1263457871_1_pdb=11%2F00%2F2020
1263457871_1_SID=52
1263457871_1_StudyDescription=
1263457871_1_sd=
1263457871_1_moda=CR
1263457871_1_nbSer=1
1263457871_1_nbImg=1
1263457871_1_ReferringPhysiciansName=
1263457871_1_NameOfPhysiciansReadingStudy=
1263457871_1_AccessionNumber=1234
1263457871_1_!nativeeditor_status=updated
ids=1263457871_1
Server response received details
<?xml version="1.0" encoding="iso-8859-1"?> <?xml version='1.0' ?>
Why i get “Incorrect field name used: sid” and “Incorrect field name used: ReferencedStudySequence”.
thanks for your help!
N. MATHIEU
Cannot modify header information - headers already sent by
Please check getstudies_connector.php - this file most probably have some whitespaces before <php tag, or outputs data in some other way.
This may break response parsing in FireFox
To fix the issue , you need to add some ID field in config
$gridConn->render_sql(“SELECT study.ID as SID, StudyDescription, date_format(StudyDate,’%d/%m/%Y’) as sd, Modality as moda,ReferringPhysiciansName, NameOfPhysiciansReadingStudy,AccessionNumber, IDPatient, PatientID, PatientsName, PatientsSex, date_format(PatientsBirthDate,’%d/%m/%Y’) as pbd, ReferencedStudySequence, RTFReportPath FROM study INNER JOIN patient ON (study.IDPatient = patient.ID)”,“SID”,"IDPatient,ReferencedStudySequence,ImagePGEType…
thanks a lot for your quick answer,
now it’s working.
There was a white space on top of my ‘php/getstudies_connector.php’.