Hi,

 In your bean you have a connect method which is not called. So the 
conenction is not established and without a connection how can you fetch 
records from a database??. So try calling the connect from the starquery 
but this would be a costly operation. So try having a constructor for the 
bean so the the connection settings are initialized before any method is 
called upon that bean.

Regards,
Nouf.

> Hi there ! It has been two weeks, I`ve been working on this issues but 
yet 
n> o accomplishment.!
M> y page.jsp refers to newbean.java.
I>  have succesfully compiled newbean.java and produced a class.
T> he error I get is that , it doesn` seem to give me any results. My 
r> esults are :-

> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
S> ELECT LOT_ID, FLOW_ID, TST_TEMP, MODE_COD, RTST_COD, PART_CNT, 
GOOD_CNT, 
O> PER_NAM, JOB_REV, PROC_ID, START_T, FACIL_ID, TSTR_TYP, NODE_NAM FROM 
LOT 
w> here START_T > TO_DATE('05/30/2002','MM/DD/YYYY') AND TST_TEMP <='' 
order 
b> y START_T 

> Select Lot(s)
|> 
Flow|Temp|Test|Mode|Retest|Total|Good|Bad|Yield|UserID|Program|Mask|Start 
T> ime|Loc|Tester|System 

> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
P> LEASE ASSIST ! I``m enclosing my page.jsp and newbean.java  
 >