Results 1 to 3 of 3

Thread: MaxRecods

  1. #1
    ScottvS Guest

    Default MaxRecods

    I have the following on one page to limit the record set from returning hundreds of values, and it works. Yet, when I use the same query on another page it will return all the records, is there anyway to force a recordset to only retrieve how many records I wish?<BR><BR>objConn.Open <BR>Dim objRS<BR>Set objRS = Server.CreateObject("ADODB.Recordset") <BR>objRS.MaxRecords = 12<BR>...

  2. #2
    Join Date
    Dec 1969

    Default RE: MaxRecods

    In my case I have always defined it in the query string:<BR><BR>SELECT Top 50 * FROM tablename... ORDER BY fieldname

  3. #3
    ScottvS Guest

    Default Thanks!

    Thanks, that works like a charm. =)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts