how to retrieve data from DB to extra added fields

Scheduler Javascript
#1

i have an extra text fields like Address,City, and a select box like States.
i am saving my fields in data base but i to display when the user want to edit the event , at that time i am getting empty fields except that description. can you tell me that i want to display all the fields which r saved in DB.

          Thanking you.
#2

If you are using connectors - just add such fields to the list of used fields ( third parameter of render_table method ) - after that they will be available on client side.

For list of options - check
docs.dhtmlx.com/doku.php?id=dhtm … al_loading

#3

i saved the events in data base like this, is this the correct way…
scheduler.attachEvent(“onEventSave”,function(id,data){
/for(i in data)
{
// /alert(data[i] + ’ i value : ’ + i);
}/
// alert('inside attacdhEvent ’ + data.start_date + ’ text ’ + data.text + ’
// time : ’ + data.end_date + ’ repeat : ’ + data.time);

if (!data.text) {
        alert("Text must not be empty");
        return false;
}
if (!data.text.length>20) {
        alert("Text too small");
        return false;
}
alert("rec_type for recurring----"+data.rec_type)
var startdate = data.start_date;
var formatDate= startdate.getFullYear() + "-" + (startdate.getMonth()+1) + "-" + startdate.getDate()  +  " " + startdate.getHours() + ":" + startdate.getMinutes() + ":" + startdate.getSeconds();
var enddate = data.end_date;
var formatEndDate= enddate.getFullYear() + "-" +  (enddate.getMonth()+1) + "-" + enddate.getDate()  +   " " + enddate.getHours() + ":" + enddate.getMinutes() + ":" + enddate.getSeconds();
  $.ajax( {
    url : jQuery.url.getChatURL("/calendar/ajaxAddEvent.do"),
            cache : false,
            data: "startDate=" + formatDate + "&message=" + data.text + "&title=" + data.title +"&endDate=" + formatEndDate + "&address1="+ data.address1 + "&address2="+ data.address2 + "&city="+ data.city + "&state="+ data.states + "&postalCode="+ data.zip + "&recType="+ data.rec_type,                
            success : function(html) {                                           
                    $("#eventDetails"+data).html('');                                                                                                                                
            }
    });
return true;

});

function loadAllEvents() {
var eventDetailsURL = jQuery.url.getChatURL("/calendar/ajaxGetEventDetails.do");
var text =’’;
var startDate=’’;
var endDate=’’;
var recType=’’;
var eventId =’’;
$.ajax({
url :eventDetailsURL,
cache : false,
dataType : ‘json’,
success : function(response)
{
if (response.allEventDetails == ‘success’)
{
var eventDetailsList = response.eventDetailsList
for ( var i = 0; i < eventDetailsList.length; i++)
{
eventId = eventDetailsList[i].id;
alert(eventId);
text = eventDetailsList[i].message;
startDate=eventDetailsList[i].startDate;
startDate=startDate.replace(“T”," “);
endDate= eventDetailsList[i].endDate;
endDate=endDate.replace(“T”,” ");
recType=eventDetailsList[i].recType;
init(text,startDate,endDate,recType,eventId);

			}
		}
	}
	});
	$("#eventsHome").hide();
	$("#scheduleCalendar").show();
	 init();

}

#4

If you are using custom code for data saving | loading - just be sure that incoming XML contains sub-tags with custom properties ( name of sub-tag will be used as name of property, and its value as value of sub-property )

#5

i seen a example in dhtmlxScheduler\samples\03_extensions\14_readonly_event.html.
How i can i keep this event should be readOnly , and this can be editable .
Can you please explain this one.

#6

That is code for readonly event creation, as you can see it has readonly property
Same can be done during loading from XML by setting sub tag.
Events without such property|tag will be editable

scheduler.addEvent({ id:2, start_date:"2009-11-20", end_date:"2009-11-25", text:"readonly (dbl-click)", readonly:true });