hi....
I am calling a function using the following JSP code...my function name
is "sp_login". As every function is supposed to return something...my
function returns 1, on completion of the task....I am getting the
following error..
org.apache.jasper.JasperException: postgresql.stat.result
The jsp code is as follows:
Can someone help me????
sql="SELECT sp_login ('INSERT','admin','"+username+"','"+password+"')";
//sql="INSERT INTO USERS (USERTYPE,USERNAME,PASSWORD) VALUES
('admin','"+username+"','"+password+"')";
pStat=conn.prepareStatement(sql);
msg=pStat.executeUpdate();
out.println(msg);
if(msg==1)
{%>
<jsp:forward page="message_user.jsp?done=yes&action=add"/>
<%}
else
{%>
<jsp:forward page="message_user.jsp?done=no&action=add"/>
<%}
}%>
