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:313143
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
