I see
<%! String query = request.getParameter("display") ; %>
is declared in the init() of the servlet.I changed it but now I`m getting
org.apache.jasper.JasperException
java.lang.NullPointerException which should not execute the query
Can anyone throw licht on this
Thanks
marju jalloh <[EMAIL PROTECTED]> wrote: Hi everyone
I `m writing a bean application to execute sql query.The query properties in
the Bean works perfect.I have a jsp with textArea where the user can enter
query.The query is the required parameter that the Bean should execute.
snippet
...
[input]
<%! String query = request.getParameter("display") ; %>
<%
if(!query.equals("") || !query.equals(null))
{
String selector = (query.substring(0,6)).trim();
out.write(selector);
if(selector.equals("SELECT")){
out.write(myBean.getData());
}else
if(selector.equals("INSERT")){
myBean.setData(query) ;
}else
if(selector.equals("DELETE")){
myBean.setDelete(query);
}
else
out.write("nothing is entered");
}
%>
...
My problem is when the jsp page is requested for the first time
I got this error:
cannot find symbol variable request.
I know I should have null for request.getParameter("display") at first access
and that is caugt.If I submit the form then the content of the textarea should
be
request.getParameter("display") .That was what I was expecting.
Can anyone help
Thanks in advance
---------------------------------
Yahoo! Photos
Got holiday prints? See all the ways to get quality prints in your hands ASAP.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
