Hi, I am using PreparedStatement object to insert and retrieve values from the access database. The values are set with setXX method and retrieved using getXXX method. The problem i face is that i am not able to view a record which was inserted into the database using the Statement object.Only recently did i switch to the PrepareStatement. **************************************************** This is the query i used with Satement object. sql="Select * from TimeSheet where Start_Time=#"+startingtime+"# and End_Time=#"+endingtime+"# and Task_Date=#"+res+"# and Employee_ID="+remoteuserid; **************************************************** After using PrepareStatement i changed the query as sql="Select * from SWTimeSheet where Start_Time=? and End_Time=? and Task_Date=? and Employee_ID=?"; where the values of Start_Time and End_Time are time objects and Task_date is a Date object. i tried to retrieve values from the database for a time range and it is displaying only those which were inserted using the PrepareStatement.How can i see the other records? Pls give me a solution Thanks in advance, SJ _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". Some relevant FAQs on JSP/Servlets can be found at: http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.html http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
