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]Line 16: Incorrect syntax near 'Eagle'.
 
The error occurred in /home/imdaMarketplace/www/listings/dsp_main.cfm: line 72
Called from /home/imdaMarketplace/www/listings/fbx_Switch.cfm: line 7
Called from /home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm: line 242
Called from /home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm: line 1
Called from /home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm: line 1
Called from /home/imdaMarketplace/www/index.cfm: line 4
Called from /home/imdaMarketplace/www/listings/dsp_main.cfm: line 72
Called from /home/imdaMarketplace/www/listings/fbx_Switch.cfm: line 7
Called from /home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm: line 242
Called from /home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm: line 1
Called from /home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm: line 1
Called from /home/imdaMarketplace/www/index.cfm: line 4
70 : 					</cfif>
71 : 					
72 : 				 ORDER BY #trim(attributes.orderBy)# #trim(attributes.sortType)#
73 : </cfquery>
74 : 

SQL    SELECT view_classified.*, view_userInfo.city FROM view_classified INNER JOIN view_userInfo ON view_userInfo.useriD = view_classified.userID WHERE view_classified.active = 1 AND view_userInfo.active = 1 AND view_classified.categoryID = 3 AND view_classified.adID IN (SELECT adID FROM tblClassifiedDetails WHERE fieldOptionID = 3 ) AND view_classified.adID IN (SELECT adID FROM tblClassifiedDetails WHERE fieldID = 25 AND fieldValue = 'Screamin' Eagle V-Rod Destroyer') ORDER BY price DESC
DATASOURCE   imdaMarketplace
VENDORERRORCODE   170
SQLSTATE   HY000
Resources:

Browser   CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address   38.103.63.16
Referrer  
Date/Time   13-May-08 08:12 AM
Stack Trace
at cfdsp_main2ecfm2089958427.runPage(/home/imdaMarketplace/www/listings/dsp_main.cfm:72) at cffbx_Switch2ecfm1359289252.runPage(/home/imdaMarketplace/www/listings/fbx_Switch.cfm:7) at cffbx_fusebox30_CF50_nix2ecfm1515294048._factor4(/home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm:242) at cffbx_fusebox30_CF50_nix2ecfm1515294048._factor5(/home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm:1) at cffbx_fusebox30_CF50_nix2ecfm1515294048.runPage(/home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm:1) at cfindex2ecfm1760952798.runPage(/home/imdaMarketplace/www/index.cfm:4) at cfdsp_main2ecfm2089958427.runPage(/home/imdaMarketplace/www/listings/dsp_main.cfm:72) at cffbx_Switch2ecfm1359289252.runPage(/home/imdaMarketplace/www/listings/fbx_Switch.cfm:7) at cffbx_fusebox30_CF50_nix2ecfm1515294048._factor4(/home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm:242) at cffbx_fusebox30_CF50_nix2ecfm1515294048._factor5(/home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm:1) at cffbx_fusebox30_CF50_nix2ecfm1515294048.runPage(/home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm:1) at cfindex2ecfm1760952798.runPage(/home/imdaMarketplace/www/index.cfm:4)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 16: Incorrect syntax near 'Eagle'.
	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.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.BaseStatement.commonExecute(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
	at coldfusion.sql.Executive.executeQuery(Executive.java:775)
	at coldfusion.sql.Executive.executeQuery(Executive.java:685)
	at coldfusion.sql.Executive.executeQuery(Executive.java:646)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500)
	at cfdsp_main2ecfm2089958427.runPage(/home/imdaMarketplace/www/listings/dsp_main.cfm:72)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
	at cffbx_Switch2ecfm1359289252.runPage(/home/imdaMarketplace/www/listings/fbx_Switch.cfm:7)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
	at cffbx_fusebox30_CF50_nix2ecfm1515294048._factor4(/home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm:242)
	at cffbx_fusebox30_CF50_nix2ecfm1515294048._factor5(/home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm:1)
	at cffbx_fusebox30_CF50_nix2ecfm1515294048.runPage(/home/imdaMarketplace/www/fbx_fusebox30_CF50_nix.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
	at cfindex2ecfm1760952798.runPage(/home/imdaMarketplace/www/index.cfm:4)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
	at coldfusion.CfmServlet.service(CfmServlet.java:107)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)