[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:

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


bUpdateSession is the variable the returns the value.

Please assist!!!

Stevenson Ngila
Footman-Walker Associates Ltd

More information about the thelist mailing list