RE: Error converting data type varchar to numeric
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"
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 :
42 :
43 :
44 :
45 :
_
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) )}
VENDORERRORCODE8114
DATASOURCE profilesandgo
Resources:
* Check the ColdFusion documentation
to verify that you are using
the correct syntax.
* Search the Knowledge Base
RE: Error converting data type varchar to numeric
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"
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 :
42 :
43 :
44 :
45 :
_
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) )}
VENDORERRORCODE8114
DATASOURCE profilesandgo
Resources:
* Check the ColdFusion documentation
to verify that you are using
the correct syntax.
* Search the Knowledge Base
Re: Error converting data type varchar to numeric
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"
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 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 :
>
> 42 :
>
> 43 :
>
> 44 :
>
> 45 :
>
> _
>
>
> 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) )}
> VENDORERRORCODE8114
> DATASOURCE profilesandgo
> Resources:
>
>
> * Check the ColdFusion documentation
> to verify that you are
> using
> the correct syntax.
>
> * Search the Knowledge Base
>
Re: Error converting data type varchar to numeric
I was under the understanding that if null="Yes", then the value was igored and not sent to the SP -- 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" ~| 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:313172 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Error converting data type varchar to numeric
Taken Care of. I discovered that the Stored Procedure has to be set up in the exact order the table is set up. I am used to queries where a value can be inserted at any point as long as the column name is presented. Thanks to everyone for your help -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2008 11:21 PM To: cf-talk Subject: [SPAM] Re: Error converting data type varchar to numeric I was under the understanding that if null="Yes", then the value was igored and not sent to the SP -- 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" ~| 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:313207 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
GOT IT.....Re: Error converting data type varchar to numeric
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>>
>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 :
>LJJ>>
>LJJ>> 42 :
>LJJ>>
>LJJ>> 43 :
>LJJ>>
>LJJ>> 44 :
>LJJ>>
>LJJ>> 45 :
>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) , (pa
