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 error '800a01a8' Object required: 'cmd'

  • 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:
    133
  • Date Created
    Tuesday, May 10, 2011
  • Last Updated
    Tuesday, May 10, 2011
  • This Article Has been Viewed
    2283 times
  • Short Desc
    When you write your SQL Statement using Parameters, you may sometimes misplace a character inplace another another character.
  • Details
    When you write your SQL Statement with Patameters, you may sometimes add in a characters inplace of another character. This usually happens when the coder is in a rush, and then this does accure, you will receive the following error.


     
    Microsoft VBScript runtime error '800a01a8'
    Object required: 'cmd'
    /header.asp, line 340
  • Recreate Issue
    To recreate this issue.

    <%
    cmd=commandtext-"Select column from table"
    %>

    In the above, you can see where we have an = between the cmd and commandtext
  • Resolve Issue
    To resolve this issue.

    <%
    cmd.commandtext-"Select column from table"
    %>

    In the above, you can see we have the period placed between, and there for, our code will compile.