Sets the bookmark for pointing to a particular record.
Syntax
object.setBookmark(strBookmark)
Parameters
object
A Recordset script object.
strBookmark
A string name of a bookmark.
Remarks
To get the bookmark, use the getBookmark method.
The getBookmark and setBookmark methods are similar to ADO recordset bookmarks, but can be persisted between pages.
Because the default behavior when binding to data in ASP requires your code to Close and Reopen the recordsets each time the page is served, and because ADO bookmarks are invalid once the recordset is closed, Microsoft® Visual InterdDev™ implements a custom bookmark, that behaves just like an ADO bookmark.
Thus, you can store a bookmark, close the recordset, re-open the recordset and set the bookmark and you will be at the correct record.
Example
The following script stores a bookmark, closes the recordset, re-opens the recordset, and sets the bookmark so that you will be at the correct record.
Sub SampleBookmark()
dim tmpBookMark
myRS.Open()
myRS.moveNext() ' now we are on the second record
tmpBookMark = myRS.getBookMark()
'now close the recordset
myRS.Close()
'typically your bookmark is invalid, but in Visual InterDev it is not
'we will re-open this recordset, but assume this is another page perhaps
myRS.Open()
'let's also assume that several records have been inserted before
'and after the record we bookmarked
myRS.setBookMark(tmpBookMark)
'we are now on the same record we were before (which this time is not necessarily the 2nd record)
End Sub