I keep getting an error that appears to be in my <cfprocresult as follows.....
Any quick help would be greatly appreciated....
I hope that I have included enough information for some help.
Thanks in advance
TABLE SCHEMA - [dbo].[tbl_Schol]
scholid int Unchecked
name varchar(50) Checked
schol_type_id int Checked
scholarships_uid int Checked
academic_uid int Checked
tablename varchar(50) Checked
Student_UID int Checked
TABLE DATA - [dbo].[tbl_Schol]
1 Baseball 14 14 14 Baseball 1
2 Football 3 3 1 Football 3
3 Football 3 1 1 Football 4
4 Football 3 7 1 Football 7
5 Football 3 5 1 Football 5
6 Football 3 8 1 Football 8
7 Football 3 8 1 Football 10
8 Football 0 0 0 Football 11
9 Football 0 0 0 Football 12
NULL NULL NULL NULL NULL NULL NULL
STORED PROCEDURE - [dbo].[sp_Schol_ins]
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Larry Juncker
-- Create date: 2008-09-15
-- Description: This SP will insert a new scolarship record into the Athlete
table
-- =============================================
ALTER PROCEDURE [dbo].[sp_Schol_ins]
-- Add the parameters for the stored procedure here
--<@Param1, sysname, @p1> <Datatype_For_Param1, , int> =
<Default_Value_For_Param1, , 0>,
@name varchar(50) = NULL,
@schol_type_id int = NULL,
@scholarships_uid int = NULL,
@academic_uid int = NULL,
@tablename varchar(50) = NULL,
@Student_UID int = NULL
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
--SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2>
INSERT INTO [dbo].[tbl_Schol]
([name],
[schol_type_id],
[scholarships_uid],
[academic_uid],
[tablename],
[Student_UID])
VALUES
(@name,
@schol_type_id,
@scholarships_uid,
@academic_uid,
@tablename,
@Student_UID)
SELECT TOP 1 * FROM [dbo].[tbl_Schol] ORDER BY ScholID DESC
RETURN
END
COLD FUSION CODE
<cftransaction>
<cfstoredproc procedure="sp_schol_ins"
datasource="profilesandgo">
<cfprocparam type="In" cfsqltype="CF_SQL_INTEGER"
dbVarName="Student_UID" value="#Form.Student_UID#" null="No">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR"
dbVarName="TableName" value="#FORM.Sport#" null="No">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR"
dbVarName="Name" value="#FORM.Sport#" null="No">
<cfprocresult name="InsertSchol" resultset="1">
</cfstoredproc>
</cftransaction>
COLD FUSION ERROR
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 int.
The error occurred in
C:\Inetpub\wwwroot\statsandgo\members\Student\Sports\form2action.cfm: line 56
54 : <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR"
dbVarName="Name" value="#FORM.Sport#" null="No">
55 :
56 : <cfprocresult name="InsertSchol" resultset="1">
57 : </cfstoredproc>
58 : </cftransaction>
--------------------------------------------------------------------------------
SQLSTATE HY000
SQL {call sp_schol_ins( (param 1) , (param 2) , (param 3) )}
VENDORERRORCODE 8114
DATASOURCE profilesandgo
Resources:
Check the ColdFusion documentation to verify that you are using the correct
syntax.
Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR
2.0.50727; .NET CLR 1.1.4322; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)
w:PACBHO60
Remote Address 74.33.132.212
Referrer http://www.statsandgo.com/members/student/sports/form2.cfm
Date/Time 17-Sep-08 06:41 AM
Stack Trace (click to expand)
at
cfform2action2ecfm1601602585.runPage(C:\Inetpub\wwwroot\statsandgo\members\Student\Sports\form2action.cfm:56)
at
cfform2action2ecfm1601602585.runPage(C:\Inetpub\wwwroot\statsandgo\members\Student\Sports\form2action.cfm:56)
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Error
converting data type varchar to int.
at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
Source)
at
macromedia.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at
macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown
Source)
at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown
Source)
at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at macromedia.jdbc.base.BasePreparedStatement.postImplExecute(Unknown
Source)
at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at macromedia.jdbc.base.BasePreparedStatement.execute(Unknown Source)
at macromedia.jdbc.base.BasePreparedStatementPoolable.execute(Unknown
Source)
at
coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:89)
at coldfusion.sql.Executive.executeCall(Executive.java:860)
at coldfusion.sql.Executive.executeCall(Executive.java:775)
at coldfusion.sql.Executive.executeCall(Executive.java:726)
at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:445)
at
coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:272)
at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:225)
at
cfform2action2ecfm1601602585.runPage(C:\Inetpub\wwwroot\statsandgo\members\Student\Sports\form2action.cfm:56)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279)
at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
at
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at
coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126)
at coldfusion.CfmServlet.service(CfmServlet.java:175)
at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at
coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at
coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:284)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
--------------------------------------------------------------------------------
Debugging Information ColdFusion Server Standard 8,0,0,176276
Template /members/student/sports/form2action.cfm
Time Stamp 17-Sep-08 06:41 AM
Locale English (US)
User Agent Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR
2.0.50727; .NET CLR 1.1.4322; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022)
w:PACBHO60
Remote IP 74.33.132.212
Host Name 74.33.132.212
FORM FIELDS
Form Fields:
COACH_UID=0
CONTINUE=Continue
DB_I_ASSISTS=
DB_I_BLOCKED_FIELD_GOALS=
DB_I_BLOCKED_PASSES=
DB_I_BLOCKED_PUNTS=
DB_I_COMPLETIONS=
DB_I_DEFENSIVE_INTERCEPTIONS=
DB_I_FIELD_GOALS_ATTEMPTED=
DB_I_FIELD_GOALS_MADE=
DB_I_FUMBLES=
DB_I_FUMBLES_CAUSED=
DB_I_FUMBLES_RECOVERED=
DB_I_GAMES_PLAYED=45
DB_I_GAMES_STARTED=50
DB_I_INTERCEPTIONS=
DB_I_KILLS_INSIDE_20=
DB_I_LONGEST_FIELD_GOAL=
DB_I_LONGEST_PUNT=
DB_I_PASSING_ATTEMPTS=
DB_I_PUNTS=
DB_I_RECEIVING_TD=
DB_I_RECEIVING_YARDS=
DB_I_RECEPTIONS=
DB_I_RUSHES=
DB_I_RUSHES_ON_PASSER=
DB_I_RUSHING_TD=
DB_I_RUSHING_YARDS=
DB_I_SACKS=
DB_I_TACKLES=
DB_I_TACKLES_FOR_LOSS=
DB_I_TD_PASSES=
DB_I_THROWING_YARDS=
DB_I_TOTAL_POINTS_SCORED=
DB_N_AVERAGE_PER_PUNT=
DB_N_COMPLETION_PERCENTAGE=
DB_N_EXTRA_POINT_PERCENTAGE=
DB_N_FIELD_GOAL_PERCENTAGE=
DB_N_KICK_OFF_RETURN_AVERAGE=
DB_N_PUNT_RETURN_AVERAGE=
DB_N_YARDS_PER_CARRY=
DB_T_GRADE=SR
DB_T_PRIMARY_POSITION=Wide Receiver
PROCESSFORM=Y
SPORT=Football
STUDENT_UID=12
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312657
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
