X
HOME HTML CSS JAVASCRIPT SQL PHP JQUERY ANGULAR XML ASP.NET MORE...
REFERENCES | EXAMPLES | FORUM | ABOUT

ADO Bookmark Property


Recordset Object Reference Complete Recordset Object Reference

The Bookmark property specifies a bookmark. The bookmark saves the position of the current record.

To save the bookmark for the current record, assign the value of the Bookmark property to a variable. To return to the "bookmarked" record, set the Bookmark property to the value of that variable.

Note: The Bookmark property is available only in Recordset objects that support bookmarks.

Syntax

objRecordset.Bookmark

Example

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("northwind.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Companyname, Contactname FROM Customers"
rs.Open sql, conn

rs.MoveFirst

'Store bookmark of the current record
bkmark=rs.Bookmark

rs.MoveLast

'Go to the bookmarked record
rs.Bookmark=bkmark

rs.Close
conn.Close
%>


Recordset Object Reference Complete Recordset Object Reference

Your suggestion:

Close [X]

Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

WEB HOSTING

UK Reseller Hosting

WEB BUILDING

Download XML Editor FREE Website BUILDER Free HTML5 Templates FREE Website Templates Free HTML Templates

SHARE THIS PAGE

facebook