[quote:1e34d]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 D:\Inetpub\wwwroot\defaultweb\Application.cfm: line 84
82 : <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@vchHTTPReferer" value="#HTTPReferer#">
83 : <cfprocparam type="Out" cfsqltype="CF_SQL_NUMERIC" dbvarname="@iHTTPRefererID" variable="RefererID">
84 : </cfstoredproc>
85 :
86 : <cfset LinkTo=Left("#CGI.SCRIPT_NAME#?#CGI.QUERY_STRING#" ,1000)>
--------------------------------------------------------------------------------
SQL {call spLogReferer( (param 1) , (param 2) )}
DATASOURCE bikinikaratebabes
VENDORERRORCODE 8114
SQLSTATE HY000
Please try the following:
Check the CFML Reference Manual 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 6.0; Windows 98)
Remote Address 65.70.203.130
Referrer
http://www.alliedassault.com/phpBB2/vie ... p?t=161260
Date/Time 25-Apr-03 05:13 PM
Stack Trace (click to expand)
at cfApplication2ecfm1260042926.runPage(D:\Inetpub\ww wroot\defaultweb\Application.cfm:84) at cfApplication2ecfm1260042926.runPage(D:\Inetpub\ww wroot\defaultweb\Application.cfm:84)
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type varchar to int.
at macromedia.jdbc.base.BaseExceptions.createExceptio n(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(U nknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processEr rorToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processRe plyToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRPCRequest.proces sReplyToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processRe ply(Unknown Source)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.g etNextResultType(Unknown Source)
at macromedia.jdbc.base.BaseStatement.commonTransitio nToState(Unknown Source)
at macromedia.jdbc.base.BaseStatement.postImplExecute (Unknown Source)
at macromedia.jdbc.base.BasePreparedStatement.postImp lExecute(Unknown Source)
at macromedia.jdbc.base.BaseStatement.commonExecute(U nknown Source)
at macromedia.jdbc.base.BaseStatement.executeInternal (Unknown Source)
at macromedia.jdbc.base.BasePreparedStatement.execute (Unknown Source)
at jrun.sql.JRunPreparedStatement.execute(JRunPrepare dStatement.java:134)
at coldfusion.sql.Executive.executeCall(Unknown Source)
at coldfusion.sql.Executive.executeCall(Unknown Source)
at coldfusion.sql.SqlImpl.executeCall(Unknown Source)
at coldfusion.tagext.sql.StoredProcTag.doEndTag(Unkno wn Source)
at cfApplication2ecfm1260042926.runPage(D:\Inetpub\ww wroot\defaultweb\Application.cfm:84)
at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Unkno wn Source)
at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
at coldfusion.filter.CfincludeFilter.include(Unknown Source)
at coldfusion.filter.ApplicationFilter.invoke(Unknown Source)
at coldfusion.filter.PathFilter.invoke(Unknown Source)
at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
at coldfusion.filter.BrowserDebugFilter.invoke(Unknow n Source)
at coldfusion.filter.ClientScopePersistenceFilter.inv oke(Unknown Source)
at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
at coldfusion.CfmServlet.service(Unknown Source)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker. java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvok erChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequ estDispatcher.java:241)
at jrun.servlet.ServletEngineService.dispatch(Servlet EngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable( JRunProxyService.java:198)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invok eRunnable(ThreadPool.java:348)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRu nnable(ThreadPool.java:451)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeR unnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java :66)
[/quote:1e34d]
cry: it wont work