How to - Display database rows in a calendar format
Connie Kamrowski
Greenhorn
Joined: Aug 15, 2004
Posts: 23
posted
0
I need to display rows from a database in an interactive calendar on my web front end. The dates are stored in an Informix database in format dd/mm/yyyy. I am trying to build an interactive diary format and want to display start and end dates in a calendar style display but am a little unsure where to start, any suggestions appreciated.
**How much deeper would the ocean be if Sponges didn't grow in it?**
Daniel Rhoades
Ranch Hand
Joined: Jun 30, 2004
Posts: 186
posted
0
Is your question: "how do I format the dates" or "how do I build an interactive calender"
Drinking more tea is the key...
Connie Kamrowski
Greenhorn
Joined: Aug 15, 2004
Posts: 23
posted
0
Sorry for the misunderstanding.
I am comfortable with formats and have no issues with the Java to get the information I want. I have not had a lot to do with JSP but it has been requested as the development environment for my pages. I need some direction on how to create the calender. I want it to display the days of the month and in each day the information recorded for that particular date in my database. I would also like to make it interactive but I have no issue with how to create that once I get my head around displaying the data as a calender. I realise this is probably newbie stuff. My experience to date has been rather specialised.
Adeel Ansari
Ranch Hand
Joined: Aug 15, 2004
Posts: 2874
posted
0
So, your question is how to display the data in calender like structure while presenting? You need a display algorithm, right??
Connie Kamrowski
Greenhorn
Joined: Aug 15, 2004
Posts: 23
posted
0
Yes. I do not know how to display my results in a calendar format. I ahev not done this before.
Stefan Evans
Bartender
Joined: Jul 06, 2005
Posts: 1005
posted
0
I guess that makes the problem less one of JSP, and more of HTML/dHTML design.
What do you want the calendar to look like on the screen? Can you create a static version of that in HTML/javascript? Then you just need to convert that to build the HTML dynamically with JSP.
Connie Kamrowski
Greenhorn
Joined: Aug 15, 2004
Posts: 23
posted
0
Your right it probably is more a HTML issue, I want to display it as a month at a glance type display.