The INSERT statement conflicted with the FOREIGN KEY constraint

[Monique Boea]

Hello All.

I have a stored proc that when I execute it from SQL server mgmt studio, it
works fine. But when I try to execute it in CF, I get the following error:

*Error Executing Database Query. [Macromedia][SQLServer JDBC
Driver][SQLServer]The INSERT statement conflicted with the FOREIGN KEY
constraint*

Here is my code:

<cfstoredproc procedure="spmembersII_savegroups" datasource="#request.dsn#"
returncode="yes">
          <cfprocparam
                type="In"
                cfsqltype="CF_SQL_INTEGER"
                dbvarname="intInstitutionID"
                value="541">
          <cfprocparam
                    type="In"
                    cfsqltype="CF_SQL_INTEGER"
                    dbvarname="intMemberID"
                    value="10008">
          <cfprocparam
            type="In"
            cfsqltype="CF_SQL_VARCHAR"
            dbvarname="strStages"
            value="">
                      <cfprocparam
            type="In"
            cfsqltype="CF_SQL_INTEGER"
            dbvarname="intMemberIDUpdate"
            value="0">
          <cfprocresult name="enrollmentquestions">
        </cfstoredproc>

Any suggestions?


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340096
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm