Client Testimonials:
Tax Executives Institute

Computer Sciences Corporation

Altria Group Inc.

Procter and Gamble Company

Edison Mission Energy

Brown - Forman Corporation

3M Company

S C Johnson

Anonymous

HayGroup

TaxSearch® Client Testimonials

Error Occurred While Processing Request 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]Conversion failed when converting the varchar value 'MBKRB8K033505' to data type int.

The error occurred in D:\Inetpub\wwwroot\www.taxsearchinc.com\client_detail.cfm: line 126

124 : SELECT contact_name,city,state,id as refid,title,quote,company,company_description
125 : FROM testimonials
126 : Where ID= <cfqueryparam cfsqltype="cf_sql_varchar" value="#refID#" />
127 : </cfquery>
128 : <cfoutput query="QGetClientTestimonialsByName">

SQLSTATE	22018
SQL	SELECT contact_name,city,state,id as refid,title,quote,company,company_description FROM testimonials Where ID= (param 1)
VENDORERRORCODE	245
DATASOURCE	TTLIVE

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	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address	38.107.191.109
Referrer
Date/Time	08-Sep-10 03:07 AM

Stack Trace

at cfclient_detail2ecfm860067559.runPage(D:\Inetpub\wwwroot\www.taxsearchinc.com\client_detail.cfm:126) at cfclient_detail2ecfm860067559.runPage(D:\Inetpub\wwwroot\www.taxsearchinc.com\client_detail.cfm:126)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting the varchar value 'MBKRB8K033505' to data type 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.sql.Executive.executeQuery(Executive.java:1249)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1008)
	at coldfusion.sql.Executive.executeQuery(Executive.java:939)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521)
	at cfclient_detail2ecfm860067559.runPage(D:\Inetpub\wwwroot\www.taxsearchinc.com\client_detail.cfm:126)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
	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.CfmServlet.service(CfmServlet.java:175)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at com.intergral.fusionreactor.filter.FusionReactorFilter.b(FusionReactorFilter.java:376)
	at com.intergral.fusionreactor.filter.FusionReactorFilter.c(FusionReactorFilter.java:254)
	at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:164)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	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:286)
	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)