Hi, i have the following code to call a stored procedure which is stored in mysql.
<cfstoredproc procedure="addOneToOneChildFolder" datasource="portdb"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" value="#url.OneToOneFolder#" null="no"> <cfprocparam type="in" cfsqltype="cf_sql_bigint" value="1" null="no"> <cfprocparam type="out" cfsqltype="cf_sql_boolean" value="@queryResult"> </cfstoredproc> <cfquery name="checkOneToOneFolderAdded" datasource="portdb"> SELECT @queryResult; </cfquery> i have followed the instructions on mysql and the stored procedure works fine if i pass in the out as @queryResult. in mysql when i run SELECT @queryResult; it gives me back a value. however when i run it through coldfusion and do a cfdump of the checkOneToOneFolderAdded query it tells me that it is an empty string. i would appreciate any help you can give me on this, or any other way to reference an out variable, thanks very much thanks very much richard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290358 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4