A couple of questions

Scheduler Javascript
#1

First of all, thank you for your job.

I have a couple of questions.

  1. In my lightbox, I have a select section, where options are the data from my DB.
scheduler.config.lightbox.sections=[	
		        {name:"meetroomname", height:21, type:"select", map_to:"meetroomname", options:scheduler.serverList("type2")},	
			{name:"username", height:21, type:"select", map_to:"username", options:scheduler.serverList("type")},	
			{name:"users", height:21, type:"textarea", map_to:"users"},
			{name:"description", height:100, map_to:"text", type:"textarea" , focus:true},
            {name:"time", height:72, type:"calendar_time", map_to:"auto"}
		]

My Scheduler_BasicConnector.java

	Connection conn= ( new DataBaseConnection()).getConnection();
		SchedulerConnector c = new SchedulerConnector(conn);
		OptionsConnector userNameList=new OptionsConnector(conn);
		OptionsConnector meetroomList=new OptionsConnector(conn);
		c.event.attach(new CustomBehavior(c));
		meetroomList.render_table("mst_meetroom", "meetroom_id", "meetroomname(value),meetroomname(label)");
		userNameList.render_table("mst_user", "user_id", "username(value),username(label)");
		c.set_options("type2", meetroomList);
		c.set_options("type", userNameList);
		if(c.is_select_mode()){
			c.render_sql("SELECT * FROM events, attend_users, mst_user, mst_meetroom WHERE  events.attend_users_id=attend_users.attend_users_id && events.user_id = mst_user.user_id && events.meetroom_id = mst_meetroom.meetroom_id", "event_id","start_date,end_date,event_text,meetroomname,users, username","","");
		}else{
			c.render_table("events","event_id","start_date,end_date,event_text, attend_users_id, user_id, meetroom_id","","");
		}

So the problem is, that if i have 2 usernames or 2 meetroomnames, in my db, there is only one shows in Lightbox select sections. If i have 3 of it only 2 are shown, etc.

  1. Im using separated minicalendar. The second problem is that after Insert, Update, Delete events i have to refresh page to get my updates shown in minicalendar. How can I force automaticaly refresh minicalendar, after the Events are done.
#2

You are using MySQL as database right ?

We will try to reconstruct issue locally, but so far your code seems valid and must not cause issue with options list loading.

#3

Stanislav,

Yes, right. Im using MySQL.

And what about the second question. How can I refresh minicalendar automatically, after insert/update/delete events are done.

#4

Hi,
could you provide dump of database tables with some test data?