Thanks for the reply deepalihanand,
I am very thankful to you that you have solved my query.I wont ever forget your help.
Thanks once again.
Bye take care.

when i am using the code to convert string to sql.Date
DateFormat df = new SimpleDateFormat("dd/MM/yyyy");
Date d = df.parse(leavefrom);
String dfrom=df.format(d);

java.sql.Date dd = new...

hi,
Thanks for the reply.
I do understand that SimpleDateFormat.parse(String source) returns java.util.Date

and PreparedStatement.setDate(int i, Date d) takes java.sql.Date .
but i am using...

hi,
Thanks for your reply.
the code which i have written is given above in the previous post
i.e ps.setString(1,leavefrom[counter]);
ps.setString(2,until[counter]);
leavefrom and until are...

hello everyone,
I am stuck with this problem.If anyone could help me, it would be a great favour.
I am working on a leave application.
Here the leaves are been applied by employees and...

hi peter & stephen,
I have solved my query using iteration.

hi stephens,
you are mistaken .the query is not yet solved and i dont know who has marked it as solved.
the very recent coding which i pasted was the coding which i tried it out so that i could get...

Added.......
retrieving values using the code on another jsp page.
thanks

hi stephens,
what i have done now is that i have just modified my code .i have used a counter so that i get specific names for the values.
and i am retrieving it using
Enumeration parameterNames...

I was just trying with this code in a jsp because this text box is only to display
<input type="text" name="userid" value="<%=id%> " size="4"> instead of<input type="text" name="id" value="<%=id%>"...

I am facing problem while retrieving values from the jsp page.
my database structure is as follows:
-----------------------------------------------------------------------...

hi stephens and peter,
Actually the same code which both of you provided was very much correct but i was doing mistake from my side. i was confused with the display part into the jsp page because ...

hi,
I have found the solution and i have rectified the mistake that i was making.I cant even believe that it was such a small mistake.But anyways thanks to you all.
bye

ok stephens ,
I will do as you say, no matter it takes whatever time.Actually the moment you posted me the link i am going through that only but unfortunately i cant show you .I will go through that...

hi stephens,
i promise you that i would go through the jdbc tutorial entirely and get all the concepts clear but right now i have to get this done as soon as possible.if you could just tell me how...

Actually i am a bit confused with the problem i am facing so bcz of that it might have happened that i was not able to put the question clearly or properly in front of you'll ,so for that i am...

hi peter,
thanks for the reply
but through this i cant get the value individually for pl,sl,cl.
see the problem is that i have to display the total balance of leave which is remaining after the...

Hello peter,
I have already gone through this and my half the project is almost done,but i am stuck into this problem, so for that reason i needed help .
I hope my post is clear and...

Hi everyone,
I want to retrieve data from database in jsp page based on the particular m_emp_no .I am finding it very difficult so please can you all help me out with the problem.
Here is the...

Is there no one to help me out of this.I was expecting some help from you people.Anyways i am still waiting for the solution .if any one could help me out, it would be a great favour.
thanks

hello,
I just noticed a problem in my code.
hope you'll would help me.
normally we have a login page where the userid and password is validated from database .now the problem what i am facing is
...

thanks peter,
I tried it and it is successfully giving me the results which i need.I dont know how to thank you.You did a wonderful job.
thanks once again.
As i said i have a query with reset...

hi peter,
yes this is what i wanted to achieve.but could you help me out with the validation servlet bcz as i said there are two different pages for user and approver.so according to the flow if he...

hi peter,
i have created sessions and as you said that the previously created sessions has to be destroyed,if i do that then how can i go back to my main page i.e the page after login which is the...

thanks peter,
that is fine.now going ahead i have set the approver a different page and the user a different page,but when i have to apply for leave, which both user and approver has to do. they...

thanks for the reply,
i will try out this code and let you know about it. i do have one more query, if the current query is solved than should i write in this same post or another.

hi peter,
SELECT count(*) FROM employee_details WHERE emp_approver="approver" AND uid=LOGIN_EMP_ID;
As you have given me the sql statement to differentiate between users i wanted to know that what ...

thanks peter,
As you said if i use the simple word which is like
emp_id password emp_approver
1003 welcome approver
1004 ...

sorry i have not placed the table properly it is like this

emp_id password approver
1003 welcome blank
1004 welcome ...

hi peter,
I have introduced an extra column in my master table such as

emp id password approver
1003 welcome
1004 " " 1003
1005 " " ...

thanks for the reply.
But can it be done through database using his user id.And if yes then how to do it.

Hi everyone,
I am facing a problem in my project .I am sure you'll will find a way out.I am working on a project leave management .now i am really confused as to how to go ahead.I am working with...

hi everyone,
I am facing a problem which i know that you'll will surely find a remedy.
I have a login.html ,login1.jsp which does the database connection and welcome.jsp the main page.
so the...

hi,
That was just a mistake from my side . Till now i have downloaded tomcat 6.0 and continuing to download mysql community server and JDK5.0 as well.so till now working fine.see u back after the...

hi,
I am installing mysql server and over there it has several options for windows i.e
2.4.8.1. Choosing An Installation Package
2.4.8.2. Installing MySQL with the Automated Installer
2.4.8.3....

hi,
I have to install it .let me upgrade with the latest version as suggested then we can go ahead with the queries.I have never installed mysql because i had seen that there is mysql server,mysql...

Thanks for the suggestion.
The getter and setter methods is very much clear to me now.But i am facing a problem in placing the files such as jsp,class files in particular folders as well as...

Thanks for the suggestion.
I am trying doing this in servlet and hope it works well.But i just want to make the concept clear before i proceed further, that in servlet we have set the attribute as...

Thanks a lot for the suggestion given and it is highly appreciated.
As you said that the unique ID has to be made, but please suggest me that when i make a bean after validation done in servlet i...

thank you for your help,
I still have a query
If i use the servlet and i compile it ,then i would get the db connectivity as well as the data validation done but i have a jsp page also in which...