Friday, March 30, 2001 02:08 PM
Well, as far as the Invalid cursor state exception is concerened, you are not calling rs.next() method after retrieving your ResultSet rs. Be sure to call this method before trying to get any data from it.
Secondly, if you want to get data from more than one table then you can simply join them and get all the data. For example:
Suppose you have a table employee_info (emp_no, emp_name, emp_addr)and employee_status (emp_no, emp_status), then you can join then and retrieve data from both table using something similar to this join
select * from employee_info i, employee_status s where s.emp_no = 102 and i.emp_no = s.emp_no ;
This join will fetch the record for employee 102 from both tables employee_info and employee_status. Hope it will help.
Friday, March 30, 2001 01:40 AM
can you please send me the details of the tables fields and please try to write your question clearly and keep some spaces like HTML TAGS so that I can understand your problem better..
or u send me a mail explaining your problem ..it seems your problem is very minute one...