9 Replies Latest reply: Jul 1, 2011 2:31 PM by flashbuilder_cool RSS

    Error executing CFC. Parameter index out of range (2 > number of parameters, which is 1)

    flashbuilder_cool

      Hi,

       

      My CFC component is defined as:

       

      <cffunction name="updateNote" output="false" access="remote"  returntype="void" >

           <cfargument name="notedetails" required="true" type="string" >

           <cfargument name="notename" required="true" type="string" />

       

       

         

           <cfquery name="qupdateNote" datasource="notes_db">

                 UPDATE

                     notes

                 SET

                     notes.notedetails=<CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#ARGUMENTS.notedetails#">,

                 WHERE

                     notename="<CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR" VALUE="#ARGUMENTS.notename#">"

       

          </cfquery>

      </cffunction>

       

      In Flash builder when I test the operation I get this error:

       

      "There was an error while invoking the operation. Check  your server settings and try invoking the operation again.

      Reason:  Server error Unable to invoke CFC - Error Executing Database Query. Parameter  index out of range (2 > number of parameters, which is 1)."

       

      Im really quessing that this is something small but right now its causing me to pull my hair out of my head!! Argg. Tried a bunch of things but I know thik im stuck.

       

      Help would be very very appreciated.

       

      Thanks