Dynamic PageSize property

[Darren Heinrich]

I'm getting an error when trying to set the RecordSet.Pagesize property by
using a variable.

The error is:
----------------------------------------------------------------------------
----------------------
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/tmc/theform_resp.asp, line 122
----------------------------------------------------------------------------
-----------------------

Line 122 is:
----------------------------------------------------------------------------
----------------------
recSet1.PageSize = recNum
----------------------------------------------------------------------------
---------------------
The code that sets the variable recNum is:
----------------------------------------------------------------------------
---------------------
If (Not IsNumeric(Request("resultsPerPage"))) Then
response.Write("All<br>")
recNum = 500
Else
recNum = CInt(Request.Form("resultsPerPage"))
End If


Thanks

Darren

[Bob Barrows]

Darren Heinrich wrote:

> I'm getting an error when trying to set the RecordSet.Pagesize
> property by using a variable.
>
> The error is:
> --------------------------------------------------------------------------

--

> ----------------------
> ADODB.Recordset (0x800A0BB9)
> Arguments are of the wrong type, are out of acceptable range, or are
> in conflict with one another.
> /tmc/theform_resp.asp, line 122
> --------------------------------------------------------------------------

--

> -----------------------
>
> Line 122 is:
> --------------------------------------------------------------------------

--

> ----------------------
> recSet1.PageSize = recNum
> --------------------------------------------------------------------------

--

> ---------------------
> The code that sets the variable recNum is:
> --------------------------------------------------------------------------

--

> ---------------------
> If (Not IsNumeric(Request("resultsPerPage"))) Then
> response.Write("All<br>")
> recNum = 500
> Else
> recNum = CInt(Request.Form("resultsPerPage"))
> End If
>
>
> Thanks
>
> Darren

Do you get the error when setting it to a literal value (.PageSize = 500)?
or only when you set it to the variable? If the latter, then the variable
does not contain what you think it contains. Response.Write it.

HTH.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"