<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,
Retrieving data ...