Member Avatar for Satya Sai

hi Everybody,
I am doing project on web based events.
1) I am doing the project with jsp. I want to show the daily events on one hour basis.
like
8am eventDesc
9am eventDesc
-- ---
upto 9pm.
I want to show all the events that are occuring at 8 am. If there is event at any particular time it has show against the time. If there are no events it will show blank space.
How to show that?
2) I want to show last month day event. today ie.,if there is event on 2007-06-10. i have to show the last month event on 2007-07-10. i am getting problem reg sql statement. i have checked both month and day. if these are equal i have to show the event.
sql statement is

select * from Cal_Event where RepStatus='M' AND DAY('"+num+"')= DAY(NOW()) AND MONTH('"+num+"') = MONTH(NOW());

It is not working properly. Am i write or not?
I am using mysql as db.

pl help me
Sai

  • 2 Contributors
  • 1 Reply
  • 78 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by peter_budo
Member Avatar for peter_budo

If you have full instalation of Tomcat then there in examples you can find calendar. This will give you idea how to sort your problem.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.