0

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
2
Views
10 Years
Discussion Span
Last Post by peter_budo
0

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.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.