> 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.
You can reference the OUT parameter directly: http://livedocs.adobe.com/coldfusion/7/htmldocs/00000313.htm You will need to add a VARIABLE attribute to your CFPROCPARAM TYPE="OUT", and remove the VALUE attribute, which is only useful with IN/INOUT parameters.. You won't need a separate query. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:290377 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
