Catch
Entries: 15
additional
Struct
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, 'pender' as field, pender 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 [d2-sql-1].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(pender) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))group by pender) 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, 'pender' as field, pender as fielddatafrom [d2-sql-1].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (saleprice != 0)and (deleteflag = 'y')and (len(pender) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2016%')group by pender)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 pender 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 pender ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY pender)from [d2-sql-1].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(pender) > 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.4100
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 'pender'.
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, 'pender' as field, pender 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 [d2-sql-1].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(pender) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))group by pender) 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, 'pender' as field, pender as fielddatafrom [d2-sql-1].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (saleprice != 0)and (deleteflag = 'y')and (len(pender) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2016%')group by pender)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 pender 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 pender ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY pender)from [d2-sql-1].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(pender) > 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, 'pender' as field, pender 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 [d2-sql-1].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(pender) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))group by pender) 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, 'pender' as field, pender as fielddatafrom [d2-sql-1].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (saleprice != 0)and (deleteflag = 'y')and (len(pender) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2016%')group by pender)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 pender 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 pender ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY pender)from [d2-sql-1].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(pender) > 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:308)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:752)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1579)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:793)at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1589)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:752)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1579)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:87)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:752)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1579)at iqweb.sitetemplates._06.layouts._site_cfm$cf.call(C:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm:180)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:60)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:752)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1579)at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:38)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:752)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1579)at application_cfc$cf.udfCall(C:\realistiq\production\iqweb\application.cfc:263)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:2259)at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2251)at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2219)at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:881)at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102)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.GeneratedMethodAccessor45.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
string85: &lt;cfelse&gt;---&gt;<br>86: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/app/_#local.PageName#.cfm&quot;)&gt;<br><b>87: &lt;cfinclude template=&quot;#request.AppMapPath#/app/_#local.PageName#.cfm&quot; /&gt;</b><br>88: &lt;cfelse&gt;<br>89: &lt;cfset MissingFile = local.PageName&gt;<br>
codePrintPlain
string85: <cfelse>--->86: <cfif FileExists("#request.AppAbsolutePath#/app/_#local.PageName#.cfm")>87: <cfinclude template="#request.AppMapPath#/app/_#local.PageName#.cfm" />88: <cfelse>89: <cfset MissingFile = local.PageName>
column
number0
id
string??
line
number87
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:87)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
8
Struct
codePrintHTML
string178: <br>179: &lt;div class=&quot;#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#&quot;&gt;<br><b>180: #REQUEST.iqLib.RenderPage()#</b><br>181: &lt;/div&gt;<br>182: &lt;/div&gt;<br>
codePrintPlain
string178: 179: <div class="#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#">180: #REQUEST.iqLib.RenderPage()#181: </div>182: </div>
column
number0
id
string??
line
number180
Raw_Trace
stringiqweb.sitetemplates._06.layouts._site_cfm$cf.call(C:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm:180)
template
stringC:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm
type
stringcfml
9
Struct
codePrintHTML
string58: &lt;cfelseif FileExists(&quot;#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot;)&gt;---&gt;<br>59: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot;)&gt;<br><b>60: &lt;cfinclude template=&quot;#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot; /&gt;</b><br>61: &lt;cfelse&gt;<br>62: &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.<br>
codePrintPlain
string58: <cfelseif FileExists("#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm")>--->59: <cfif FileExists("#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm")>60: <cfinclude template="#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm" />61: <cfelse>62: <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
number60
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:60)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
10
Struct
codePrintHTML
string36: <br>37: &lt;cfscript&gt;<br><b>38: doLayout();</b><br>39: &lt;/cfscript&gt;<br>40: &lt;/cfif&gt;<br>
codePrintPlain
string36: 37: <cfscript>38: doLayout();39: </cfscript>40: </cfif>
column
number0
id
string??
line
number38
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:38)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
11
Struct
codePrintHTML
string261: local.url.process(cgi.path_info);<br>262: <br><b>263: writeOutput(request.iqLib.RenderContent());</b><br>264: }<br>265: }<br>
codePrintPlain
string261: local.url.process(cgi.path_info);262: 263: writeOutput(request.iqLib.RenderContent());264: }265: }
column
number0
id
string??
line
number263
Raw_Trace
stringapplication_cfc$cf.udfCall(C:\realistiq\production\iqweb\application.cfc:263)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string

Real Estate by IQWeb_pender

Catch
Entries: 15
additional
Struct
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, 'pender' as field, pender 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 [d2-sql-1].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(pender) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))group by pender) 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, 'pender' as field, pender as fielddatafrom [d2-sql-1].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (saleprice != 0)and (deleteflag = 'y')and (len(pender) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2016%')group by pender)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 pender 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 pender ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY pender)from [d2-sql-1].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(pender) > 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.4100
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 'pender'.
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, 'pender' as field, pender 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 [d2-sql-1].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(pender) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))group by pender) 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, 'pender' as field, pender as fielddatafrom [d2-sql-1].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (saleprice != 0)and (deleteflag = 'y')and (len(pender) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2016%')group by pender)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 pender 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 pender ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY pender)from [d2-sql-1].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(pender) > 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, 'pender' as field, pender 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 [d2-sql-1].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(pender) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))group by pender) 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, 'pender' as field, pender as fielddatafrom [d2-sql-1].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (saleprice != 0)and (deleteflag = 'y')and (len(pender) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2016%')group by pender)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 pender 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 pender ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY pender)from [d2-sql-1].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (deleteflag = 'n')and (len(pender) > 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:308)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:752)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1579)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:793)at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1589)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:752)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1579)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:87)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:752)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1579)at iqweb.sitetemplates._06.layouts._site_cfm$cf.call(C:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm:180)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:60)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:752)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1579)at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:38)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:752)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1579)at application_cfc$cf.udfCall(C:\realistiq\production\iqweb\application.cfc:263)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:2259)at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2251)at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2219)at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:881)at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102)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.GeneratedMethodAccessor45.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
string85: &lt;cfelse&gt;---&gt;<br>86: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/app/_#local.PageName#.cfm&quot;)&gt;<br><b>87: &lt;cfinclude template=&quot;#request.AppMapPath#/app/_#local.PageName#.cfm&quot; /&gt;</b><br>88: &lt;cfelse&gt;<br>89: &lt;cfset MissingFile = local.PageName&gt;<br>
codePrintPlain
string85: <cfelse>--->86: <cfif FileExists("#request.AppAbsolutePath#/app/_#local.PageName#.cfm")>87: <cfinclude template="#request.AppMapPath#/app/_#local.PageName#.cfm" />88: <cfelse>89: <cfset MissingFile = local.PageName>
column
number0
id
string??
line
number87
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:87)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
8
Struct
codePrintHTML
string178: <br>179: &lt;div class=&quot;#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#&quot;&gt;<br><b>180: #REQUEST.iqLib.RenderPage()#</b><br>181: &lt;/div&gt;<br>182: &lt;/div&gt;<br>
codePrintPlain
string178: 179: <div class="#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#">180: #REQUEST.iqLib.RenderPage()#181: </div>182: </div>
column
number0
id
string??
line
number180
Raw_Trace
stringiqweb.sitetemplates._06.layouts._site_cfm$cf.call(C:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm:180)
template
stringC:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm
type
stringcfml
9
Struct
codePrintHTML
string58: &lt;cfelseif FileExists(&quot;#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot;)&gt;---&gt;<br>59: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot;)&gt;<br><b>60: &lt;cfinclude template=&quot;#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot; /&gt;</b><br>61: &lt;cfelse&gt;<br>62: &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.<br>
codePrintPlain
string58: <cfelseif FileExists("#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm")>--->59: <cfif FileExists("#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm")>60: <cfinclude template="#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm" />61: <cfelse>62: <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
number60
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:60)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
10
Struct
codePrintHTML
string36: <br>37: &lt;cfscript&gt;<br><b>38: doLayout();</b><br>39: &lt;/cfscript&gt;<br>40: &lt;/cfif&gt;<br>
codePrintPlain
string36: 37: <cfscript>38: doLayout();39: </cfscript>40: </cfif>
column
number0
id
string??
line
number38
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:38)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
11
Struct
codePrintHTML
string261: local.url.process(cgi.path_info);<br>262: <br><b>263: writeOutput(request.iqLib.RenderContent());</b><br>264: }<br>265: }<br>
codePrintPlain
string261: local.url.process(cgi.path_info);262: 263: writeOutput(request.iqLib.RenderContent());264: }265: }
column
number0
id
string??
line
number263
Raw_Trace
stringapplication_cfc$cf.udfCall(C:\realistiq\production\iqweb\application.cfc:263)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string