Catch
Entries: 15
additional
Struct (ordered)
SQL
stringselect data.*, sold_data.sold_count, median_data.median_dom, median_data.median_sq_foot, median_data.median_list_price, median_data.median_saleprice, median_data.median_list_ppsqf, median_data.median_sale_ppsqffrom (select sum(fieldcount) as fieldcount, field, fielddata, avg(avg_list_price) as avg_list_price, avg(avg_ppsqf) as avg_ppsqf, avg(avg_dom) as avg_dom, avg(avg_sq_foot) as avg_sq_footfrom (select count(listingid) as fieldcount, 'mls_ncregional' as mlsid, 'new-hanover' as field, new-hanover as fielddata, avg(cast(list_price as bigint)) as avg_list_price, avg(COALESCE(cast(list_price as bigint) / nullif(cast(sq_foot as float), 0), 0)) as avg_ppsqf, avg(DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() )) AS avg_dom, avg(sq_foot) as avg_sq_footfrom [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(new-hanover) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))group by new-hanover) data_uniongroup by data_union.fielddata, data_union.field) dataleft outer join (select sum(sold_count) as sold_count, field, fielddatafrom (select count(listingid) as sold_count, 'mls_ncregional' as mlsid, 'new-hanover' as field, new-hanover as fielddatafrom [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (saleprice != 0)and (deleteflag = 'y')and (len(new-hanover) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2016%')group by new-hanover)sold_uniongroup by sold_union.fielddata, sold_union.field) sold_dataon sold_data.fielddata = data.fielddataleft join (select fielddata, avg(1.0 * dom) as median_dom, avg(1.0 * sq_foot) as median_sq_foot, avg(1.0 * list_price) as median_list_price, avg(1.0 * saleprice) as median_saleprice, avg(1.0 * list_ppsqf) as median_list_ppsqf, avg(1.0 * sale_ppsqf) as median_sale_ppsqffrom (select new-hanover as fielddata, cast(DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() ) as bigint) as dom, sq_foot, cast(list_price as bigint) as list_price, cast(saleprice as float) as saleprice, COALESCE(cast(list_price as bigint) / nullif(cast(sq_foot as float), 0), 0) as list_ppsqf, COALESCE(cast(saleprice as float) / nullif(cast(sq_foot as float), 0), 0) as sale_ppsqf, rn = ROW_NUMBER() OVER (PARTITION BY new-hanover ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY new-hanover)from [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(new-hanover) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily')) ) median_unionwhere median_union.rn IN ((median_union.c + 1)/2, (median_union.c + 2)/2)group by median_union.fielddata) median_dataon median_data.fielddata = data.fielddataorder by data.fielddata
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string12.00.2000
DriverName
stringMicrosoft JDBC Driver 4.0 for SQL Server
DriverVersion
string4.0.2206.100
Datasource
stringiq_cb_sea_coast
DataSource
stringiq_cb_sea_coast
Detail
stringInvalid column name 'new'.
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
string
NativeErrorCode
number207
queryError
stringselect data.*, sold_data.sold_count, median_data.median_dom, median_data.median_sq_foot, median_data.median_list_price, median_data.median_saleprice, median_data.median_list_ppsqf, median_data.median_sale_ppsqffrom (select sum(fieldcount) as fieldcount, field, fielddata, avg(avg_list_price) as avg_list_price, avg(avg_ppsqf) as avg_ppsqf, avg(avg_dom) as avg_dom, avg(avg_sq_foot) as avg_sq_footfrom (select count(listingid) as fieldcount, 'mls_ncregional' as mlsid, 'new-hanover' as field, new-hanover as fielddata, avg(cast(list_price as bigint)) as avg_list_price, avg(COALESCE(cast(list_price as bigint) / nullif(cast(sq_foot as float), 0), 0)) as avg_ppsqf, avg(DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() )) AS avg_dom, avg(sq_foot) as avg_sq_footfrom [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(new-hanover) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))group by new-hanover) data_uniongroup by data_union.fielddata, data_union.field) dataleft outer join (select sum(sold_count) as sold_count, field, fielddatafrom (select count(listingid) as sold_count, 'mls_ncregional' as mlsid, 'new-hanover' as field, new-hanover as fielddatafrom [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (saleprice != 0)and (deleteflag = 'y')and (len(new-hanover) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2016%')group by new-hanover)sold_uniongroup by sold_union.fielddata, sold_union.field) sold_dataon sold_data.fielddata = data.fielddataleft join (select fielddata, avg(1.0 * dom) as median_dom, avg(1.0 * sq_foot) as median_sq_foot, avg(1.0 * list_price) as median_list_price, avg(1.0 * saleprice) as median_saleprice, avg(1.0 * list_ppsqf) as median_list_ppsqf, avg(1.0 * sale_ppsqf) as median_sale_ppsqffrom (select new-hanover as fielddata, cast(DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() ) as bigint) as dom, sq_foot, cast(list_price as bigint) as list_price, cast(saleprice as float) as saleprice, COALESCE(cast(list_price as bigint) / nullif(cast(sq_foot as float), 0), 0) as list_ppsqf, COALESCE(cast(saleprice as float) / nullif(cast(sq_foot as float), 0), 0) as sale_ppsqf, rn = ROW_NUMBER() OVER (PARTITION BY new-hanover ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY new-hanover)from [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(new-hanover) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily')) ) median_unionwhere median_union.rn IN ((median_union.c + 1)/2, (median_union.c + 2)/2)group by median_union.fielddata) median_dataon median_data.fielddata = data.fielddataorder by data.fielddata
Sql
stringselect data.*, sold_data.sold_count, median_data.median_dom, median_data.median_sq_foot, median_data.median_list_price, median_data.median_saleprice, median_data.median_list_ppsqf, median_data.median_sale_ppsqffrom (select sum(fieldcount) as fieldcount, field, fielddata, avg(avg_list_price) as avg_list_price, avg(avg_ppsqf) as avg_ppsqf, avg(avg_dom) as avg_dom, avg(avg_sq_foot) as avg_sq_footfrom (select count(listingid) as fieldcount, 'mls_ncregional' as mlsid, 'new-hanover' as field, new-hanover as fielddata, avg(cast(list_price as bigint)) as avg_list_price, avg(COALESCE(cast(list_price as bigint) / nullif(cast(sq_foot as float), 0), 0)) as avg_ppsqf, avg(DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() )) AS avg_dom, avg(sq_foot) as avg_sq_footfrom [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(new-hanover) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))group by new-hanover) data_uniongroup by data_union.fielddata, data_union.field) dataleft outer join (select sum(sold_count) as sold_count, field, fielddatafrom (select count(listingid) as sold_count, 'mls_ncregional' as mlsid, 'new-hanover' as field, new-hanover as fielddatafrom [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (saleprice != 0)and (deleteflag = 'y')and (len(new-hanover) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2016%')group by new-hanover)sold_uniongroup by sold_union.fielddata, sold_union.field) sold_dataon sold_data.fielddata = data.fielddataleft join (select fielddata, avg(1.0 * dom) as median_dom, avg(1.0 * sq_foot) as median_sq_foot, avg(1.0 * list_price) as median_list_price, avg(1.0 * saleprice) as median_saleprice, avg(1.0 * list_ppsqf) as median_list_ppsqf, avg(1.0 * sale_ppsqf) as median_sale_ppsqffrom (select new-hanover as fielddata, cast(DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() ) as bigint) as dom, sq_foot, cast(list_price as bigint) as list_price, cast(saleprice as float) as saleprice, COALESCE(cast(list_price as bigint) / nullif(cast(sq_foot as float), 0), 0) as list_ppsqf, COALESCE(cast(saleprice as float) / nullif(cast(sq_foot as float), 0), 0) as sale_ppsqf, rn = ROW_NUMBER() OVER (PARTITION BY new-hanover ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY new-hanover)from [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(new-hanover) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily')) ) median_unionwhere median_union.rn IN ((median_union.c + 1)/2, (median_union.c + 2)/2)group by median_union.fielddata) median_dataon median_data.fielddata = data.fielddataorder by data.fielddata
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332)at com.intergral.fusionreactor.jdbc.jdbc42.PreparedStatementSurrogate2.execute(PreparedStatementSurrogate2.java:200)at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:265)at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:272)at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:218)at lucee.runtime.tag.Query.executeDatasoure(Query.java:820)at lucee.runtime.tag.Query.doEndTag(Query.java:583)at org.lucee.cfml.base_cfc$cf.udfCall1(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc:147)at org.lucee.cfml.base_cfc$cf.udfCall(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:770)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1577)at org.lucee.cfml.query_cfc$cf.udfCall(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Query.cfc:53)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:210)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1920)at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:814)at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1592)at iqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc:232)at iqquery_cfc$cf.udfCall(C:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1903)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1577)at iqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc:141)at iqquery_cfc$cf.udfCall(C:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:210)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1920)at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:563)at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:205)at components.listings_cfc$cf.udfCall2(C:\realistiq\production\iqweb\components\listings.cfc:1658)at components.listings_cfc$cf.udfCall(C:\realistiq\production\iqweb\components\listings.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:210)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1916)at lucee.runtime.tag.Invoke.doComponent(Invoke.java:221)at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:194)at iqweb.app._real_estate_cfm270$cf.call(C:\realistiq\production\iqweb\app\_real-estate.cfm:275)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:900)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:815)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:810)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:801)at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:84)at lib.iq_cfc$cf.udfCall(C:\realistiq\production\iqweb\lib\iq.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1903)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1577)at iqweb.sitetemplates._06.layouts._site_cfm$cf.call(C:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm:177)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:900)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:815)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:810)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:801)at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:55)at lib.iq_cfc$cf.udfCall(C:\realistiq\production\iqweb\lib\iq.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:770)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1577)at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:37)at lib.iq_cfc$cf.udfCall(C:\realistiq\production\iqweb\lib\iq.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1903)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1577)at application_cfc$cf.udfCall(C:\realistiq\production\iqweb\application.cfc:239)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1903)at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:422)at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:224)at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2267)at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2259)at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2227)at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:845)at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:103)at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:62)at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:806)at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:339)at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:215)at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:839)at sun.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:483)at com.intergral.fusionreactor.agent.filter.FusionReactorStaticServlet.service(FusionReactorStaticServlet.java:50)at com.intergral.fusionreactor.agent.pointcuts.ServletPointCut$1.invoke(ServletPointCut.java:41)at javax.servlet.http.HttpServlet.service(HttpServlet.java)at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684)at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501)at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557)at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086)at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:428)at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020)at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:245)at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154)at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)at org.eclipse.jetty.server.Server.handle(Server.java:370)at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494)at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:971)at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1033)at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644)at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:667)at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)at java.lang.Thread.run(Thread.java:745)
TagContext
Array
Rows: 11
1
Struct
codePrintHTML
string145: !---&gt;&lt;cfqueryparam attributecollection=&quot;#item#&quot;&gt;&lt;!---<br>146: !---&gt;&lt;/cfif&gt;&lt;/cfloop&gt;<br><b>147: &lt;/cfquery&gt;</b><br>148: <br>149: &lt;cfset result.setResult(q)&gt;<br>
codePrintPlain
string145: !---><cfqueryparam attributecollection="#item#"><!---146: !---></cfif></cfloop>147: </cfquery>148: 149: <cfset result.setResult(q)>
column
number0
id
string??
line
number147
Raw_Trace
stringorg.lucee.cfml.base_cfc$cf.udfCall1(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc:147)
template
stringC:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc
type
stringcfml
2
Struct
codePrintHTML
string51: <br>52: // invoke the query and return the result<br><b>53: return invokeTag();</b><br>54: }<br>55: <br>
codePrintPlain
string51: 52: // invoke the query and return the result53: return invokeTag();54: }55:
column
number0
id
string??
line
number53
Raw_Trace
stringorg.lucee.cfml.query_cfc$cf.udfCall(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Query.cfc:53)
template
stringC:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Query.cfc
type
stringcfml
3
Struct
codePrintHTML
string230: }<br>231: <br><b>232: local.query = local.queryservice.execute(sql=this['sql']);</b><br>233: <br>234: local.recordset = local.query.getResult();<br>
codePrintPlain
string230: }231: 232: local.query = local.queryservice.execute(sql=this['sql']);233: 234: local.recordset = local.query.getResult();
column
number0
id
string??
line
number232
Raw_Trace
stringiqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc:232)
template
stringC:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc
type
stringcfml
4
Struct
codePrintHTML
string139: this['sql'] = arguments.generatedcontent;<br>140: <br><b>141: local.retQuery = this.query();</b><br>142: <br>143: StructDelete(arguments, &quot;generatedcontent&quot;);<br>
codePrintPlain
string139: this['sql'] = arguments.generatedcontent;140: 141: local.retQuery = this.query();142: 143: StructDelete(arguments, "generatedcontent");
column
number0
id
string??
line
number141
Raw_Trace
stringiqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc:141)
template
stringC:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc
type
stringcfml
5
Struct
codePrintHTML
string1656: <br>1657: #ListLast(arguments.mlsid) neq currmlsid ? 'union' : ''#<br><b>1658: &lt;/cfloop&gt;</b><br>1659: ) data_union<br>1660: <br>
codePrintPlain
string1656: 1657: #ListLast(arguments.mlsid) neq currmlsid ? 'union' : ''#1658: </cfloop>1659: ) data_union1660:
column
number0
id
string??
line
number1658
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2(C:\realistiq\production\iqweb\components\listings.cfc:1658)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
6
Struct
codePrintHTML
string273: &lt;cfinvokeargument name=&quot;layout&quot; value=&quot;list_field&quot;&gt;<br>274: &lt;cfinvokeargument name=&quot;field&quot; value=&quot;#field#&quot;&gt;<br><b>275: &lt;/cfinvoke&gt;</b><br>276: <br>277: &lt;cfif retFieldData.status neq 0&gt;<br>
codePrintPlain
string273: <cfinvokeargument name="layout" value="list_field">274: <cfinvokeargument name="field" value="#field#">275: </cfinvoke>276: 277: <cfif retFieldData.status neq 0>
column
number0
id
string??
line
number275
Raw_Trace
stringiqweb.app._real_estate_cfm270$cf.call(C:\realistiq\production\iqweb\app\_real-estate.cfm:275)
template
stringC:\realistiq\production\iqweb\app\_real-estate.cfm
type
stringcfml
7
Struct
codePrintHTML
string82: &lt;cfelse&gt;<br>83: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/app/_#local.PageName#.cfm&quot;)&gt;<br><b>84: &lt;cfsavecontent variable=&quot;local.retVal&quot;&gt;&lt;cfinclude template=&quot;#request.AppMapPath#/app/_#local.PageName#.cfm&quot; /&gt;&lt;/cfsavecontent&gt;</b><br>85: &lt;cfelse&gt;<br>86: &lt;cfset MissingFile = local.PageName&gt;<br>
codePrintPlain
string82: <cfelse>83: <cfif FileExists("#request.AppAbsolutePath#/app/_#local.PageName#.cfm")>84: <cfsavecontent variable="local.retVal"><cfinclude template="#request.AppMapPath#/app/_#local.PageName#.cfm" /></cfsavecontent>85: <cfelse>86: <cfset MissingFile = local.PageName>
column
number0
id
string??
line
number84
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:84)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
8
Struct
codePrintHTML
string175: <br>176: &lt;div class=&quot;#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#&quot;&gt;<br><b>177: #REQUEST.iqLib.RenderPage()#</b><br>178: &lt;/div&gt;<br>179: &lt;/div&gt;<br>
codePrintPlain
string175: 176: <div class="#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#">177: #REQUEST.iqLib.RenderPage()#178: </div>179: </div>
column
number0
id
string??
line
number177
Raw_Trace
stringiqweb.sitetemplates._06.layouts._site_cfm$cf.call(C:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm:177)
template
stringC:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm
type
stringcfml
9
Struct
codePrintHTML
string53: &lt;cfsavecontent variable=&quot;local.retVal&quot;&gt;&lt;cfinclude template=&quot;#request.CustomMapPath#/layouts/_#local.Layout#.cfm&quot; /&gt;&lt;/cfsavecontent&gt;<br>54: &lt;cfelseif FileExists(&quot;#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot;)&gt;<br><b>55: &lt;cfsavecontent variable=&quot;local.retVal&quot;&gt;&lt;cfinclude template=&quot;#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot; /&gt;&lt;/cfsavecontent&gt;</b><br>56: &lt;cfelse&gt;<br>57: &lt;cfset local.retVal = &quot;&lt;strong&gt;File Not Found.&lt;/strong&gt;&lt;br&gt;The file &amp;quot;&lt;em&gt;#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&lt;/em&gt;&amp;quot; could not be found.&quot;&gt;<br>
codePrintPlain
string53: <cfsavecontent variable="local.retVal"><cfinclude template="#request.CustomMapPath#/layouts/_#local.Layout#.cfm" /></cfsavecontent>54: <cfelseif FileExists("#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm")>55: <cfsavecontent variable="local.retVal"><cfinclude template="#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm" /></cfsavecontent>56: <cfelse>57: <cfset local.retVal = "<strong>File Not Found.</strong><br>The file &quot;<em>#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm</em>&quot; could not be found.">
column
number0
id
string??
line
number55
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:55)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
10
Struct
codePrintHTML
string35: &lt;/cfif&gt;<br>36: <br><b>37: &lt;cfreturn doLayout()&gt;</b><br>38: &lt;/cfif&gt;<br>39: &lt;/cffunction&gt;<br>
codePrintPlain
string35: </cfif>36: 37: <cfreturn doLayout()>38: </cfif>39: </cffunction>
column
number0
id
string??
line
number37
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:37)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
11
Struct
codePrintHTML
string237: local.url.process(cgi.path_info);<br>238: <br><b>239: writeOutput(request.iqLib.RenderContent());</b><br>240: }<br>241: }<br>
codePrintPlain
string237: local.url.process(cgi.path_info);238: 239: writeOutput(request.iqLib.RenderContent());240: }241: }
column
number0
id
string??
line
number239
Raw_Trace
stringapplication_cfc$cf.udfCall(C:\realistiq\production\iqweb\application.cfc:239)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string

Real Estate by IQWeb_new-hanover

Catch
Entries: 15
additional
Struct (ordered)
SQL
stringselect data.*, sold_data.sold_count, median_data.median_dom, median_data.median_sq_foot, median_data.median_list_price, median_data.median_saleprice, median_data.median_list_ppsqf, median_data.median_sale_ppsqffrom (select sum(fieldcount) as fieldcount, field, fielddata, avg(avg_list_price) as avg_list_price, avg(avg_ppsqf) as avg_ppsqf, avg(avg_dom) as avg_dom, avg(avg_sq_foot) as avg_sq_footfrom (select count(listingid) as fieldcount, 'mls_ncregional' as mlsid, 'new-hanover' as field, new-hanover as fielddata, avg(cast(list_price as bigint)) as avg_list_price, avg(COALESCE(cast(list_price as bigint) / nullif(cast(sq_foot as float), 0), 0)) as avg_ppsqf, avg(DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() )) AS avg_dom, avg(sq_foot) as avg_sq_footfrom [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(new-hanover) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))group by new-hanover) data_uniongroup by data_union.fielddata, data_union.field) dataleft outer join (select sum(sold_count) as sold_count, field, fielddatafrom (select count(listingid) as sold_count, 'mls_ncregional' as mlsid, 'new-hanover' as field, new-hanover as fielddatafrom [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (saleprice != 0)and (deleteflag = 'y')and (len(new-hanover) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2016%')group by new-hanover)sold_uniongroup by sold_union.fielddata, sold_union.field) sold_dataon sold_data.fielddata = data.fielddataleft join (select fielddata, avg(1.0 * dom) as median_dom, avg(1.0 * sq_foot) as median_sq_foot, avg(1.0 * list_price) as median_list_price, avg(1.0 * saleprice) as median_saleprice, avg(1.0 * list_ppsqf) as median_list_ppsqf, avg(1.0 * sale_ppsqf) as median_sale_ppsqffrom (select new-hanover as fielddata, cast(DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() ) as bigint) as dom, sq_foot, cast(list_price as bigint) as list_price, cast(saleprice as float) as saleprice, COALESCE(cast(list_price as bigint) / nullif(cast(sq_foot as float), 0), 0) as list_ppsqf, COALESCE(cast(saleprice as float) / nullif(cast(sq_foot as float), 0), 0) as sale_ppsqf, rn = ROW_NUMBER() OVER (PARTITION BY new-hanover ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY new-hanover)from [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(new-hanover) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily')) ) median_unionwhere median_union.rn IN ((median_union.c + 1)/2, (median_union.c + 2)/2)group by median_union.fielddata) median_dataon median_data.fielddata = data.fielddataorder by data.fielddata
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string12.00.2000
DriverName
stringMicrosoft JDBC Driver 4.0 for SQL Server
DriverVersion
string4.0.2206.100
Datasource
stringiq_cb_sea_coast
DataSource
stringiq_cb_sea_coast
Detail
stringInvalid column name 'new'.
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
string
NativeErrorCode
number207
queryError
stringselect data.*, sold_data.sold_count, median_data.median_dom, median_data.median_sq_foot, median_data.median_list_price, median_data.median_saleprice, median_data.median_list_ppsqf, median_data.median_sale_ppsqffrom (select sum(fieldcount) as fieldcount, field, fielddata, avg(avg_list_price) as avg_list_price, avg(avg_ppsqf) as avg_ppsqf, avg(avg_dom) as avg_dom, avg(avg_sq_foot) as avg_sq_footfrom (select count(listingid) as fieldcount, 'mls_ncregional' as mlsid, 'new-hanover' as field, new-hanover as fielddata, avg(cast(list_price as bigint)) as avg_list_price, avg(COALESCE(cast(list_price as bigint) / nullif(cast(sq_foot as float), 0), 0)) as avg_ppsqf, avg(DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() )) AS avg_dom, avg(sq_foot) as avg_sq_footfrom [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(new-hanover) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))group by new-hanover) data_uniongroup by data_union.fielddata, data_union.field) dataleft outer join (select sum(sold_count) as sold_count, field, fielddatafrom (select count(listingid) as sold_count, 'mls_ncregional' as mlsid, 'new-hanover' as field, new-hanover as fielddatafrom [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (saleprice != 0)and (deleteflag = 'y')and (len(new-hanover) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2016%')group by new-hanover)sold_uniongroup by sold_union.fielddata, sold_union.field) sold_dataon sold_data.fielddata = data.fielddataleft join (select fielddata, avg(1.0 * dom) as median_dom, avg(1.0 * sq_foot) as median_sq_foot, avg(1.0 * list_price) as median_list_price, avg(1.0 * saleprice) as median_saleprice, avg(1.0 * list_ppsqf) as median_list_ppsqf, avg(1.0 * sale_ppsqf) as median_sale_ppsqffrom (select new-hanover as fielddata, cast(DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() ) as bigint) as dom, sq_foot, cast(list_price as bigint) as list_price, cast(saleprice as float) as saleprice, COALESCE(cast(list_price as bigint) / nullif(cast(sq_foot as float), 0), 0) as list_ppsqf, COALESCE(cast(saleprice as float) / nullif(cast(sq_foot as float), 0), 0) as sale_ppsqf, rn = ROW_NUMBER() OVER (PARTITION BY new-hanover ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY new-hanover)from [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(new-hanover) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily')) ) median_unionwhere median_union.rn IN ((median_union.c + 1)/2, (median_union.c + 2)/2)group by median_union.fielddata) median_dataon median_data.fielddata = data.fielddataorder by data.fielddata
Sql
stringselect data.*, sold_data.sold_count, median_data.median_dom, median_data.median_sq_foot, median_data.median_list_price, median_data.median_saleprice, median_data.median_list_ppsqf, median_data.median_sale_ppsqffrom (select sum(fieldcount) as fieldcount, field, fielddata, avg(avg_list_price) as avg_list_price, avg(avg_ppsqf) as avg_ppsqf, avg(avg_dom) as avg_dom, avg(avg_sq_foot) as avg_sq_footfrom (select count(listingid) as fieldcount, 'mls_ncregional' as mlsid, 'new-hanover' as field, new-hanover as fielddata, avg(cast(list_price as bigint)) as avg_list_price, avg(COALESCE(cast(list_price as bigint) / nullif(cast(sq_foot as float), 0), 0)) as avg_ppsqf, avg(DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() )) AS avg_dom, avg(sq_foot) as avg_sq_footfrom [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(new-hanover) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))group by new-hanover) data_uniongroup by data_union.fielddata, data_union.field) dataleft outer join (select sum(sold_count) as sold_count, field, fielddatafrom (select count(listingid) as sold_count, 'mls_ncregional' as mlsid, 'new-hanover' as field, new-hanover as fielddatafrom [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (saleprice != 0)and (deleteflag = 'y')and (len(new-hanover) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2016%')group by new-hanover)sold_uniongroup by sold_union.fielddata, sold_union.field) sold_dataon sold_data.fielddata = data.fielddataleft join (select fielddata, avg(1.0 * dom) as median_dom, avg(1.0 * sq_foot) as median_sq_foot, avg(1.0 * list_price) as median_list_price, avg(1.0 * saleprice) as median_saleprice, avg(1.0 * list_ppsqf) as median_list_ppsqf, avg(1.0 * sale_ppsqf) as median_sale_ppsqffrom (select new-hanover as fielddata, cast(DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() ) as bigint) as dom, sq_foot, cast(list_price as bigint) as list_price, cast(saleprice as float) as saleprice, COALESCE(cast(list_price as bigint) / nullif(cast(sq_foot as float), 0), 0) as list_ppsqf, COALESCE(cast(saleprice as float) / nullif(cast(sq_foot as float), 0), 0) as sale_ppsqf, rn = ROW_NUMBER() OVER (PARTITION BY new-hanover ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY new-hanover)from [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(new-hanover) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily')) ) median_unionwhere median_union.rn IN ((median_union.c + 1)/2, (median_union.c + 2)/2)group by median_union.fielddata) median_dataon median_data.fielddata = data.fielddataorder by data.fielddata
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332)at com.intergral.fusionreactor.jdbc.jdbc42.PreparedStatementSurrogate2.execute(PreparedStatementSurrogate2.java:200)at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:265)at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:272)at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:218)at lucee.runtime.tag.Query.executeDatasoure(Query.java:820)at lucee.runtime.tag.Query.doEndTag(Query.java:583)at org.lucee.cfml.base_cfc$cf.udfCall1(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc:147)at org.lucee.cfml.base_cfc$cf.udfCall(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:770)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1577)at org.lucee.cfml.query_cfc$cf.udfCall(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Query.cfc:53)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:210)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1920)at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:814)at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1592)at iqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc:232)at iqquery_cfc$cf.udfCall(C:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1903)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1577)at iqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc:141)at iqquery_cfc$cf.udfCall(C:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:210)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1920)at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:563)at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:205)at components.listings_cfc$cf.udfCall2(C:\realistiq\production\iqweb\components\listings.cfc:1658)at components.listings_cfc$cf.udfCall(C:\realistiq\production\iqweb\components\listings.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:210)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1916)at lucee.runtime.tag.Invoke.doComponent(Invoke.java:221)at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:194)at iqweb.app._real_estate_cfm270$cf.call(C:\realistiq\production\iqweb\app\_real-estate.cfm:275)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:900)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:815)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:810)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:801)at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:84)at lib.iq_cfc$cf.udfCall(C:\realistiq\production\iqweb\lib\iq.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1903)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1577)at iqweb.sitetemplates._06.layouts._site_cfm$cf.call(C:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm:177)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:900)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:815)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:810)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:801)at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:55)at lib.iq_cfc$cf.udfCall(C:\realistiq\production\iqweb\lib\iq.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:770)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1577)at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:37)at lib.iq_cfc$cf.udfCall(C:\realistiq\production\iqweb\lib\iq.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1903)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1577)at application_cfc$cf.udfCall(C:\realistiq\production\iqweb\application.cfc:239)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1903)at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:422)at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:224)at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2267)at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2259)at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2227)at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:845)at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:103)at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:62)at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:806)at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:339)at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:215)at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:839)at sun.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:483)at com.intergral.fusionreactor.agent.filter.FusionReactorStaticServlet.service(FusionReactorStaticServlet.java:50)at com.intergral.fusionreactor.agent.pointcuts.ServletPointCut$1.invoke(ServletPointCut.java:41)at javax.servlet.http.HttpServlet.service(HttpServlet.java)at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684)at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501)at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557)at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086)at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:428)at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020)at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:245)at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154)at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)at org.eclipse.jetty.server.Server.handle(Server.java:370)at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494)at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:971)at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1033)at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644)at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:667)at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)at java.lang.Thread.run(Thread.java:745)
TagContext
Array
Rows: 11
1
Struct
codePrintHTML
string145: !---&gt;&lt;cfqueryparam attributecollection=&quot;#item#&quot;&gt;&lt;!---<br>146: !---&gt;&lt;/cfif&gt;&lt;/cfloop&gt;<br><b>147: &lt;/cfquery&gt;</b><br>148: <br>149: &lt;cfset result.setResult(q)&gt;<br>
codePrintPlain
string145: !---><cfqueryparam attributecollection="#item#"><!---146: !---></cfif></cfloop>147: </cfquery>148: 149: <cfset result.setResult(q)>
column
number0
id
string??
line
number147
Raw_Trace
stringorg.lucee.cfml.base_cfc$cf.udfCall1(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc:147)
template
stringC:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc
type
stringcfml
2
Struct
codePrintHTML
string51: <br>52: // invoke the query and return the result<br><b>53: return invokeTag();</b><br>54: }<br>55: <br>
codePrintPlain
string51: 52: // invoke the query and return the result53: return invokeTag();54: }55:
column
number0
id
string??
line
number53
Raw_Trace
stringorg.lucee.cfml.query_cfc$cf.udfCall(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Query.cfc:53)
template
stringC:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Query.cfc
type
stringcfml
3
Struct
codePrintHTML
string230: }<br>231: <br><b>232: local.query = local.queryservice.execute(sql=this['sql']);</b><br>233: <br>234: local.recordset = local.query.getResult();<br>
codePrintPlain
string230: }231: 232: local.query = local.queryservice.execute(sql=this['sql']);233: 234: local.recordset = local.query.getResult();
column
number0
id
string??
line
number232
Raw_Trace
stringiqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc:232)
template
stringC:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc
type
stringcfml
4
Struct
codePrintHTML
string139: this['sql'] = arguments.generatedcontent;<br>140: <br><b>141: local.retQuery = this.query();</b><br>142: <br>143: StructDelete(arguments, &quot;generatedcontent&quot;);<br>
codePrintPlain
string139: this['sql'] = arguments.generatedcontent;140: 141: local.retQuery = this.query();142: 143: StructDelete(arguments, "generatedcontent");
column
number0
id
string??
line
number141
Raw_Trace
stringiqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc:141)
template
stringC:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc
type
stringcfml
5
Struct
codePrintHTML
string1656: <br>1657: #ListLast(arguments.mlsid) neq currmlsid ? 'union' : ''#<br><b>1658: &lt;/cfloop&gt;</b><br>1659: ) data_union<br>1660: <br>
codePrintPlain
string1656: 1657: #ListLast(arguments.mlsid) neq currmlsid ? 'union' : ''#1658: </cfloop>1659: ) data_union1660:
column
number0
id
string??
line
number1658
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2(C:\realistiq\production\iqweb\components\listings.cfc:1658)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
6
Struct
codePrintHTML
string273: &lt;cfinvokeargument name=&quot;layout&quot; value=&quot;list_field&quot;&gt;<br>274: &lt;cfinvokeargument name=&quot;field&quot; value=&quot;#field#&quot;&gt;<br><b>275: &lt;/cfinvoke&gt;</b><br>276: <br>277: &lt;cfif retFieldData.status neq 0&gt;<br>
codePrintPlain
string273: <cfinvokeargument name="layout" value="list_field">274: <cfinvokeargument name="field" value="#field#">275: </cfinvoke>276: 277: <cfif retFieldData.status neq 0>
column
number0
id
string??
line
number275
Raw_Trace
stringiqweb.app._real_estate_cfm270$cf.call(C:\realistiq\production\iqweb\app\_real-estate.cfm:275)
template
stringC:\realistiq\production\iqweb\app\_real-estate.cfm
type
stringcfml
7
Struct
codePrintHTML
string82: &lt;cfelse&gt;<br>83: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/app/_#local.PageName#.cfm&quot;)&gt;<br><b>84: &lt;cfsavecontent variable=&quot;local.retVal&quot;&gt;&lt;cfinclude template=&quot;#request.AppMapPath#/app/_#local.PageName#.cfm&quot; /&gt;&lt;/cfsavecontent&gt;</b><br>85: &lt;cfelse&gt;<br>86: &lt;cfset MissingFile = local.PageName&gt;<br>
codePrintPlain
string82: <cfelse>83: <cfif FileExists("#request.AppAbsolutePath#/app/_#local.PageName#.cfm")>84: <cfsavecontent variable="local.retVal"><cfinclude template="#request.AppMapPath#/app/_#local.PageName#.cfm" /></cfsavecontent>85: <cfelse>86: <cfset MissingFile = local.PageName>
column
number0
id
string??
line
number84
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:84)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
8
Struct
codePrintHTML
string175: <br>176: &lt;div class=&quot;#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#&quot;&gt;<br><b>177: #REQUEST.iqLib.RenderPage()#</b><br>178: &lt;/div&gt;<br>179: &lt;/div&gt;<br>
codePrintPlain
string175: 176: <div class="#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#">177: #REQUEST.iqLib.RenderPage()#178: </div>179: </div>
column
number0
id
string??
line
number177
Raw_Trace
stringiqweb.sitetemplates._06.layouts._site_cfm$cf.call(C:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm:177)
template
stringC:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm
type
stringcfml
9
Struct
codePrintHTML
string53: &lt;cfsavecontent variable=&quot;local.retVal&quot;&gt;&lt;cfinclude template=&quot;#request.CustomMapPath#/layouts/_#local.Layout#.cfm&quot; /&gt;&lt;/cfsavecontent&gt;<br>54: &lt;cfelseif FileExists(&quot;#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot;)&gt;<br><b>55: &lt;cfsavecontent variable=&quot;local.retVal&quot;&gt;&lt;cfinclude template=&quot;#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot; /&gt;&lt;/cfsavecontent&gt;</b><br>56: &lt;cfelse&gt;<br>57: &lt;cfset local.retVal = &quot;&lt;strong&gt;File Not Found.&lt;/strong&gt;&lt;br&gt;The file &amp;quot;&lt;em&gt;#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&lt;/em&gt;&amp;quot; could not be found.&quot;&gt;<br>
codePrintPlain
string53: <cfsavecontent variable="local.retVal"><cfinclude template="#request.CustomMapPath#/layouts/_#local.Layout#.cfm" /></cfsavecontent>54: <cfelseif FileExists("#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm")>55: <cfsavecontent variable="local.retVal"><cfinclude template="#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm" /></cfsavecontent>56: <cfelse>57: <cfset local.retVal = "<strong>File Not Found.</strong><br>The file &quot;<em>#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm</em>&quot; could not be found.">
column
number0
id
string??
line
number55
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:55)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
10
Struct
codePrintHTML
string35: &lt;/cfif&gt;<br>36: <br><b>37: &lt;cfreturn doLayout()&gt;</b><br>38: &lt;/cfif&gt;<br>39: &lt;/cffunction&gt;<br>
codePrintPlain
string35: </cfif>36: 37: <cfreturn doLayout()>38: </cfif>39: </cffunction>
column
number0
id
string??
line
number37
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:37)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
11
Struct
codePrintHTML
string237: local.url.process(cgi.path_info);<br>238: <br><b>239: writeOutput(request.iqLib.RenderContent());</b><br>240: }<br>241: }<br>
codePrintPlain
string237: local.url.process(cgi.path_info);238: 239: writeOutput(request.iqLib.RenderContent());240: }241: }
column
number0
id
string??
line
number239
Raw_Trace
stringapplication_cfc$cf.udfCall(C:\realistiq\production\iqweb\application.cfc:239)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string