I'm using the following code in my ASP page:
myConnString = Application("PIA27_ConnectionString")
Set myConnection = Server.CreateObject("ADODB.Connection")
mySQL2 = "SELECT * FROM PIATable"
Set rs = myConnection.Execute(mySQL)
do until rs.bof
But when I view it in the browser, I get "Rowset does not support fetching backwards." It works fine if I change the code to move forward through the record set.
What do I need to change or add to get this code to work?
Thanks in advance--