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 compilation (0x800A03F2) Expected identifier

    • 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:
    87
  • Date Created
    Friday, December 31, 2010
  • Last Updated
    Friday, December 31, 2010
  • This Article Has been Viewed
    2877 times
  • Short Desc
    When using Parameters Queries alot in your projects, you may do a lot of copy and pasting, and this will sometime cause problems like this.
  • Details
    When using Parameters Queries, you may do a lot of copy and pasting to same time when working with a lot of Queries. Sometimes you might copy out to many characters, and when this happens, you will get the error below.

     
    Microsoft VBScript compilation (0x800A03F2)
    Expected identifier
    /page.asp, line 45, column 10
    sqlRunAds..Parameters.Append sqlRunAds..CreateParameter("@MType", adInteger, adParamInput, , Mys)
    ---------^
  • Recreate Issue
    To recreate this issue:

    <%
    sqlRunAds..Parameters.Append sqlRunAds..CreateParameter("@MType", adInteger, adParamInput, , Mys)
    %>


    Looking at the code above, you can see sqlRunAds..Parameters We have 2 periods instead of 1 period.
  • Resolve Issue
    To correct this error.

    <%
    sqlRunAds.Parameters.Append sqlRunAds..CreateParameter("@MType", adInteger, adParamInput, , Mys)
    %>


    In the above line, we have removed the extra . (period) from the sqlRunAds.Parameters.

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles