From: | Minal <minalac(at)yes2etl(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | postgresql.stat.result |
Date: | 2005-08-03 06:05:27 |
Message-ID: | 42F05EA7.4000102@yes2etl.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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"/>
<%}
}%>
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2005-08-03 06:38:03 | Re: postgresql.stat.result |
Previous Message | Oliver Jowett | 2005-08-03 03:23:21 | Re: Select where id in (LARGE LIST) ? |