Only retrieve 1 row
0 posts in topic
Flat View  Flat View

Posted By:   Ramon_Valdez
Posted On:   Wednesday, October 22, 2008 07:52 PM

Calling a stored procedure in a SQL Server Database, only returns 1 row and when the stored procedure is calling directly in the DB it returns correctly more than one row.

The way it is accesed is as follow:
String query = "exec getResumeCertByProdType @iniDate='" + request.getParameter("iniDate") + "', @finDate='" + request.getParameter("finDate") + "'";
stmt = connection.createStatement();
resultSet = stmt.executeQuery(query);

while (resultSet.next()) { ...

I donĀ“t understand why this is happening. Please if anyone can help me, thanks in advance.

About | Sitemap | Contact