Anthony,
Yes, they are getting passed in the same order as the Stored Procedure in the
database. I have taken the stored procedure and tried it through Query
Analyzer and it inserts the data without any problems. I'll include the Stored
Procedure parameter list so you can see it. I am much better with databases
than I am with Coldfusion. This has been one of those problems bedeviling me
and I can't figure out why, especially since the error message is not telling
me exactly where the problem is because it points to the first line in the
CFStoredProc and yet it hightlights the very last line in the series of
cfprocparams.
Tom
DB Script:
------------------------------------------------------------
-- Create New Version of 'dbo.spInsertEOC' Stored Procedure
------------------------------------------------------------CREATE PROCEDURE
dbo.spInsertEOC
-------------------------------------------------
-- EOCSurvey Table Parameters
-------------------------------------------------
@ClsFltID numeric,
@MissionRat int,
@MissionCom varchar(2000),
@CurrEffRat int,
@CurrEffCom varchar(2000),
@InstrMethRat int,
@InstrMethCom varchar(2000),
@CommissionSource int,
-------------------------------------------------
-- EOCFac Table Parameters
-------------------------------------------------
@Billeting int,
@Gym int,
@DiningHall int,
@AULibrary int,
@OClub int,
@GymComment varchar(1000),
@BilletingComment varchar(1000),
@DiningHallComment varchar(1000),
@AULibraryComment varchar(1000),
@OClubComment varchar(1000),
-------------------------------------------------
-- EOCFC Table Parameters
-------------------------------------------------
@FCOverallRat int,
@FCOverallCom varchar(1000),
@FCCompetence int,
@FCCommunication int,
@FCFacilitator int,
@FCAbilityInclude int,
@FCRealWorld int,
@FCBestCom varchar(1000),
@FCImproveCom varchar(1000),
@FCUsefulFB int,
@FCProfFB int,
@FCLeadImpFB int,
@FCBestFBCom varchar(1000),
@FCImproveFBCom varchar(1000),
@FCGroupFB int,
@FCLessonLrnd int,
@FCInterventionFB int,
@FCRelevanceFB int,
@FCBestFacCom varchar(1000),
@FCImproveFacCom varchar(1000),
-------------------------------------------------
-- EOCSocFac Table Parameters
-------------------------------------------------
@SOCFacRat int,
@SOCFacCom varchar(2000),
@EbookRat int,
@EbookCom varchar(2000),
-------------------------------------------------
-- EOCStrImp Table Parameters
-------------------------------------------------
@Strength1 int,
@Strength2 int,
@Strength3 int,
@Improve1 int,
@Improve2 int,
@Improve3 int,
@OtherComment varchar(2500)
AS
-------------------------------------------------
-- Declare Procedural Variables - Obtain Values
-------------------------------------------------
DECLARE @EOCSurveyID int, -- EOCSurvey Primary Key Value
@STATUS int -- Child Procedure Status
---------------------------------------------------------
SET @STATUS = 0 -- Set Child Procedure Status - (Clear)
SET @EOCSurveyID = 0 -- Intialize Parent Primary Key Value
---------------------------------------------------------
BEGIN
-- BEGIN TRANSACTION -- Start Transactional Processing
-- SELECT @ErrorStatus = 1 -- Check Error Trapping {Before Insert}
----------------------------------------------------
-- Insert Information Into EOCSurvey Table
----------------------------------------------------
Begin
INSERT INTO dbo.EOCSurvey
( ClsFltID, MissionRat, MissionCom, CurrEffRat,
CurrEffCom, InstrMethRat, InstrMethCom, CommissionSource)
-------------------------------------------------------------
VALUES
( @ClsFltID, @MissionRat, @MissionCom, @CurrEffRat,
@CurrEffCom, @InstrMethRat, @InstrMethCom, @CommissionSource)
SELECT @EOCSurveyID=@@Identity -- Obtain Parent Primary Key Value
----------------------------------------------------------------------
-- Process Insert Information Into EOCFac Table via spInsertEOCFacInfo
----------------------------------------------------------------------
-- SET @EOCSurveyID = 0 -- Parent Primary Key Value Test
IF @EOCSurveyID > 0
EXECUTE dbo.spInsertEOCFac
@EOCSurveyID, @Billeting, @Gym,
@DiningHall, @AULibrary, @OClub,
@GymComment, @BilletingComment,
@DiningHallComment,
@AULibraryComment, @OClubComment
-----------------------------------------------------------------------
-- Process Insert Information Into EOCFC Table via spInsertEOCFCInfo
-----------------------------------------------------------------------
-- SET @EOCSurveyID = 0 -- Parent Primary Key Value Test
IF @EOCSurveyID > 0
EXECUTE dbo.spInsertEOCFC
@EOCSurveyID, @FCOverallRat, @FCOverallCom,
@FCCompetence, @FCCommunication, @FCFacilitator,
@FCAbilityInclude, @FCRealWorld, @FCBestCom,
@FCImproveCom, @FCUsefulFB, @FCProfFB,
@FCLeadImpFB, @FCBestFBCom, @FCImproveFBCom,
@FCGroupFB, @FCLessonLrnd,
@FCInterventionFB,
@FCRelevanceFB, @FCBestFacCom, @FCImproveFacCom
-----------------------------------------------------------------------
-- Process Insert Information Into EOCSocFac Table via
spInsertEOCSocFacInfo
-----------------------------------------------------------------------
-- SET @EOCSurveyID = 0 -- Parent Primary Key Value Test
IF @EOCSurveyID > 0
EXECUTE dbo.spInsertEOCSocFac
@EOCSurveyID, @SOCFacRat, @SOCFacCom,
@EbookRat, @EbookCom
-----------------------------------------------------------------------
-- Process Insert Information Into EOCStrImp Table via
spInsertEOCStrImpInfo
-----------------------------------------------------------------------
-- SET @EOCSurveyID = 0 -- Parent Primary Key Value Test
IF @EOCSurveyID > 0
EXECUTE dbo.spInsertEOCStrImp
@EOCSurveyID, @Strength1, @Strength2,
@Strength3, @Improve1, @Improve2,
@Improve3, @OtherComment
END
END
GO
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2371
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
