Name
BOF (Recordset Object) —
rsObj
.BOF
Synopsis
If the value of the
BOF property of a Recordset object
is True
, the current record pointer is positioned
one record before the first record in the recordset. This is a
read-only property. You can use the BOF property in conjunction with
the EOF property to ensure that your recordset contains records and
that you have not navigated beyond the boundaries of the recordset.
Parameters
-
rsObj
A reference to a Recordset object
Example
The following example demonstrates the use of BOF to determine
whether the opened recordset contains any records. Note that EOF is
also True
if there are no records in the
recordset. We could just as easily have used the EOF property in this
case as BOF.
<%@ LANGUAGE="VBSCRIPT" %> <% Response.Buffer = True %> <HTML> <HEAD> <TITLE>ADO Examples</TITLE> </HEAD> <BODY> <% ' Include ADOVBS.INC so we can use the ADO constants. %> <!-- #include virtual = "/MySSIncludes/adovbs.inc" --> <% ' Instantiate an ADO Connection object. Set objDBConn = Server.CreateObject("ADODB.Connection") ' Construct the connection string for the Connection object. strConn = _ "driver={SQL Server};;uid=sa;pwd=;database=SalesDB" ' Using the connection string, open the connection. objDBConn.Open strConn ' Instantiate an ADO Recordset object. Set rsHighSales = _ Server.CreateObject("ADODB.Recordset") ' Set the ActiveConnection property of the recordset. rsHighSales.ActiveConnection = objDBConn ' Construct the SQL to be used to open the recordset. ...
Get ASP in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.