| | |
pl help me regarding web based events...
Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Jul 2007
Posts: 1
Reputation:
Solved Threads: 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
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
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.
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group
![]() |
Similar Threads
- Web-Based Applications Developer needed in Silicon Valley (Software Development Job Offers)
- Cannot Connect to, Linksys' Web Based Utility, I need help (Networking Hardware Configuration)
- HELP! build an web-based application on... (Java)
- Difficulties of build an web-based application on Oracle XML DB (Oracle)
- HELP! build an web-based application on... (RSS, Web Services and SOAP)
- social web-based applications ???, pls help (IT Professionals' Lounge)
- Advice required to start WEB based application development (ASP.NET)
Other Threads in the JSP Forum
- Previous Thread: Designing a web project
- Next Thread: ping a host
Views: 679 | Replies: 1
| Thread Tools | Search this Thread |
Tag cloud for JSP
apache array backbutton combobox comma connection csv database development directorystructure dropdownlist dynamicpagetitles eclipse frames glassfish ie8 imagetodatabse imageupload integer internet java javaee javascript jsf jsp jsppagetitles levels mvc2 mvcmodel2 mysql netbeans network parameters passing ping printinserverinsteadofclient project read redirect request.getparameter response seperated servlet servletdopost()readxml sessions software sql ssl state_saving_method stocks sun tomcat tutorial update values video web write






