Hi, All:
This is supposed to be a simple, but how do you pass multiple variables
using <cfprocparam> tag inside <cfstoredproc> tag? I used two
<cfprocparam> lines as below and didn't pass the values I wanted:
-----------
<cfstoredproc ...>
<cfprocparam type="in" dbvarname=@myname1 value=#myname2
cfsqltype="cf_sql_integer">
<cfprocparam type="in" dbvarname=@myname3 value='#myname4#'
cfsqltype="cf_sql_char">
<cfprocresult name="my_result_name">
</cfstoredproc>
-----------------
I guess I must have missed something. Any pointer is appreciated.
Nathan Chen
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
