Welcome to WebmasterWorld Guest from 54.226.246.160

Forum Moderators: ocean10000

Message Too Old, No Replies

rs.MovePrevious just will not work

Doesnt matter what cursortype I assign to the recordset

     

TheDave

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=#*$!;"
cn.Open

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")
rs.MovePrevious
end if
...
rs.MoveNext
wend

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

storevalley

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