With the GetRows() method you load your query into a 2 dimensional array. You then close your recordset and your database connection. Now you have your array that you can work with kinda like a recordset.
So lets say I have to make two select queries to two different tables in my database. I can query one table use GetRows to put it into an array close the connection. Then call another query and put it into another array with the GetRows method, close the connections and recordset.
I now have two arrays and each one holds the rows from my query to the tables. I can work with them however I want now without having to worry if I am keeping my connection open to long and so on.
Google GetRows() you will find alot of information on it.
Edit: Sorry back to your question. This page navigation bar that you are using to page through your recordset. You are using two of them on the same page? Do they have the same variable names in them? I am thinking that if one or more of the variables are the same it will cause problems. You should check and if you have to run two recordsets then it maybe a good idea to call them different names like RS1 and RS2 also your sql statement should be different like SQL1 and SQL2. Anyway check to see if you have a variable in both navigation bars with the same name.
Edited by Freon22 - 01 June 2007 at 5:43am
Topic Options
Post Options
Thanks(0)
