homepage Welcome to WebmasterWorld Guest from 54.211.219.178
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
Forum Library, Charter, Moderators: ocean10000

Microsoft IIS Web Server and ASP.NET Forum

    
rs.MovePrevious just will not work
Doesnt matter what cursortype I assign to the recordset
TheDave




msg:942066
 12:12 am on Dec 6, 2005 (gmt 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=#*$!;"
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




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

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

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved