homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
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

10+ Year Member

Msg#: 3148 posted 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=#*$!;"

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



10+ Year Member

Msg#: 3148 posted 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