cfprocparam type error

[idanner]

I have this procedure I'm calling from ColdFusion. I list the parameters which are TitleId,OfficeId and Barcode which are in that order in the procedure as well. All the datatypes set in the procedures match the sql types in the parameter tags. I keep getting an error though, saying :

[Macromedia][SQLServer JDBC Driver][SQLServer]Formal parameter '@TitleID' was defined as OUTPUT but the actual parameter not declared OUTPUT.

This is the code for calling the procedure. Can anyone help me?

[<cfif ISDEFINED("FORM.Addbook")> <!---If the user is adding a book--->
<cfstoredproc procedure="spAddBook" datasource="NCLibrary">
<cfprocparam cfsqltype="cf_sql_numeric" value="#TitleId#" type="in" variable="TitleId">
<cfprocparam cfsqltype="cf_sql_int" value="#FORM.OfficeId#" type="in" variable="OfficeId">
<cfprocparam cfsqltype="cf_sql_numeric" value="#FORM.Barcode#" type="in" variable="Barcode">
</cfstoredproc>
</cfif> ]

None of my parameters a declared or coming back as output in the procedure.

 

[idanner]

Never mind everyone. I solved the problem.

 

[webmigit]

What was the problem? What was the solution? Its always best to share the answer even if its the answer to your own question.

That way if someone comes to the site with the same problem, they might find the answer right away rather than having to wait on an answer.

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.