1 Reply Latest reply on Oct 12, 2007 5:28 PM by cf_dev2

    excute Oracle function using data from a CFFORM

    icarus013 Level 1
      For simplicity, I have a function that will add 1 to a number a user will enter from a form. So if the user enters the number 2 and submits the form, the next page will display 3.

      If I enter the following code in SQL Plus, I get 3:

      SELECT MySchema.Add_Function('2') FROM dual;
      3

      This is correct.

      How do i get this to work?
      <cfquery name="funcTest" datasource="Test">
      SELECT MySchema.Add_Function('#FORM.userNumber#') FROM dual;
      </cfquery>

      <body>
      Your new number is <cfoutput>#funcTest.Add_Function('#FORM.userNumber#')#</cfoutput>
      </body>

      I get
      ELEMENT Add_Function('2') is undefined in funcTest.

      Any ideas?
      THANKS