Quick References
ADO
ASP
CSS2
HTML
JavaScript
Jet SQL
VBScript
WML
WMLScript
WSH
XHTML
XML DOM
XSLT
Features
Knowledge Base
Tutorials
Partners
ZVON.ORG
XML
Planet Source Code
VisualBuilder
Web Design
Your HTML Source
XML/XSLT Forums
ASPAlliance
Scripts
Programmers Heaven
Tek-Tips Forums
Developer Fusion
Code Project
PageCount Property
PageSize Property
RecordCount Property
PROPERTY: Recordset::MaxRecords
long =
recordsetobject.
MaxRecords
recordsetobject.
MaxRecords
= long
The
MaxRecords
property sets or returns a long integer that dictates the maximum number of records that a query can return. This can be useful when you do not know how many records might be returned by a query to a very large database. The default is zero which signifies that there is no maximum limit.
This value is passed to the provider and it is the responsibility of the provider to implement this limit. Note, this property has no effect on an Access database.
You can only set this property when the
Recordset
is closed (read/write when closed, read-only when open). Not all providers recognize this property.
In this example, only the first five records are returned even though the query string selects all records in the table:
Code (VBScript):
Set rsChants = Server.CreateObject("ADODB.Recordset")
rsChants.
MaxRecords
= 5
strQuery = "SELECT * FROM GuruChantList"
rsChants.Open strQuery, , , adCmdTable
Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information
