[thelist] coldfussion problem

[Stevenson Ngila]

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 stored procedure is
returning the value ok. 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 that returns the value.

Please assist!!!