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:

  • ADODB.Command error '800a0d5d' Application uses a value of the wrong type for the current operation

    • 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:
    11
  • Date Created
    Tuesday, September 28, 2010
  • Last Updated
    Wednesday, November 17, 2010
  • This Article Has been Viewed
    11975 times
  • Short Desc
    When you are trying to query your table, your QueryString may not be properly defined. (or) if you are sending to many characters to your Parameter with a set Character Length.
  • Details
    If your QueryString is not properly defined or misspelled, you will receive this error

     
    ADODB.Command error '800a0d5d'
    Application uses a value of the wrong type for the current operation.
    rss.asp, line 8


    (or) Scenaria #2:
    If you are trying to send to many characters to your Parameterized Query.

     
    ADODB.Command (0x800A0D5D)
    Application uses a value of the wrong type for the current operation.
    Inserts.asp, line 290
  • Recreate Issue
    In the below SQL Query, we are getting our ID from the QueryString of rss.


    <%
    rss = ProtectSQL(request.QueryString("rss"))
    Set sqlRSS = Server.CreateObject("ADODB.Command")
    sqlRSS.ActiveConnection=objConn
    sqlRSS.Prepared = true
    sqlRSS.commandtext="Select id, RSSFeed FROM MyTable WHERE id=? AND RSSFeed=1"
    sqlRSS.Parameters.Append sqlRSS.CreateParameter("@id", adInteger, adParamInput, , rss)
    set rsRSS = sqlRSS.execute
    %>



    We instead Query our string as:
    page.asp?rsss=1

    Scenaria #2:

    <%

    Set sqlFFiltnd = CreateObject("ADODB.Command")
    sqlFFiltnd.ActiveConnection=objConn
    sqlFFiltnd.commandtext="update DTable set DFolder='NotDefault' where id=? and PicsFolder=?"
    sqlFFiltnd.Parameters.Append sqlFFiltnd.CreateParameter("@id", 3, 1, , MineID)
    sqlFFiltnd.Parameters.Append sqlFFiltnd.CreateParameter("@PFolder", 200, 1, 25, strFolderName)
    sqlFFiltnd.execute

    %>


    In the above code, are 5th line which is our PFolder, has a character count of 25.
    This will cause this error if you have over 25 characters to go into the field.
  • Resolve Issue
    To correctly call our Query, we need to make sure that our QueryString matches our Variable that we define within our code.

    page.asp?rss=1
    Will get our records and display them back to us properly.


    <%
    rss = ProtectSQL(request.QueryString("rss"))
    Set sqlRSS = Server.CreateObject("ADODB.Command")
    sqlRSS.ActiveConnection=objConn
    sqlRSS.Prepared = true
    sqlRSS.commandtext="Select id, RSSFeed FROM MyTable WHERE id=? AND RSSFeed=1"
    sqlRSS.Parameters.Append sqlRSS.CreateParameter("@id", adInteger, adParamInput, , rss)
    set rsRSS = sqlRSS.execute
    %>



    Scenaria #2:

    <%

    Set sqlFFiltnd = CreateObject("ADODB.Command")
    sqlFFiltnd.ActiveConnection=objConn
    sqlFFiltnd.commandtext="update DTable set DFolder='NotDefault' where id=? and PicsFolder=?"
    sqlFFiltnd.Parameters.Append sqlFFiltnd.CreateParameter("@id", 3, 1, , MineID)
    sqlFFiltnd.Parameters.Append sqlFFiltnd.CreateParameter("@PFolder", 200, 1, 75, strFolderName)
    sqlFFiltnd.execute

    %>


    On line #5, we have changed the Character count from 25 allowed Characters to 75
    This gives us more room to allow for special characters, especially if you are using a function to converts characters over to hex or so forth.

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles