CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.

Knowledge Base

Breadrumbs:
>>Development (Web and Desktop) >> Web Development >> ASP (Active Server Pages)
Provider error '8002000a' Out of present range.

Share With Friends ^{(Updated 6-8-2010)}

Article ID:
206
Date Created
Sunday, February 2, 2014
Last Updated
Wednesday, February 26, 2014
This Article Has been Viewed
2041 times
Short Desc
In ASP Classic, using Parameterized Queries and the Integer, BigInt, SmallInt, TinyInt, knowing which value to use, will help you from experiencing the Out of present range Error.
Details
When working with Parameterized Queries, and knowing the difference between an Integer, BigInt, SmallInt, TinyInt, makes a huge difference in controlling errors in your code.
For example, This error will accure, if you use adInteger, instead of adBigInt
When your column's Data Type is set to BigInt

Provider error '8002000a'
Out of present range.
/Header.asp, line 147
Recreate Issue
To recreate this issue.

With the Data Type = BigInt
Using the following Parameterized Query, will throw the error.
setActive.Parameters.Append setActive.CreateParameter("@Nums", adInteger, adParamInput, , randomNumber)
As you can see, we are using adInteger.
Resolve Issue
To resolve this issue.

Using BigInt as our Data Type, we need to make sure that we use it in our Parameterized Query, like this.
setActive.Parameters.Append setActive.CreateParameter("@Nums", adBigInt, adParamInput, , randomNumber)

All Topics