0 Replies Latest reply on May 18, 2013 4:43 PM by iccsi

    pass a form parameter to the report stored procedure

    iccsi Level 1

      <CFSET myVar= "1">


      <cfquery name = "mydata" datasource = "myDSN">
          execute MySP
         <cfqueryparam value = "#myVar#" CFSQLTYPE = "cf_sql_integer">
        
        </cfquery>
        
         <cfreport format = "PDF" template= "MyReport.cfr"
          query = "#mydata#">
         </cfreport>

       

      I have above code to generate the report using stored procedure and pass parameter.

      I have to use CFSET to set the value of MyVar.

      I would like to know how I can use user input value in  my text control on the form.

      Your help and information is great appreciated,

       

      Regards,

       

      Iccsi,