rsGetRecordset (server-side)
Use this routine to retrieve an ActiveX Data Object (ADO) recordset based on a specified connection string, query, and cursor and lock types.
Definition
rsGetRecordset(sConnectionString,
sQuery,
nCursorType,
nLockType)
Parameters
sConnectionString
A string containing an ADO connection string describing the database with which to connect. This is usually a property retrieved from a resource in the Site Configuration Store using the GetSiteConfigField routine in the file ASPUtil.asp.
sQuery
A string containing a valid SQL query.
nCursorType
A number containing a valid value representing an ADO cursor type.
nLockType
A number containing a valid value representing an ADO lock type.
Return Value
An ADO Recordset object containing the results of the query.
Remarks
The following constants for ADO parameter values are defined in the file DBUtil.asp:
Cursor Types
AD_OPEN_FORWARD_ONLY
AD_OPEN_KEYSET
AD_OPEN_DYNAMIC
AD_OPEN_STATIC
Lock Types
AD_LOCK_READ_ONLY
AD_LOCK_PESSIMISTIC
AD_LOCK_OPTIMISTIC
AD_LOCK_BATCH_OPTIMISTIC
This routine is available in the include file DBUtil.asp.