<CFPROCPARAM> Tag - ColdFusion

  <CFPROCPARAM> Comments from Macromedia LiveDocs

LiveDocs Comments - coldfusion - 5.0 - CFML_Reference - Tags76.htm
Do you have any answer for passing sturcture or array to a stored procedure. You can return a ref_cursor at the same time can you pass in a CF Query Object as one of the input variables to stored procedure using REF_CURSOR

LiveDocs Comments - coldfusion - 5.0 - CFML_Reference - Tags76.htm
hi. can you tell me if I can use the CF_SQL_REFCURSOR parameter as a 'IN' parameter to an Oracle database in order to pass e.g. a structure or an array? Thank you.

LiveDocs Comments - coldfusion - 5.0 - CFML_Reference - Tags76.htm
A comment to the CFMX documentation for cfprocparam notes that, when using MS SQL Server, if a parameter to your stored procedure has type DATETIME you must use cfsqltype="cf_sql_timestamp" and not "cf_sql_date" or "cf_sql_time". This statement is also correct for CF 5 for Windows and SQL Server 2000sp3.

LiveDocs Comments - coldfusion - 5.0 - CFML_Reference - Tags76.htm
Passing of named parameters with cfprocparam DOES NOT WORK. You MUST pass ALL parameters to the stored procedure in the SAME ORDER as they are expected.

Instead you can test your parameters and pass explicit NULL values for any that are missing. Unfortunately this adds some CF code, but at least this way your stored procedure will behave as expected.

(See http://livedocs.macromedia.com/cfmxdocs/Migrating_ColdFusion_5_Applications/cf_migration_guide6.jsp#1203166 and http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=6&threadid=259491&highlight_key=y&keyword1=cfprocparam for more details.)


LiveDocs Comments - coldfusion - 5.0 - CFML_Reference - Tags76.htm
Can someone post sample code of passing named parameters into stored procedures using dbVarName? I have params that are optional, but <procparam> is ignoring my dbVarName, whether I pass it as dbVarName="myVar" or dbVarName="@myVar", and instead assumes I am passing in the parameters in the same order as they are declared in the sproc.

Help?

Recommended Books COLDFUSION MX Web Application Construction Kit (5th Edition) Authors:   Ben Forta and Nate Weiss 1500 pages [Top] Web Sites Macromedia The makers of ColdFusion/ColdFusion MX. ColdFusion Developer's Journal Forta.com (ColdFusion Section) Ben Forta is Macromedia's Senior Technical Evangelist. Here on his site find useful ColdFusion information. Flash CFM Flash and ColdFusion Development. Handling file uploads without CFFILE BLOG post by "Sam" on REWINDLIFE.COM gives insight into how to upload a file on your site if you are not allowed to use the CFFILE tag. [Top]