Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: ocean10000
I can get around this without using moveprevious, but its a lot more work
Here's what I'm doing:
set cn = Server.CreateObject("ADODB.Connection")
cn.Provider = "SQLOLEDB"
cn.ConnectionString = "Data Source=#*$!;User Id=#*$!;Password=#*$!;"
set rs = blah blah
rs.Open "SELECT * FROM [Table] ORDER BY [n] ASC", cn, 3, 3
while not rs.EOF
if not rs.BOF then
n = rs("n")
There's some other code in there to move it forwards again so it's not looping. It gives me an error ADODB.Recordset error '800a0c93' when it reaches MovePrevious