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, '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.5000
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:834)at lucee.runtime.tag.Query.doEndTag(Query.java:594)at org.lucee.cfml.base_cfc$cf.udfCall1(/org/lucee/cfml/Base.cfc:110)at org.lucee.cfml.base_cfc$cf.udfCall(/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:772)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599)at org.lucee.cfml.query_cfc$cf.udfCall(/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:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1934)at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:814)at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1614)at iqquery_cfc$cf.udfCall1(/iqquery.cfc:232)at iqquery_cfc$cf.udfCall(/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:696)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1917)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599)at iqquery_cfc$cf.udfCall1(/iqquery.cfc:141)at iqquery_cfc$cf.udfCall(/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:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1934)at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:563)at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:205)at components.listings_cfc$cf.udfCall2(/components/listings.cfc:1658)at components.listings_cfc$cf.udfCall(/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:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930)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(/iqapp_mappath/iqweb/app/_real-estate.cfm:280)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:918)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:833)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:828)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:819)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:82)at lib.iq_cfc$cf.udfCall(/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:696)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1917)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599)at iqweb.sitetemplates._06.layouts._site_cfm$cf.call(/iqapp_mappath/iqweb/sitetemplates/06/layouts/_site.cfm:198)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:918)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:833)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:828)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:819)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:61)at lib.iq_cfc$cf.udfCall(/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:772)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:42)at lib.iq_cfc$cf.udfCall(/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:696)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1917)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599)at application_cfc$cf.udfCall(/Application.cfc:261)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:696)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1917)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:2293)at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2284)at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2252)at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:891)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.GeneratedMethodAccessor36.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
string
codePrintPlain
string
column
number0
id
string??
line
number110
Raw_Trace
stringorg.lucee.cfml.base_cfc$cf.udfCall1(/org/lucee/cfml/Base.cfc:110)
template
string/org/lucee/cfml/Base.cfc
type
stringcfml
2
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number53
Raw_Trace
stringorg.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:53)
template
string/org/lucee/cfml/Query.cfc
type
stringcfml
3
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number232
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:232)
template
string/iqquery.cfc
type
stringcfml
4
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number141
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:141)
template
string/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(/components/listings.cfc:1658)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
6
Struct
codePrintHTML
string278: &lt;cfinvokeargument name=&quot;layout&quot; value=&quot;list_field&quot;&gt;<br>279: &lt;cfinvokeargument name=&quot;field&quot; value=&quot;#field#&quot;&gt;<br><b>280: &lt;/cfinvoke&gt;</b><br>281: <br>282: &lt;cfif retFieldData.status neq 0&gt;<br>
codePrintPlain
string278: <cfinvokeargument name="layout" value="list_field">279: <cfinvokeargument name="field" value="#field#">280: </cfinvoke>281: 282: <cfif retFieldData.status neq 0>
column
number0
id
string??
line
number280
Raw_Trace
stringiqweb.app._real_estate_cfm270$cf.call(/iqapp_mappath/iqweb/app/_real-estate.cfm:280)
template
stringC:\realistiq\production\iqweb\app\_real-estate.cfm
type
stringcfml
7
Struct
codePrintHTML
string80: <br>81: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/app/_#local.PageName#.cfm&quot;)&gt;<br><b>82: &lt;cfinclude template=&quot;#request.AppMapPath#/app/_#local.PageName#.cfm&quot; /&gt;</b><br>83: &lt;cfelse&gt;<br>84: &lt;cfset MissingFile = local.PageName&gt;<br>
codePrintPlain
string80: 81: <cfif FileExists("#request.AppAbsolutePath#/app/_#local.PageName#.cfm")>82: <cfinclude template="#request.AppMapPath#/app/_#local.PageName#.cfm" />83: <cfelse>84: <cfset MissingFile = local.PageName>
column
number0
id
string??
line
number82
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:82)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
8
Struct
codePrintHTML
string196: <br>197: &lt;div class=&quot;#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#&quot;&gt;<br><b>198: #REQUEST.iqLib.RenderPage()#</b><br>199: &lt;/div&gt;<br>200: &lt;/div&gt;<br>
codePrintPlain
string196: 197: <div class="#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#">198: #REQUEST.iqLib.RenderPage()#199: </div>200: </div>
column
number0
id
string??
line
number198
Raw_Trace
stringiqweb.sitetemplates._06.layouts._site_cfm$cf.call(/iqapp_mappath/iqweb/sitetemplates/06/layouts/_site.cfm:198)
template
stringC:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm
type
stringcfml
9
Struct
codePrintHTML
string59: &lt;cfelse&gt;<br>60: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot;)&gt;<br><b>61: &lt;cfinclude template=&quot;#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot; /&gt;</b><br>62: &lt;cfelse&gt;<br>63: &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
string59: <cfelse>60: <cfif FileExists("#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm")>61: <cfinclude template="#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm" />62: <cfelse>63: <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
number61
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:61)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
10
Struct
codePrintHTML
string40: <br>41: &lt;cfscript&gt;<br><b>42: doLayout();</b><br>43: &lt;/cfscript&gt;<br>44: &lt;/cfif&gt;<br>
codePrintPlain
string40: 41: <cfscript>42: doLayout();43: </cfscript>44: </cfif>
column
number0
id
string??
line
number42
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:42)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
11
Struct
codePrintHTML
string259: local.url.process(cgi.path_info);<br>260: <br><b>261: writeOutput(request.iqLib.RenderContent());</b><br>262: }<br>263: }<br>
codePrintPlain
string259: local.url.process(cgi.path_info);260: 261: writeOutput(request.iqLib.RenderContent());262: }263: }
column
number0
id
string??
line
number261
Raw_Trace
stringapplication_cfc$cf.udfCall(/Application.cfc:261)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string

Real Estate by IQWeb_pender

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, '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.5000
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:834)at lucee.runtime.tag.Query.doEndTag(Query.java:594)at org.lucee.cfml.base_cfc$cf.udfCall1(/org/lucee/cfml/Base.cfc:110)at org.lucee.cfml.base_cfc$cf.udfCall(/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:772)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599)at org.lucee.cfml.query_cfc$cf.udfCall(/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:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1934)at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:814)at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1614)at iqquery_cfc$cf.udfCall1(/iqquery.cfc:232)at iqquery_cfc$cf.udfCall(/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:696)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1917)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599)at iqquery_cfc$cf.udfCall1(/iqquery.cfc:141)at iqquery_cfc$cf.udfCall(/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:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1934)at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:563)at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:205)at components.listings_cfc$cf.udfCall2(/components/listings.cfc:1658)at components.listings_cfc$cf.udfCall(/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:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1930)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(/iqapp_mappath/iqweb/app/_real-estate.cfm:280)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:918)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:833)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:828)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:819)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:82)at lib.iq_cfc$cf.udfCall(/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:696)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1917)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599)at iqweb.sitetemplates._06.layouts._site_cfm$cf.call(/iqapp_mappath/iqweb/sitetemplates/06/layouts/_site.cfm:198)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:918)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:833)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:828)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:819)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:61)at lib.iq_cfc$cf.udfCall(/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:772)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:42)at lib.iq_cfc$cf.udfCall(/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:696)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1917)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:753)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1599)at application_cfc$cf.udfCall(/Application.cfc:261)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:696)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:579)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1917)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:2293)at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2284)at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2252)at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:891)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.GeneratedMethodAccessor36.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
string
codePrintPlain
string
column
number0
id
string??
line
number110
Raw_Trace
stringorg.lucee.cfml.base_cfc$cf.udfCall1(/org/lucee/cfml/Base.cfc:110)
template
string/org/lucee/cfml/Base.cfc
type
stringcfml
2
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number53
Raw_Trace
stringorg.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:53)
template
string/org/lucee/cfml/Query.cfc
type
stringcfml
3
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number232
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:232)
template
string/iqquery.cfc
type
stringcfml
4
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number141
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:141)
template
string/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(/components/listings.cfc:1658)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
6
Struct
codePrintHTML
string278: &lt;cfinvokeargument name=&quot;layout&quot; value=&quot;list_field&quot;&gt;<br>279: &lt;cfinvokeargument name=&quot;field&quot; value=&quot;#field#&quot;&gt;<br><b>280: &lt;/cfinvoke&gt;</b><br>281: <br>282: &lt;cfif retFieldData.status neq 0&gt;<br>
codePrintPlain
string278: <cfinvokeargument name="layout" value="list_field">279: <cfinvokeargument name="field" value="#field#">280: </cfinvoke>281: 282: <cfif retFieldData.status neq 0>
column
number0
id
string??
line
number280
Raw_Trace
stringiqweb.app._real_estate_cfm270$cf.call(/iqapp_mappath/iqweb/app/_real-estate.cfm:280)
template
stringC:\realistiq\production\iqweb\app\_real-estate.cfm
type
stringcfml
7
Struct
codePrintHTML
string80: <br>81: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/app/_#local.PageName#.cfm&quot;)&gt;<br><b>82: &lt;cfinclude template=&quot;#request.AppMapPath#/app/_#local.PageName#.cfm&quot; /&gt;</b><br>83: &lt;cfelse&gt;<br>84: &lt;cfset MissingFile = local.PageName&gt;<br>
codePrintPlain
string80: 81: <cfif FileExists("#request.AppAbsolutePath#/app/_#local.PageName#.cfm")>82: <cfinclude template="#request.AppMapPath#/app/_#local.PageName#.cfm" />83: <cfelse>84: <cfset MissingFile = local.PageName>
column
number0
id
string??
line
number82
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:82)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
8
Struct
codePrintHTML
string196: <br>197: &lt;div class=&quot;#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#&quot;&gt;<br><b>198: #REQUEST.iqLib.RenderPage()#</b><br>199: &lt;/div&gt;<br>200: &lt;/div&gt;<br>
codePrintPlain
string196: 197: <div class="#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#">198: #REQUEST.iqLib.RenderPage()#199: </div>200: </div>
column
number0
id
string??
line
number198
Raw_Trace
stringiqweb.sitetemplates._06.layouts._site_cfm$cf.call(/iqapp_mappath/iqweb/sitetemplates/06/layouts/_site.cfm:198)
template
stringC:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm
type
stringcfml
9
Struct
codePrintHTML
string59: &lt;cfelse&gt;<br>60: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot;)&gt;<br><b>61: &lt;cfinclude template=&quot;#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot; /&gt;</b><br>62: &lt;cfelse&gt;<br>63: &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
string59: <cfelse>60: <cfif FileExists("#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm")>61: <cfinclude template="#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm" />62: <cfelse>63: <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
number61
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:61)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
10
Struct
codePrintHTML
string40: <br>41: &lt;cfscript&gt;<br><b>42: doLayout();</b><br>43: &lt;/cfscript&gt;<br>44: &lt;/cfif&gt;<br>
codePrintPlain
string40: 41: <cfscript>42: doLayout();43: </cfscript>44: </cfif>
column
number0
id
string??
line
number42
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:42)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
11
Struct
codePrintHTML
string259: local.url.process(cgi.path_info);<br>260: <br><b>261: writeOutput(request.iqLib.RenderContent());</b><br>262: }<br>263: }<br>
codePrintPlain
string259: local.url.process(cgi.path_info);260: 261: writeOutput(request.iqLib.RenderContent());262: }263: }
column
number0
id
string??
line
number261
Raw_Trace
stringapplication_cfc$cf.udfCall(/Application.cfc:261)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string
Real Estate Links Our Domains