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