Hi Tom Are you passing your procparams in the same order as the database expects? Antony On 8/22/05, Thomas Loyd <[EMAIL PROTECTED]> wrote: > > 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:2369 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=11502.10531.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
