Help on Result sets

[Jenn]

Hi all,

        I am having trouble trying to get the code below to work because it seems
that the ResultSet rs gets corrupted whenever I run the statement to
execute the SQL! The first insertion into the Temp table is executed, but
after which the ResultSet becomes corrupted, the rs.next() becomes an
invalid cursor state.

                try {
                        rs=stmt.executeQuery("SELECT * FROM Temp where 
CID='"+cid+"';");
                        while (rs.next()){
                                stmt.executeUpdate("INSERT INTO OrderItem
VALUES("+rs.getString(2)+","+oid+",'"+rs.getString(3)+"','"+rs.getString(4)+
"');");
                        }
                }
                catch (Exception e){error=""+e;}


Please help on how to solve this problem

Thanks in advance :)
Jenn

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html