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, 'brunswick' as field, brunswick 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 listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (deleteflag = 'n')and (len(brunswick) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))group by brunswick) 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, 'brunswick' as field, brunswick as fielddatafrom listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (saleprice != 0)and (deleteflag = 'y')and (len(brunswick) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2017%')group by brunswick)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 brunswick 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 brunswick ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY brunswick)from listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (deleteflag = 'n')and (len(brunswick) > 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.4621.201
Datasource
stringiq_cb_sea_coast
DataSource
stringiq_cb_sea_coast
Detail
stringInvalid column name 'brunswick'.
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, 'brunswick' as field, brunswick 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 listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (deleteflag = 'n')and (len(brunswick) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))group by brunswick) 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, 'brunswick' as field, brunswick as fielddatafrom listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (saleprice != 0)and (deleteflag = 'y')and (len(brunswick) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2017%')group by brunswick)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 brunswick 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 brunswick ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY brunswick)from listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (deleteflag = 'n')and (len(brunswick) > 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, 'brunswick' as field, brunswick 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 listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (deleteflag = 'n')and (len(brunswick) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))group by brunswick) 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, 'brunswick' as field, brunswick as fielddatafrom listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (saleprice != 0)and (deleteflag = 'y')and (len(brunswick) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2017%')group by brunswick)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 brunswick 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 brunswick ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY brunswick)from listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (deleteflag = 'n')and (len(brunswick) > 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 lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:301)at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:275)at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:221)at lucee.runtime.tag.Query.executeDatasoure(Query.java:839)at lucee.runtime.tag.Query.doEndTag(Query.java:597)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:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:772)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:755)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1685)at org.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:53)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:211)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1935)at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:825)at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1700)at iqquery_cfc$cf.udfCall1(/iqquery.cfc:232)at iqquery_cfc$cf.udfCall(/iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1918)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:755)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1685)at iqquery_cfc$cf.udfCall1(/iqquery.cfc:141)at iqquery_cfc$cf.udfCall(/iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:211)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1935)at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:568)at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:207)at components.listings_cfc$cf.udfCall2(/components/listings.cfc:1643)at components.listings_cfc$cf.udfCall(/components/listings.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:211)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1931)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:246)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:920)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:835)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:830)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:821)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:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1918)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:755)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1685)at iqweb.sitetemplates._06.layouts._site_cfm$cf.call(/iqapp_mappath/iqweb/sitetemplates/06/layouts/_site.cfm:216)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:920)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:835)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:830)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:821)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:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:772)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:755)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1685)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:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1918)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:755)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1685)at application_cfc$cf.udfCall(/Application.cfc:265)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1918)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:2380)at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2371)at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2339)at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:907)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 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
string1641: &lt;cfif arguments.fieldvalue neq ''&gt;and (#arguments.field# in (&lt;cfiqqueryparam value=&quot;#arguments.fieldvalue#&quot; cfsqltype=&quot;cf_sql_varchar&quot; list=&quot;true&quot;&gt;))&lt;/cfif&gt;<br>1642: <br><b>1643: group by #arguments.field#</b><br>1644: ) data_union<br>1645: <br>
codePrintPlain
string1641: <cfif arguments.fieldvalue neq ''>and (#arguments.field# in (<cfiqqueryparam value="#arguments.fieldvalue#" cfsqltype="cf_sql_varchar" list="true">))</cfif>1642: 1643: group by #arguments.field#1644: ) data_union1645:
column
number0
id
string??
line
number1643
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2(/components/listings.cfc:1643)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
6
Struct
codePrintHTML
string244: &lt;cfinvokeargument name=&quot;layout&quot; value=&quot;list_field&quot;&gt;<br>245: &lt;cfinvokeargument name=&quot;field&quot; value=&quot;#field#&quot;&gt;<br><b>246: &lt;/cfinvoke&gt;</b><br>247: <br>248: &lt;cfif retFieldData.status neq 0&gt;<br>
codePrintPlain
string244: <cfinvokeargument name="layout" value="list_field">245: <cfinvokeargument name="field" value="#field#">246: </cfinvoke>247: 248: <cfif retFieldData.status neq 0>
column
number0
id
string??
line
number246
Raw_Trace
stringiqweb.app._real_estate_cfm270$cf.call(/iqapp_mappath/iqweb/app/_real-estate.cfm:246)
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
string214: <br>215: &lt;div class=&quot;#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#&quot;&gt;<br><b>216: #REQUEST.iqLib.RenderPage()#</b><br>217: &lt;/div&gt;<br>218: &lt;/div&gt;<br>
codePrintPlain
string214: 215: <div class="#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#">216: #REQUEST.iqLib.RenderPage()#217: </div>218: </div>
column
number0
id
string??
line
number216
Raw_Trace
stringiqweb.sitetemplates._06.layouts._site_cfm$cf.call(/iqapp_mappath/iqweb/sitetemplates/06/layouts/_site.cfm:216)
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
string263: local.url.process(cgi.path_info);<br>264: <br><b>265: writeOutput(request.iqLib.RenderContent());</b><br>266: }<br>267: }<br>
codePrintPlain
string263: local.url.process(cgi.path_info);264: 265: writeOutput(request.iqLib.RenderContent());266: }267: }
column
number0
id
string??
line
number265
Raw_Trace
stringapplication_cfc$cf.udfCall(/Application.cfc:265)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string

Real Estate by IQWeb_brunswick

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, 'brunswick' as field, brunswick 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 listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (deleteflag = 'n')and (len(brunswick) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))group by brunswick) 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, 'brunswick' as field, brunswick as fielddatafrom listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (saleprice != 0)and (deleteflag = 'y')and (len(brunswick) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2017%')group by brunswick)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 brunswick 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 brunswick ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY brunswick)from listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (deleteflag = 'n')and (len(brunswick) > 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.4621.201
Datasource
stringiq_cb_sea_coast
DataSource
stringiq_cb_sea_coast
Detail
stringInvalid column name 'brunswick'.
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, 'brunswick' as field, brunswick 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 listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (deleteflag = 'n')and (len(brunswick) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))group by brunswick) 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, 'brunswick' as field, brunswick as fielddatafrom listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (saleprice != 0)and (deleteflag = 'y')and (len(brunswick) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2017%')group by brunswick)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 brunswick 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 brunswick ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY brunswick)from listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (deleteflag = 'n')and (len(brunswick) > 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, 'brunswick' as field, brunswick 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 listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (deleteflag = 'n')and (len(brunswick) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))group by brunswick) 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, 'brunswick' as field, brunswick as fielddatafrom listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (saleprice != 0)and (deleteflag = 'y')and (len(brunswick) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2017%')group by brunswick)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 brunswick 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 brunswick ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY brunswick)from listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (deleteflag = 'n')and (len(brunswick) > 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 lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:301)at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:275)at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:221)at lucee.runtime.tag.Query.executeDatasoure(Query.java:839)at lucee.runtime.tag.Query.doEndTag(Query.java:597)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:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:772)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:755)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1685)at org.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:53)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:211)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1935)at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:825)at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1700)at iqquery_cfc$cf.udfCall1(/iqquery.cfc:232)at iqquery_cfc$cf.udfCall(/iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1918)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:755)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1685)at iqquery_cfc$cf.udfCall1(/iqquery.cfc:141)at iqquery_cfc$cf.udfCall(/iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:211)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1935)at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:568)at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:207)at components.listings_cfc$cf.udfCall2(/components/listings.cfc:1643)at components.listings_cfc$cf.udfCall(/components/listings.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:211)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1931)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:246)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:920)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:835)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:830)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:821)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:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1918)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:755)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1685)at iqweb.sitetemplates._06.layouts._site_cfm$cf.call(/iqapp_mappath/iqweb/sitetemplates/06/layouts/_site.cfm:216)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:920)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:835)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:830)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:821)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:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:772)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:755)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1685)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:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1918)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:755)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1685)at application_cfc$cf.udfCall(/Application.cfc:265)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1918)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:2380)at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2371)at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2339)at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:907)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 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
string1641: &lt;cfif arguments.fieldvalue neq ''&gt;and (#arguments.field# in (&lt;cfiqqueryparam value=&quot;#arguments.fieldvalue#&quot; cfsqltype=&quot;cf_sql_varchar&quot; list=&quot;true&quot;&gt;))&lt;/cfif&gt;<br>1642: <br><b>1643: group by #arguments.field#</b><br>1644: ) data_union<br>1645: <br>
codePrintPlain
string1641: <cfif arguments.fieldvalue neq ''>and (#arguments.field# in (<cfiqqueryparam value="#arguments.fieldvalue#" cfsqltype="cf_sql_varchar" list="true">))</cfif>1642: 1643: group by #arguments.field#1644: ) data_union1645:
column
number0
id
string??
line
number1643
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2(/components/listings.cfc:1643)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
6
Struct
codePrintHTML
string244: &lt;cfinvokeargument name=&quot;layout&quot; value=&quot;list_field&quot;&gt;<br>245: &lt;cfinvokeargument name=&quot;field&quot; value=&quot;#field#&quot;&gt;<br><b>246: &lt;/cfinvoke&gt;</b><br>247: <br>248: &lt;cfif retFieldData.status neq 0&gt;<br>
codePrintPlain
string244: <cfinvokeargument name="layout" value="list_field">245: <cfinvokeargument name="field" value="#field#">246: </cfinvoke>247: 248: <cfif retFieldData.status neq 0>
column
number0
id
string??
line
number246
Raw_Trace
stringiqweb.app._real_estate_cfm270$cf.call(/iqapp_mappath/iqweb/app/_real-estate.cfm:246)
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
string214: <br>215: &lt;div class=&quot;#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#&quot;&gt;<br><b>216: #REQUEST.iqLib.RenderPage()#</b><br>217: &lt;/div&gt;<br>218: &lt;/div&gt;<br>
codePrintPlain
string214: 215: <div class="#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#">216: #REQUEST.iqLib.RenderPage()#217: </div>218: </div>
column
number0
id
string??
line
number216
Raw_Trace
stringiqweb.sitetemplates._06.layouts._site_cfm$cf.call(/iqapp_mappath/iqweb/sitetemplates/06/layouts/_site.cfm:216)
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
string263: local.url.process(cgi.path_info);<br>264: <br><b>265: writeOutput(request.iqLib.RenderContent());</b><br>266: }<br>267: }<br>
codePrintPlain
string263: local.url.process(cgi.path_info);264: 265: writeOutput(request.iqLib.RenderContent());266: }267: }
column
number0
id
string??
line
number265
Raw_Trace
stringapplication_cfc$cf.udfCall(/Application.cfc:265)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string