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]Incorrect syntax near '203'.
 
The error occurred in C:\inetpub\wwwroot\propertynetwork\wwwroot\sales_enquiry.cfm: line 132
Called from C:\inetpub\wwwroot\propertynetwork\wwwroot\sales_enquiry.cfm: line 1
Called from C:\inetpub\wwwroot\propertynetwork\wwwroot\sales_enquiry.cfm: line 132
Called from C:\inetpub\wwwroot\propertynetwork\wwwroot\sales_enquiry.cfm: line 1
130 : 
131 : <cfquery name="Recordset2" datasource="homefinders">
132 : SELECT * FROM property_query_ALL WHERE ID = #Recordset2__MMColParam# 
133 : </cfquery>
134 : 

SQL    SELECT * FROM property_query_ALL WHERE ID = RENTAL 203
DATASOURCE   homefinders
VENDORERRORCODE   102
SQLSTATE   HY000
Resources:

Browser   CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address   38.107.191.103
Referrer  
Date/Time   10-Sep-10 02:50 PM
Stack Trace
at cfsales_enquiry2ecfm884299098._factor3(C:\inetpub\wwwroot\propertynetwork\wwwroot\sales_enquiry.cfm:132) at cfsales_enquiry2ecfm884299098.runPage(C:\inetpub\wwwroot\propertynetwork\wwwroot\sales_enquiry.cfm:1) at cfsales_enquiry2ecfm884299098._factor3(C:\inetpub\wwwroot\propertynetwork\wwwroot\sales_enquiry.cfm:132) at cfsales_enquiry2ecfm884299098.runPage(C:\inetpub\wwwroot\propertynetwork\wwwroot\sales_enquiry.cfm:1)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '203'.
	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:719)
	at coldfusion.sql.Executive.executeQuery(Executive.java:652)
	at coldfusion.sql.Executive.executeQuery(Executive.java:613)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:499)
	at cfsales_enquiry2ecfm884299098._factor3(C:\inetpub\wwwroot\propertynetwork\wwwroot\sales_enquiry.cfm:132)
	at cfsales_enquiry2ecfm884299098.runPage(C:\inetpub\wwwroot\propertynetwork\wwwroot\sales_enquiry.cfm:1)
	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:210)
	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.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)