There is a searching facility iam trying to implement in my jsp application. It has 2 fields that is the firstname and lastname and on that basis a page will be displayed containing the matching names and on clicking on the particular name one can see the home page of the person. can anyone give me some idea about the same..
hey!! same names .. good coincidence.. iam trying to display names in my page.. like if the user enters anoo in the name field ..then all the names whihc have 'anoo' in the beginning or in the middle or end will be displayed. in my sql i write query as select * from table where fname like '%anoo%' and iam able to get the results but in my jsp page iam not able to i have written the query like rs = stmt.executeQuery("select fname,lname from login where fname like %'"+fname+"'% or lname like %'"+lname+"'%"); iam getting a null pointer exception in this.. can u help me out in this.. and have a great life ahead!!
in the sql query analyzer the records are displayed . but when i write the same query in my jsp page..iam not getting any records in my next page. and the tomcat window gives a null pointer exception.. where does the error lie?? iam tired of debugging!