You can't use rs.next() to navigate between records as rs.next() returns
boolean.
Instead of that you can use
if(rs.next()) **************in place of if (rs != null) )
{....
************no need of rs.next()
}
and continue your loop.
This will definetly solve your problem..
regards,
Chary
----------
From: Phillip Fei[SMTP:[EMAIL PROTECTED]]
Reply To: Phillip Fei
Sent: Wednesday, January 19, 2000 9:42 AM
To: [EMAIL PROTECTED]
Subject: Function sequence error ???
In my JSP page, I got a resultset rs from
a servlet via JDBC-ODBC:
ResultSet rs;
%><P>This is a list of all books: <P><%
rs = dtrans.getBooksSortedByAuthor();
if (rs != null) {
rs.next();
... ...
I know that rs does have 10 records in it.
The JSP page displays this error at rs.next():
Database Problem: java.sql.SQLException: [Microsoft][ODBC Microsoft
Access
Driver]Function sequence error
Does anyone ever see this "Function sequence error" ?
Any hint is appreciated.
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
In my JSP page, I got a resultset rs from
a servlet via JDBC-ODBC:
ResultSet rs;
%><P>This is a list of all books: <P><%
rs = dtrans.getBooksSortedByAuthor();
if (rs != null) {
rs.next();
... ...
I know that rs does have 10 records in it.
The JSP page displays this error at rs.next():
Database Problem: java.sql.SQLException: [Microsoft][ODBC Microsoft
Access
Driver]Function sequence error
Does anyone ever see this "Function sequence error" ?
Any hint is appreciated.
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
