I am having troouble with stored procedures. I would like to use the currect protocol if possible. My stored procedure:
-------------------------------------------------- CREATE PROCEDURE dbo.Q_CheckItem @Items_id int, @card varchar(20) output AS BEGIN SELECT card FROM Items WHERE Items_id = @Items_id END GO ----------------------------------------------------------- On the page : This returns a blank card field. <cfstoredproc procedure="Q_CheckItem" datasource="#dsn#" password="#password#" username="#username#" returncode="Yes"> <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" dbvarname="@items_id" value="#form.items_id#"> <cfprocparam type="InOut" cfsqltype="CF_SQL_VARCHAR" dbvarname="@card" variable="card"> <cfprocresult name="result"> <cfprocresult name="card"> </cfstoredproc> <cfstoredproc procedure="Q_CheckItem" datasource="#dsn#" password="#password#" username="#username#" returncode="Yes"> <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" dbvarname="@items_id" value="#form.items_id#"> <cfprocparam type="Out" cfsqltype="CF_SQL_VARCHAR" dbvarname="@card" variable="card"> </cfstoredproc> <cfoutput> #card# </cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
