Thank You for the reply...
As shown before, my code is below...
What are you saying I need to do here?
I am still new to Stored Procedures and the use of them.
Larry
<cftransaction>
<cfstoredproc procedure="sp_schol_ins"
datasource="profilesandgo">
<cfprocparam type="In" cfsqltype="CF_SQL_INTEGER"
dbVarName="Student_UID" value="#Form.Student_UID#" null="No">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR"
dbVarName="TableName" value="#FORM.Sport#" null="No">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR"
dbVarName="Name" value="#FORM.Sport#" null="No">
<cfprocresult name="InsertSchol" resultset="1">
</cfstoredproc>
</cftransaction>
>Hi Larry,
>
>When using <cfstoredproc />, you need a <cfprocparam /> to specify _ALL_
>parameters passed to and from the Stored procedure!!
>
>So need to check your CF code where you are calling the Stored Proc.
>
>Later,
>Niall.
>
>
>I keep getting an error that appears to be in my <cfprocresult as
>follows.....
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312664
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
