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
