Hi everybody,
I try to explain my problem,
I created a scheduler that loads data from the db… when i try to load data it works… but when i try to update not works…
require("codebase/connector/scheduler_connector.php");
require("codebase/connector/db_mssql.php");
$con=mssql_connect("10.10.10.10","xx","xyxyxyxyxy");
mssql_select_db("DataB",$res);
$scheduler = new SchedulerConnector($con,"MsSQL");
if ($scheduler->is_select_mode())
$scheduler->render_sql("SELECT a.startdate,a.enddate,a.text,a.details,a.location,a.eventlocation,a.lat,a.lng,a.noteindirizzo,a.nome,a.cognome,a.cfpiva,a.recapitoprincipale,a.recapitomobile,a.recapitoalternativo,a.comune,a.indirizzo,a.dettagliintervento,a.tipointervento,a.indirizzomaps FROM Agenda2 a INNER JOIN Un_Zona_Tecnico ON a.IdTecnico = Un_Zona_Tecnico.IdTecnico INNER JOIN Lst_Zone ON Un_Zona_Tecnico.IdZona = Lst_Zone.IdZona WHERE FlgAttivo=1 AND Un_Zona_Tecnico.IdZona = ".$idZona,"a.id","startdate,enddate,text,details,location,eventlocation,lat,lng,nome,cognome,cfpiva,recapitoprincipale,recapitomobile,recapitoalternativo,indirizzo,comune,noteindirizzo,dettagliintervento,tipo_intervento,indirizzo_maps,tecnico,color,textColor");
else
$scheduler-> render_table("Agenda2","id","startdate,enddate,text,details,location,eventlocation,lat,lng,noteindirizzo,nome,cognome,cfpiva,recapitoprincipale,recapitomobile,recapitoalternativo,comune,indirizzo,dettagliintervento,tipointervento,indirizzomaps");
If you use only the render_table to select and update works
if you use the If is_select_mode () when making the update does not work
where am I wrong?
Help Please …