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)

Preferred Member

10+ Year Member

joined:July 2, 2002
votes: 0

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)

Preferred Member

10+ Year Member

joined:Mar 4, 2003
votes: 0

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

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members