[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