Error setLoadMode with render_sql

Scheduler Javascript
#1

Hi

I hava a problem is that not return information when I use scheduler.setLoadMode(“month”). I have using render_sql, when i don’t use scheduler.setLoadMode(“month”) its work it, please help me, my code is:

js

scheduler.config.xml_date="%Y-%m-%d"; 
			scheduler.config.readonly=true;
			scheduler.config.date_step = "5"; 
			scheduler.xy.scale_height = 40; 
			scheduler.xy.scale_width = 50; 
			scheduler.config.event_duration = 30; 
			scheduler.config.auto_end_date = true; 
			scheduler.config.multi_day = true;
			scheduler.xy.scroll_width = 0;
			scheduler.xy.bar_height=55;
			scheduler.init('scheduler_here',null,"month"); 
			scheduler.setLoadMode("month");
			scheduler.load("xml/events.php?uid="+scheduler.uid()+(new Date()).valueOf()); 
            		var dp = new dataProcessor("events.php");
			dp.init(scheduler);

Sql Server

$Sigla=$_SESSION["Sigla"];
$filtros=array(array("Sigla",$Sigla));
$scheduler->render_sql("SELECT EAC.Codigo_Curso +cast(ECP.Id as varchar(10)) as Id,CONVERT(varchar,EAC.Fecha, 120) as Fecha_Hora_Inicio,CONVERT(varchar,DATEADD (minute , 45 , EAC.Fecha), 120) as Fecha_Hora_Final,ECP.Descripcion as Nombre,A.Nombre as Lugar,'PRUEBA_IAE'+cast('' as varchar(10)) as Sigla FROM [Evento Academico Curso] as EAC, [Evaluacion Cuaderno Profesor] as ECP,[Asignatura] as A,[Tipo Evaluacion Cuaderno Profesor] as TEC WHERE EAC.Id_Evaluacion_Cuaderno_Profesor=ECP.Id and ECP.Rut_Profesor ='9.832.898-K' and A.Sigla=ECP.Sigla_Asignatura  and EAC.Fecha_Publicacion IS NOT NULL and TEC.Id=ECP.Tipo_Evaluacion","Id","Fecha_Hora_Inicio,Fecha_Hora_Final,Nombre,Lugar,Sigla",$filtros);

Any Idea, I need use dynamic loading but whe use scheduler.setLoadMode(“month”) don’t works it

best regards

Mike

#2

Hello,

CONVERT(varchar,EAC.Fecha, 120) as Fecha_Hora_Inicio

In your case connectors won’t help you automatically. Though you can “from” and “to” parameters from GET request yourself and use them in the query.

Best regards,
Ilya