Hi,

I am getting the following error while trying to display soem data in
a jsp:

"An error has occurred in the application.
Error occured while executing SQL with SQL Error Code=0, SQL
State=S1000, Message=After end of result set"

The error occurs only while displaying data for few dates, for the
rest of the dates it works fine.
I being very new to MySQL do not have a clue as to what can be the
error. If somebody can guide me as to what exactly is that error all
about and guide me in the right way I would really appreciate it.

Thanks and Regards,
Sandy

On Thu, 09 Aug 2007 01:32:38 -0700, Sandy80 wrote:
> Hi,
>
> I am getting the following error while trying to display soem data in
> a jsp:
>
> "An error has occurred in the application.
> Error occured while executing SQL with SQL Error Code=0, SQL
> State=S1000, Message=After end of result set"
>
> The error occurs only while displaying data for few dates, for the
> rest of the dates it works fine.
> I being very new to MySQL do not have a clue as to what can be the
> error. If somebody can guide me as to what exactly is that error all
> about and guide me in the right way I would really appreciate it.

This is a Java Problem, not a MySQL Problem. Based on the "Message"
item, it sounds like a result returned 5 rows and you asked for the 6th.

--
6. I will not gloat over my enemies' predicament before killing them.
--Peter Anspach's list of things to do as an Evil Overlord