What is your CF calling this SP?
-----Original Message----- From: Tom Loyd [mailto:[EMAIL PROTECTED] Sent: 22 August 2005 14:29 To: SQL Subject: Re: CFProcParam issue 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:2372 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
