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)




      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">




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


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





      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.