I have discovered that the Stored Procedure has to be set up in the exact order that the table is defined....
As soon as I modified my Stored Procedure to have the exact insert order that my table had, then everything went into the table perfectly. Thanks for the assistance -- Larry Juncker ALJ Computer Services, LLC 10 No 11th Street Fort Dodge, IA 50501-4010 (515) 576-8510 President & CEO >LJJ> I've had problems in the past passing "" to numeric fields. >LJJ> >LJJ> EX: >LJJ> cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" dbVarName="FIELD_GOAL" >LJJ> value="" null="YES" >LJJ> >LJJ> try putting a value in as a test to see if this is where your error is. >LJJ> >LJJ> EX: >LJJ> cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" dbVarName="FIELD_GOAL" >LJJ> value="0" null="YES" >LJJ> >LJJ> -- Sam >LJJ> >LJJ> >LJJ> On Fri, Sep 26, 2008 at 2:29 PM, Larry Juncker <[EMAIL PROTECTED]> wrote: >LJJ> >LJJ>> Anybody???????? >LJJ>> >LJJ>> This is something that I really need help on... >LJJ>> >LJJ>> >LJJ>> Thanks Again in advance >LJJ>> >LJJ>> -----Original Message----- >LJJ>> From: Larry Juncker [mailto:[EMAIL PROTECTED] >LJJ>> Sent: Friday, September 26, 2008 2:50 PM >LJJ>> To: cf-talk >LJJ>> Subject: Error converting data type varchar to numeric >LJJ>> >LJJ>> Can anyone help me with this? >LJJ>> >LJJ>> I have no VARCHAR values going into any numeric fields.....The error >LJJ>> seems >LJJ>> to be coming form my cfprocresult tag >LJJ>> >LJJ>> All values in the table can be null except the automatic column which is >LJJ>> not >LJJ>> even mentioned in this SP >LJJ>> >LJJ>> Any help would be gretly appreciated. >LJJ>> >LJJ>> Thanks in advance >LJJ>> >LJJ>> Larry >LJJ>> >LJJ>> PS: I only outputed my cfproc statements to show what is being submitted >LJJ>> to >LJJ>> the SP >LJJ>> >LJJ>> cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" dbVarName="Student_UID" >LJJ>> value="2" null="No" >LJJ>> cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" dbVarName="Coach_UID" >LJJ>> value="0" null="No" >LJJ>> cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbVarName="GRADE" >LJJ>> value="SR" null="NO" >LJJ>> cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" >LJJ>> dbVarName="PRIMARY_POSITION" value="Forward 3" null="NO" >LJJ>> cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" >LJJ>> dbVarName="GAMES_PLAYED" >LJJ>> value="50" null="NO" >LJJ>> cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" >LJJ>> dbVarName="GAMES_STARTED" >LJJ>> value="45" null="NO" >LJJ>> cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" dbVarName="FIELD_GOAL" >LJJ>> value="" null="YES" >LJJ>> cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" >LJJ>> dbVarName="THREE_POINT_PERCENT" value="" null="YES" >LJJ>> cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" >LJJ>> dbVarName="FREE_THROW_PERCENT" value="" null="YES" >LJJ>> cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" >LJJ>> dbVarName="REBOUNDS_GAME" >LJJ>> value="" null="YES" >LJJ>> cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" >LJJ>> dbVarName="ASSISTS_GAME" >LJJ>> value="" null="YES" >LJJ>> cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" >LJJ>> dbVarName="TURNOVERS_GAME" >LJJ>> value="" null="YES" >LJJ>> cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" dbVarName="BLOCKS_GAME" >LJJ>> value="" null="YES" >LJJ>> cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" dbVarName="STEALS_GAME" >LJJ>> value="" null="YES" >LJJ>> cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" >LJJ>> dbVarName="TOTAL_POINTS" >LJJ>> value="" null="YES" >LJJ>> cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" dbVarName="POINTS_GAME" >LJJ>> value="" null="YES" >LJJ>> cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" >LJJ>> dbVarName="VERTICAL_JUMP" >LJJ>> value="" null="YES" >LJJ>> cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" >LJJ>> dbVarName="STANDING_REACH" >LJJ>> value="" null="YES" >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> <FONT face="Times New Roman" size=3></FONT> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> The web site you are accessing has experienced an unexpected error. >LJJ>> Please contact the website administrator. >LJJ>> >LJJ>> >LJJ>> The following information is meant for the website developer for >LJJ>> debugging >LJJ>> purposes. >LJJ>> >LJJ>> >LJJ>> Error Occurred While Processing Request >LJJ>> >LJJ>> >LJJ>> >LJJ>> Error Executing Database Query. >LJJ>> >LJJ>> [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type >LJJ>> varchar to numeric. >LJJ>> >LJJ>> The error occurred in >LJJ>> C:\Inetpub\wwwroot\statsandgo\members\Student\Sports\form2action.cfm: >LJJ>> line >LJJ>> 43 >LJJ>> >LJJ>> >LJJ>> 41 : </cfloop> >LJJ>> >LJJ>> 42 : >LJJ>> >LJJ>> 43 : <cfprocresult name="InsertSport" resultset="1"> >LJJ>> >LJJ>> 44 : >LJJ>> >LJJ>> 45 : </cfstoredproc> >LJJ>> >LJJ>> _____ >LJJ>> >LJJ>> >LJJ>> SQLSTATE HY000 >LJJ>> SQL {call sp_Basketball_ins( (param 1) , (param 2) , (param 3) , >LJJ>> (param 4) , (param 5) , (param 6) , (param 7) , (param 8) , (param 9) , >LJJ>> (param 10) , (param 11) , (param 12) , (param 13) , (param 14) , (param >LJJ>> 15) >LJJ>> , (param 16) , (param 17) , (param 18) )} >LJJ>> VENDORERRORCODE 8114 >LJJ>> DATASOURCE profilesandgo >LJJ>> Resources: >LJJ>> >LJJ>> >LJJ>> * Check the ColdFusion documentation >LJJ>> <http://www.macromedia.com/go/proddoc_getdoc> to verify that you are >LJJ>> using >LJJ>> the correct syntax. >LJJ>> >LJJ>> * Search the Knowledge Base >LJJ>> <http://www.macromedia.com/support/coldfusion/> to find a solution to >LJJ>> your >LJJ>> problem. >LJJ>> >LJJ>> >LJJ>> Browser Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; ..NET >LJJ>> CLR >LJJ>> 1.1.4322; InfoPath.1; .NET CLR 2.0.50727) >LJJ>> Remote Address 74.43.153.40 >LJJ>> Referrer >LJJ>> http://www.statsandgo.com/members/student/sports/form2.cfm >LJJ>> >LJJ>> Date/Time 26-Sep-08 02:44 PM >LJJ>> Stack Trace <javascript:;> (click to expand) >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ>> >LJJ> >LJJ> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313179 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
