Hi Andrew Try changing
print @RetMsg /**** end transact sql code ****/ to SELECT @RetMsg Alistair Alistair Davidson Application Developer www.smartgroups.com Freeserve.com PLC -----Original Message----- From: Andrew Peterson [mailto:[EMAIL PROTECTED]] Sent: 24 July 2002 15:03 To: CF-Talk Subject: cfProcParam is being ignored? Hi, I've got a Stored Procedure that functions as designed. However, when I call it from a CF template, my cfProcParam, an output variable that I wish to display, seems to be ignored. Here is my CF code: <!--- begin cf code ---> <cfstoredproc datasource="WEDGETEST" procedure="UpdateTraining"> <cfProcParam cfsqltype="CF_SQL_VARCHAR" type=Out variable="ReturnMsg" dbvarname="@RetMsg"> </cfstoredproc> <cfoutput>#ReturnMsg#</cfoutput> <!--- end cf code --> Unfortunately, ReturnMsg is not displayed, thought the code is executed. ReturnMsg is the value of @RetMsg, shown in an excerpt of the StoredProc below: /**** begin transact sql code ****/ ALTER PROCEDURE dbo.UpdateTraining ( @RetVal int = NULL Output, @RetMsg nvarchar(255)= NULL Output) as -- Declare @ReturnMsg nvarchar(255) DELETE FROM SCO510 WHERE AGENCY_NO BETWEEN 701 AND 710 select @RetMsg = 'Deleted From 510 ' + CONVERT(varchar(5), @@RowCount) + ' rows.' UPDATE AGENCY_PKG_RECTYPE SET STATUS = 'Empty' where AGENCY_NO BETWEEN 701 AND 710 select @RetMsg = @RetMsg + 'Updated ' + CONVERT(varchar(5), @@RowCount) + ' rows to Empty in RecType table.' print @RetMsg /**** end transact sql code ****/ In the Stored Proc itself, @RetMsg is displayed using the Print command. Do I have to somehow RETURN the value so that CF sees it? I've looked at the Return command in SQL Server but it does something different entirely. Thanks in advance. Andrew ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists