no1biscuit
Programmer
Below is my ugly (just trying to get anything to work so ignore the ugliness of the code. But if I have format="html" it displays data from the stored procedure and the two text boxes. If I set format="flash" then it only displays the two text boxes and not the stored procedure data.
What am I doing wrong?
Thanks
Thom
<cfstoredproc procedure="VolumeActivity" datasource="System" >
<CFPROCPARAM TYPE="IN" CFSQLTYPE = CF_SQL_DATE VAlue = '10/25/2006'>
<CFPROCPARAM TYPE="IN" CFSQLTYPE = CF_SQL_DATE VAlue = '10/26/2006'>
<cfprocresult name = "qryresult"></cfstoredproc>
<cfform name="frmreport" format="html" skin="halogreen" action="_self" wmode="opaque" width="200" height="200">
<cfinput type="text" name="bar"/>
<cfloop query="qryresult">
<cfoutput>
# qryresult.Call_Type#
</cfoutput>
</cfloop>
<cfinput type="text" name="bar2"/>
</cfform>
What am I doing wrong?
Thanks
Thom
<cfstoredproc procedure="VolumeActivity" datasource="System" >
<CFPROCPARAM TYPE="IN" CFSQLTYPE = CF_SQL_DATE VAlue = '10/25/2006'>
<CFPROCPARAM TYPE="IN" CFSQLTYPE = CF_SQL_DATE VAlue = '10/26/2006'>
<cfprocresult name = "qryresult"></cfstoredproc>
<cfform name="frmreport" format="html" skin="halogreen" action="_self" wmode="opaque" width="200" height="200">
<cfinput type="text" name="bar"/>
<cfloop query="qryresult">
<cfoutput>
# qryresult.Call_Type#
</cfoutput>
</cfloop>
<cfinput type="text" name="bar2"/>
</cfform>