How to show events on frontier calender

[pranshu.s...@lemosys.com]

I am just a newbie with this please tell me the basics to show agenda items on calender ....

[pranshu.s...@lemosys.com]

How to get agenda events from database using ajax call i need that array ....plz help if you get what i wanted

[Marcel Motta]

Try this way:

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

[Marcel Motta]

Or without using StringBuilder sb:

 while(rs.next()) {
     out.println("Event ID:" + rs.getString("evtCreatorID")+ ";Created By:" +rs.getString("evtCreatorID") + ";Event    Start Date:" + rs.getString("evtStartDate")+ ";" +  "Event End Date:" + rs.getString("evtEndDate")+ ";" + "Event Description:"+ rs.getString("evtDescription")+ ";" + "BackgroundColor:" +rs.getString("evtbackgroundcolor")+ ";ForegroundColor:"+ rs.getString("evtForegroundColor") + "|");

[Chandu Singh]

Hi marcel,

can you please help me

events are still not showing on calendar   please tell me what changes do i need to make on jsp page

[Marcel Motta]

I have another,

I can send you, it's not so good as Frontier, but works 

marceldsmotta   gmail dot com