Joining tables and insert/update

Scheduler Javascript
#1

I followed the joining tables example here: http://docs.dhtmlx.com/doku.php?id=dhtmlxconnector:basis#work_with_several_tables

$details = new JSONDataConnector($res); $details->configure("intervenant","intervenant_id","intervenant_nom,intervenant_prenom, intervenant_portable"); $scheduler = new JSONSchedulerConnector($res, $dbtype); $scheduler->set_options("intervenant", $list_intervenant); $scheduler->set_options("site", $list_site); $scheduler->mix("intervenants", $details, array( "intervenant_id" => "intervenant_id" )); $scheduler->render_table("event","event_id","start_date,end_date,text,event_details,site_id,intervenant_id,event_conge");
After I want to display datas from the joined table in event_text and event_bar_text :

scheduler.templates.event_text=function(start,end,event){ return event.intervenants.intervenant_nom+" "+event.intervenants.intervenant_prenom+" "+event.intervenants.intervenant_portable; } scheduler.templates.event_bar_text=function(start,end,event){ return event.intervenants.intervenant_nom+" "+event.intervenants.intervenant_prenom+" "+event.intervenants.intervenant_portable; }
It displays correctly my datas but when I want to update or create a new event I have an error :
‘intervenants.intervenant_nom’ is Null or is not an object.
Can I insert or update datas with this method ?

#2

Try to use code like next

[code]if ($scheduler->is_select_mode()){
$details = new JSONDataConnector($res);
$details->configure(“intervenant”,“intervenant_id”,“intervenant_nom,intervenant_prenom, intervenant_portable”);
$scheduler = new JSONSchedulerConnector($res, $dbtype);
$scheduler->set_options(“intervenant”, $list_intervenant);
$scheduler->set_options(“site”, $list_site);
$scheduler->mix(“intervenants”, $details, array(
“intervenant_id” => “intervenant_id”
));
}

$scheduler->render_table(“event”,“event_id”,“start_date,end_date,text,event_details,site_id,intervenant_id,event_conge”);[/code]

It will make sub-query only for select operation

#3

Unfortunately this doesn’t work when I want to add a new event.
I still have this error : TypeError: event.intervenants is undefined
It concerns this line return event.intervenants.intervenant_nom+" "+event.intervenants.intervenant_prenom+" "+event.intervenants.intervenant_portable;

#4

It doesn’t related to the server side anymore.
When you are adding new event, you have new event object without intervenants property ( because it was created on client side, not on server side ), so in the code of template you need to have a check, that will verify is object has intervenants collection before using value from it.