Recordset limit

Results 1 to 2 of 2

Thread: Recordset limit

  1. #1
    Join Date
    Dec 1969

    Default Recordset limit

    Does anyone know what the recordset or passed variable character limit might be? I have some pages that work great until it has to return a ton of results - then it just fails because it either takes too long or it didn't pick up all the text passed in a variable... Any hints on where I might be able to find the answer to this Q?

  2. #2
    Join Date
    Dec 1969

    Default Might try this one...<BR><BR>Even if you aren&#039;t using Memo fields (Text fields in SQL Server) you should follow that advice. You should also copy the value from the RS field into a local VBS variable *ONE TIME ONLY* (per value, of course). In other words do *NOT* do things such as:<BR><BR>&#060;%<BR> ...<BR> If InStr( RS("foo"), "zamboni" ) &#062; 1 Then<BR> Response.Write RS("foo")<BR> End If<BR>%&#062;<BR><BR>Instead, do this:<BR><BR>&#060;%<BR> ...<BR> fooValue = RS("foo") &#039; one time only!<BR> If InStr( fooValue, "zamboni" ) &#062; 1 Then<BR> Response.Write fooValue<BR> End If<BR>%&#062;<BR><BR>No guarantees.<BR>

Posting Permissions

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