loading just one event per day

[Marcel Motta]

Amazing job sir,

 I'm using Postresql wich do'nt accept camelcase.

CREATE TABLE public.calevents
(
  evtid integer NOT NULL,
  evtcreatorid character varying(255),
  evtdescription character varying(2000),
  evtbackgroundcolor character varying(10),
  evtforegroundcolor character varying(10),
  evtstartdate character varying(24),
  evtenddate character varying(24),
  CONSTRAINT id_calevents_pk PRIMARY KEY (evtid)
);

 I got  to run the calendar with Java JSP Servlets, this way on the getCalServlet

 

   while(rs.next()) {
                   
                    sb.append("Event ID:").append(rs.getInt("evtid")).append(";");
                   
                   System.out.println(rs.getInt("evtid"));
                 sb.append("Created By:").append(rs.getString("evtcreatorid")).append(";");
                
                 sb.append("Event Start Date:").append(rs.getString("evtstartdate")).append(";");
               
                 System.out.println(rs.getString("evtstartdate"));
                 sb.append("Event End Date:").append(rs.getString("evtenddate")).append(";");
               
                 System.out.println(rs.getString("evtenddate"));
                 sb.append("Event Description:").append(rs.getString("evtdescription")).append(";");
               
                 sb.append("BackgroundColor:").append(rs.getString("evtbackgroundcolor")).append(";");
                         
                 sb.append("ForegroundColor:").append(rs.getString("evtforegroundcolor"));
                
                 sb.append("|");
                    
                }
               
                out.println(sb);

 but it's just loading one event per day.

[Marcel Motta]

Well,

 The StartDate was point out as EndDate, so I Changed:

startDate = startYear + "-" + startMonth + "-" + startDay + " " + startHour + ":" + startMin + ":00";
                    //endDate = startYear + "-" + startMonth + "-" + startDay + " " + startHour + ":" + startMin + ":00"; //
                    // new way bellow
                    endDate    = endYear + "-"    + endMonth + "-" + endDay + " "    + endHour + ":" + endMin + ":00";
                    $.ajax({ 

But it didn't show the new event with the right endDate.