Hi , Everyone
I am new at cfstoredproc tag. Here is the problem i called the Out
Parameter from cfstoredproc
it kept returning the wrong value. Under Query Analyzer the Out parameter
is right.
Can anyone Tell me what is wrong with these code.
Thanks,
Ben
Store Procedure Syntax:
CREATE PROCEDURE [TestingResults] @OutParam int Output AS
declare @RCounter int
SELECT @RCounter = Count(Table_Name)
FROM information_schema.tables
WHERE table_name = 'Results'
IF (@RCounter = 1)
Select @OutParam = 3
Else
Select @OutParam = 0
GO
----------------
Cold Fusion Syntax:
<cfstoredproc procedure="TestingResults"
datasource="Newmovie" returncode="Yes" debug="Yes">
<cfprocresult name="Results">
<cfprocparam cfsqltype="CF_SQL_INTEGER" type="Out" variable="OutParam" >
</cfstoredproc>
<cfoutput>
Out Parameter : = > #OutParam#<br>
</cfoutput>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
