July 21st, 2003, 12:43 PM
I am trying to run multiple queries in a database that i have with several tabes. I am accessing the database through a servlet. So, I have instantiated a connection object and a statement object to do so. The first query that i run returns the correct information, however, every query that i run after that returns null for each column. I have a runQuery function defined that i am playing around with to run my queries for me. All i send it is a String ( the query string ), the connection object, and some other information that is needed for debugging purposes...I have also tried to send this function a Statement object that was defined in my main()...but that didn't work either. I am so confused!!