An unexpected error occurred.

Please provide the following information to technical support:

Error Event:

Error details:

struct
DataSource arlington_dsn
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type varchar to float.
ErrorCode HY000
Message Error Executing Database Query.
NativeErrorCode 8114
RootCause
struct
ErrorCode 8114
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type varchar to float.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type varchar to float. 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.tds.TDSRequest.getRow(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplResultSet.fetchAtPosition(Unknown Source) at macromedia.jdbc.base.BaseImplResultSet.next(Unknown Source) at macromedia.jdbc.base.BaseResultSet.next(Unknown Source) at coldfusion.sql.QueryTable.populate(QueryTable.java:287) at coldfusion.sql.QueryTable.populate(QueryTable.java:216) at coldfusion.sql.Executive.getRowSet(Executive.java:314) at coldfusion.sql.Executive.executeQuery(Executive.java:778) 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 cfpastprojects2ecfm478602251.runPage(C:\Hosting\PLSCorporate\nhunger\arlingtondevelopment.com\www\pastprojects.cfm:18) 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:219) 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)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 18
RAW_TRACE at cfpastprojects2ecfm478602251.runPage(C:\Hosting\PLSCorporate\nhunger\arlingtondevelopment.com\www\pastprojects.cfm:18)
TEMPLATE C:\Hosting\PLSCorporate\nhunger\arlingtondevelopment.com\www\pastprojects.cfm
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql Select listingid, listingtitle, bedroom, sf, price, description, pic1, pic2, pic3, pic4, pic5, movielink, design, garage, tofinish, hometype, homestyle, moveinready, neighborhood, movie, bathroom, projectstatus From tblListing Where projectstatus = (param 1) AND price != 'PRE-SOLD' ORDER BY CAST(price AS float) DESC;
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580) at cfpastprojects2ecfm478602251.runPage(C:\Hosting\PLSCorporate\nhunger\arlingtondevelopment.com\www\pastprojects.cfm:18) 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:219) 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)
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 18
RAW_TRACE at cfpastprojects2ecfm478602251.runPage(C:\Hosting\PLSCorporate\nhunger\arlingtondevelopment.com\www\pastprojects.cfm:18)
TEMPLATE C:\Hosting\PLSCorporate\nhunger\arlingtondevelopment.com\www\pastprojects.cfm
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type varchar to float.
where (param 1) = [type='IN', class='java.lang.Boolean', value='false', sqltype='cf_sql_bit']