ADO Tutorial
ADO HOME ADO Intro ADO Connect ADO Recordset ADO Display ADO Query ADO Sort ADO Add ADO Update ADO Delete ADO Demo ADO Speed UpADO Objects
ADO Command ADO Connection ADO Error ADO Field ADO Parameter ADO Property ADO Record ADO Recordset ADO Stream ADO DataTypesADO Summary
ADO Examples
ADO ExamplesADO Exam
ADO CertificateADO Bookmark Property
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
%>
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
%>
Complete Recordset Object Reference
Your suggestion:
Close [X]
Thank You For Helping Us!
Your message has been sent to W3Schools.
Close [X]
