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:

  • Wrong number of arguments or invalid property assignment: 'sql.commandtext'

    • 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:
    4240
  • Date Created
    Wednesday, March 30, 2022
  • This Article Has been Viewed
    398 times
  • Short Desc
    When writing out parameterized queries, you may receive the following "Wrong number of arguments or invalid property assignment."
  • Details
    The following error will happen during runtime when you have an error in your Classic ASP code when writing out your Parameterized Queries.

     
    Microsoft VBScript runtime error '800a01c2'
    Wrong number of arguments or invalid property assignment: 'sql.commandtext'
    /Header.asp, line 161
  • Recreate Issue
    The following code will give the "Wrong number of arguments" error.

    <%

    sqlgetLM.commandtext "SELECT TOP colOne FROM TableOne"

    %>


    In the above line, we are missing an important object.
  • Resolve Issue
    The proper way to write out the above Query Statement without error is.

    <%

    sqlgetLM.commandtext = "SELECT TOP colOne FROM TableOne"

    %>


    Adding the = (equal) sign between the commandtext and Select Statement is the correct way to write out the above command.

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles