Client Testimonials:
Tax Executives Institute

C B Richard Ellis

Eli Lilly and Company

Procter and Gamble Company

E M C Corporation

Cemex USA

Anonymous

Bio - Rad Laboratories, Incorporated

Computer Sciences Corporation

Edison Mission Energy

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 'S7BK6104151' 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:18 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 'S7BK6104151' 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)