CF returns the value of the OUT variable as a regular variable, just like you created it with cfset for example.
Try this: <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> <cfoutput>#queryResult #</cfoutput> You'll notice that I removed the "@" from your variable name. You can name the OUT variable whatever you want, regardless of what it's called in the database. Richard White wrote: > 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290368 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
