Thanks Craig I missed using the resultset. I went to school in Surrey many years back. Jack
-----Original Message----- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 6:49 AM To: CF-Talk Subject: RE: Stored Procedures problem Try this.. -------------- CREATE PROCEDURE dbo.Q_CheckItem @Items_id int AS SELECT card FROM Items WHERE Items_id = @Items_id -------------- <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#"> <cfprocresult name="card" resultset="1"> </cfstoredproc> <cfoutput>#card.card#</cfoutput> -------------- -----Original Message----- From: Jack Ince [mailto:[EMAIL PROTECTED] Sent: 06 March 2003 14:36 To: CF-Talk Subject: Stored Procedures problem 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
