Classic ASP Discussion - bookmarks and absolute postion

Print Page | Close Window

bookmarks and absolute postion

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=3142
Printed Date: 29 March 2026 at 12:01pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: bookmarks and absolute postion

Posted By: snooper
Subject: bookmarks and absolute postion
Date Posted: 30 May 2003 at 8:44am

hey folks

hey there good folks

i am trying to bookmark my position in Access, after doing an insert. i have checked that the recordset supports both bookmarking and absolute postion .

the problem is, when i response.write the bookmark, even when the insert is successful, the bookmark position is always 1.

any ideas why this is happening?

could it be related to my insert string:

strsql = "SELECT * FROM [tblOrgs] WHERE 0 = 1"

and if so, how can i fix this?

below, is the rest of the relevant code:

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

rs.addnew

.....

rs.Update

' if rs.Supports(adbookmark) then
' strMessage = "supports boommarks"
' else
' strMessage = "NO supports boommarks"
' end if

'0x4000 = absolute position

bookmark = rs.absolutePosition
rs.close

set rs = nothing

response.write(bookmark)

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Thanks!