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.
  • Breadrumbs:

  • Microsoft VBScript runtime (0x800A01CA) Variable uses an Automation type not supported in VBScript

    • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    90
  • Date Created
    Wednesday, January 5, 2011
  • Last Updated
    Wednesday, January 5, 2011
  • This Article Has been Viewed
    3842 times
  • Short Desc
    If your column is of Data Type BIGINT and your Query is of Type INT, you may experiance this error if you try to match them together.
  • Details
    If you set your Column Data Type to BIGINT and try to Query it against either a form or QueryString value of type INT, you will have to convert it to a CDBL, if not you may experiance this error.

     
    Microsoft VBScript runtime (0x800A01CA)
    Variable uses an Automation type not supported in VBScript
    /Menu.asp, line 29
  • Recreate Issue
    To recreate this issue:

    <%
    OldQuery = Request.QueryString("id")
    %>


    <%
    rs("ID")=OldQuery
    %>
  • Resolve Issue
    To correct this issue.
    If your Column is of Data Type BIGINT, you will need to convert your QueryString or Form value with a CDBL wrapped around your value.

    <%
    NewQuery = cdbl(Request.QueryString("id"))
    %>


    <%
    rs("ID")=NewQuery
    %>


    (Using BIGINT in place of INT in your SQL Server Column will allow you to add in a larger value than what INT gives on its own.

    Taken from Microsoft MSDN«

    bigint

    Integer (whole number) data from -2^63 (-9,223,372,036,854,775,808) through 2^63-1 (9,223,372,036,854,775,807). Storage size is 8 bytes.

    int

    Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). Storage size is 4 bytes. The SQL-92 synonym for int is integer.

    smallint

    Integer data from -2^15 (-32,768) through 2^15 - 1 (32,767). Storage size is 2 bytes.

    tinyint

    Integer data from 0 through 255. Storage size is 1 byte.

    Remarks
    The bigint data type is supported where integer values are supported. However, bigint is intended for special cases where the integer values may exceed the range supported by the int data type. The int data type remains the primary integer data type in SQL Server.

    bigint fits between smallmoney and int in the data type precedence chart.

    Functions will return bigint only if the parameter expression is a bigint data type. SQL Server will not automatically promote other integer data types (tinyint, smallint, and int) to bigint.

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles