CalendarXP.net Support

[kguttman]

I recently installed the MultiPicker calendar. The calendar is part of a larger ColdFusion form, and I am currently able to select one or more dates using the calendar, and pass those dates into a database. My form processing page parses the date(s) passed via the allSelected form field and inserts each individual date into SQL Server.

I would like to be able to reverse this process -- select one or more dates from the SQL Server table, and have them be preselected on the calendar. I can put the date(s) into any format necessary for the calendar to read them; I just don't know which javascript function can take a series of dates and preselect them on the calendar. I only need to preselect the dates; no other information needs to be displayed on the calendar.

As an example, let's say that I am using the MultiPicker to select dates during which training classes will occur, and each class takes place over three days. I might select April 1, April 3, and April 5 using the MultiPicker in my form, and then pass those dates into my database using the allSelected form field, along with my other form fields.

Now let's say that I want to be able to edit the information for my class, including the dates. This means I need to pull all the information about the class from my database, and display it in a new set of HTML form fields, by prepopulating the fields with the info from the database. When I am finished editing the information, the form processing page updates the database with the new information, no matter if I updated just one field or all of them.

Using the example above, when I go to edit this class' information, I would like to have April 1, April 3, and April 5 preselected on the calendar. If I don't need to edit the dates, these three dates will be passed back into the database in the allSelected field, as if I were inserting them for the first time. But if the dates need to change, then I need to be able to deselect the old dates and select new dates.

Can you please suggest the best way to preselect one or more dates using the MultiPicker calendar? I understand how to add agenda events to the calendar, but I didn't think this was appropriate for my situation, since I only need to be able to preselect a series of dates. I don't need to display any other information using the calendar. I also don't need to show the preselected dates in a different color than the usual "selected" color.

Thank you.

[calendarxp]

It's actually been detailed in the MultiPicker Demo page already - all you need to preselect dates is just to generate the fInitAgenda() function properly.

The following is a quick example in JSP:

[kguttman]

I appreciate the quick reply. I had forgotten that the demo provided guidance on dynamically preselecting dates.