[thelist] coldfussion, stored procedure problem(return values)

Stevenson Ngila Stevenson at epr.footman-walker.com
Fri Jul 26 05:02:00 CDT 2002


I have a coldfussion page that used a stored procedure to do some process
and it's supposed to return a value(either 1 or 0 ). The value is been
returned ok in the SP(SQL database). But on the coldfussion side am getting
the following:
 instead of what the sp is returning
which is 0 or 1.

What could be wrong. the code am using is shown below:

	cfoutput>
		<cfstoredproc procedure="sp_SaveAutologIncident"
datasource="#Application.theDb#" returnCode = "no">
			<cfprocparam dbvarname=@sRawMessage type="in" value="#theText#"
cfsqltype="CF_SQL_VARCHAR">
			<cfprocparam dbvarname=@bUpdateSession type="out"
variable="bUpdateSession" cfsqltype="CF_SQL_BIT">
		</cfstoredproc>

	</cfoutput>

bUpdateSession is the variable the returns the value.

Please assist!!!


Thanks,
Stevenson Ngila
Footman-Walker Associates Ltd
http://www.footman-walker.co.uk





More information about the thelist mailing list