Welcome to WebmasterWorld Guest from

Forum Moderators: ocean10000

Message Too Old, No Replies

rs.MovePrevious just will not work

Doesnt matter what cursortype I assign to the recordset



12:12 am on Dec 6, 2005 (gmt 0)

10+ Year Member

All I want is for my MovePrevious to work. It doesn't work under any circumstances, no matter what CursorType i assign. It's driving me crazy! I'm not sure whether this microsoft support article [support.microsoft.com] is relevant?

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")
end if

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


4:33 pm on Dec 8, 2005 (gmt 0)

10+ Year Member

There are a few potential solutions here [aspfaq.com] :)

Featured Threads

Hot Threads This Week

Hot Threads This Month