I have scoured the net for an answer to the following error message: Invalid data SESSION.soseoc.ClsFltID for CFSQLTYPE CF_SQL_NUMERIC.
I can't seem to find anything really on it. I am using a Stored Procedure that sends that data out to various different child stored procedures. I have tried it in MS Query Analyzer to make sure that it works and I have no problem inputing any data. If you can catch something that I can't please tell me. The error keeps referencing the above line as the error, however, the data is an integer. I have looked and I can't find anything that is causing problems, even with the <cfdump> looking at all the variables in there. I'll put up the CFC from which captures the data and sends it to the Stored Procedure on my database: <cfcomponent hint="EOC Insert" displayname="EOCInsert"> <cfstoredproc datasource="soceval" procedure="EOCInsert" returncode="yes" debug="yes"> <!--- EOCSurvey Table Variables ---> <cfprocparam type="in" cfsqltype="cf_sql_numeric" dbvarname="ClsFltID" value="SESSION.soseoc.ClsFltID"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="MissionRat" value="SESSION.soseoc.MissionRat"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" maxlength="2000" dbvarname="MissionCom" value="SESSION.soseoc.MissionCom"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="CurrEffRat" value="SESSION.soseoc.CurrEffRat"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" maxlength="2000" dbvarname="CurrEffCom" value="SESSION.soseoc.CurrEffCom"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="InstrMethRat" value="SESSION.soseoc.InstrMethRat"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" maxlength="2000" dbvarname="InstrMethCom" value="SESSION.soseoc.InstrMethCom"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="CommissionSource" value="SESSION.soseoc.CommissionSource"> <!--- EOCFac Table Variables ---> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="Billeting" value="SESSION.soseoc.Billeting"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="Gym" value=" SESSION.soseoc.Gym"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="DiningHall" value="SESSION.soseoc.DiningHall"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="AULibrary" value="SESSION.soseoc.AULibrary"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="OClub" value=" SESSION.soseoc.OClub"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" maxlength="1000" dbvarname="GymComment" value="SESSION.soseoc.GymComment"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" maxlength="1000" dbvarname="BilletingComment" value="SESSION.soseoc.BilletingComment"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" maxlength="1000" dbvarname="DiningHallComment" value="SESSION.soseoc.DiningHallComment"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" maxlength="1000" dbvarname="AULibraryComment" value="SESSION.soseoc.AULibraryComment"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" maxlength="1000" dbvarname="OClubComment" value="SESSION.soseoc.OClubComment"> <!--- EOCFC Table Variables ---> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="FCOverallRat" value="SESSION.soseoc.FCOverallRat"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" maxlength="1000" dbvarname="FCOverallCom" value="SESSION.soseoc.FCOverallCom"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="FCCompetence" value="SESSION.soseoc.FCCompetence"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="FCCommunication" value="soseoc.FCCommunication"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="FCFacilitator" value="SESSION.soseoc.FCFacilitator"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="FCAbilityInclude" value="SESSION.soseoc.FCAbilityInclude"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="FCRealWorld" value="SESSION.soseoc.FCRealWorld"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" maxlength="1000" dbvarname="FCBestCom" value="SESSION.soseoc.FCBestCom"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" maxlength="1000" dbvarname="FCImproveCom" value="SESSION.soseoc.FCImproveCom"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="FCUsefulFB" value="SESSION.soseoc.FCUsefulFB"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="FCProfFB" value="SESSION.soseoc.FCProfFB"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="FCLeadImpFB" value="SESSION.soseoc.FCLeadImpFB"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" maxlength="1000" dbvarname="FCBestFBCom" value="SESSION.soseoc.FCBestFBCom"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" maxlength="1000" dbvarname="FCImproveFBCom" value="SESSION.soseoc.FCImproveFBCom"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="FCGroupFB" value="SESSION.soseoc.FCGroupFB"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="FCLessonLrnd" value="SESSION.soseoc.FCLessonLrnd"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="FCInterventionFB" value="SESSION.soseoc.FCInterventionFB"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="FCRelevanceFB" value="SESSION.soseoc.FCRelevanceFB"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" maxlength="1000" dbvarname="FCBestFacCom" value="SESSION.soseoc.FCBestFacCom"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" maxlength="1000" dbvarname="FCImproveFacCom" value="SESSION.soseoc.FCImproveFacCom"> <!--- EOCSOCFac Table Variables ---> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="SOCFacRat" value="SESSION.soseoc.SOCFacRat"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" maxlength="2000" dbvarname="SOCFacCom" value="SESSION.soseoc.SOCFacCom"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="EbookRat" value="SESSION.soseoc.EbookRat"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" maxlength="2000" dbvarname="EbookCom" value="SESSION.soseoc.EbookCom"> <!--- EOCStrImp Table Variables ---> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="Strength1" value="SESSION.soseoc.Strength1"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="Strength2" value="SESSION.soseoc.Strength2"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="Strength3" value="SESSION.soseoc.Strength3"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="Improve1" value="SESSION.soseoc.Improve1"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="Improve2" value="SESSION.soseoc.Improve2"> <cfprocparam type="in" cfsqltype="cf_sql_integer" dbvarname="Improve3" value="SESSION.soseoc.Improve3"> <cfprocparam type="in" cfsqltype="cf_sql_varchar" maxlength="2500" dbvarname="OtherComment" value="SESSION.soseoc.OtherComment"> </cfstoredproc> </cfcomponent> Thanks, Tom ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:2368 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
