hi,
I am badly stuck into this problem.Please look into it and find a solution.
I am using ms-access and
jsp.
my database structure is as given below:
----------------------------------------------------------
m_emp_no|from_date|to_date|approver|status|
___________________________________________
1002 | 22/9/2008 | 23/9/2008|1003 |pending
1004 | 29/9/2008 | 30/9/2008|1003 |pending
2044 | 15/9/2008 | 16/9/2008|3076 |pending
------------------------------------------------------
now this is exactly a leave apply scenario where a page is displayed and the user has to fill in the details to apply leave.then the approver has to approve that leaves so even, he should get the details in his account.
for example here 1003 has to approve leaves for 1002 & 1004.i am able to fetch data from database for the particular approver here is the coding:
------------------------------------------------------------
but the problem is that how do i approve leaves individually because when i use the coding given below i am able to approve only the first row data.
i want to approve leaves for everyone but based on m_emp_no.
update.jsp:
please help me out .
thanks in advance.