Catch
Entries: 15
additional
Struct
SQL
stringselect data.*, sold_data.sold_count, median_data.median_dom, median_data.median_sq_foot, median_data.median_list_price, median_data.median_saleprice, median_data.median_list_ppsqf, median_data.median_sale_ppsqffrom (select sum(fieldcount) as fieldcount, field, fielddata, avg(avg_list_price) as avg_list_price, avg(avg_ppsqf) as avg_ppsqf, avg(avg_dom) as avg_dom, avg(avg_sq_foot) as avg_sq_footfrom (select count(listingid) as fieldcount, 'mls_ncregional' as mlsid, '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 [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (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, 'mls_ncregional' as mlsid, 'brunswick' as field, brunswick as fielddatafrom [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (saleprice != 0)and (deleteflag = 'y')and (len(brunswick) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2016%')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 [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (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.2000
DriverName
stringMicrosoft JDBC Driver 4.1 for SQL Server
DriverVersion
string4.1.5605.100
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, 'mls_ncregional' as mlsid, '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 [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (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, 'mls_ncregional' as mlsid, 'brunswick' as field, brunswick as fielddatafrom [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (saleprice != 0)and (deleteflag = 'y')and (len(brunswick) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2016%')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 [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (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, 'mls_ncregional' as mlsid, '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 [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (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, 'mls_ncregional' as mlsid, 'brunswick' as field, brunswick as fielddatafrom [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (saleprice != 0)and (deleteflag = 'y')and (len(brunswick) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2016%')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 [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (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
stringat com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216):216at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1522):1522at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404):404at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350):350at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696):5696at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1716):1716at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180):180at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155):155at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332):332at lucee.runtime.db.driver.state.StateUtil.execute(StateUtil.java:145):145at lucee.runtime.db.driver.state.StatePreparedStatement.execute(StatePreparedStatement.java:135):135at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:240):240at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:252):252at lucee.runtime.tag.Query.executeDatasoure(Query.java:802):802at lucee.runtime.tag.Query.doEndTag(Query.java:604):604at org.lucee.cfml.base_cfc$cf.udfCall1(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc:163):163at org.lucee.cfml.base_cfc$cf.udfCall(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:766):766at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593at org.lucee.cfml.query_cfc$cf.udfCall(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Query.cfc:53):53at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1778):1778at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1603):1603at iqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc:222):222at iqquery_cfc$cf.udfCall(C:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593at iqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc:127):127at iqquery_cfc$cf.udfCall(C:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1778):1778at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:562):562at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:204):204at components.listings_cfc$cf.udfCall2(C:\realistiq\production\iqweb\components\listings.cfc:1642):1642at components.listings_cfc$cf.udfCall(C:\realistiq\production\iqweb\components\listings.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1774):1774at lucee.runtime.tag.Invoke.doComponent(Invoke.java:221):221at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:194):194at iqweb.app._real_estate_cfm270$cf.call(C:\realistiq\production\iqweb\app\_real-estate.cfm:236):236at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:954):954at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:858):858at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:80):80at lib.iq_cfc$cf.udfCall(C:\realistiq\production\iqweb\lib\iq.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593at iqweb.sitetemplates._06.layouts._site_cfm$cf.call(C:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm:161):161at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:954):954at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:858):858at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:51):51at lib.iq_cfc$cf.udfCall(C:\realistiq\production\iqweb\lib\iq.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:766):766at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:33):33at lib.iq_cfc$cf.udfCall(C:\realistiq\production\iqweb\lib\iq.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593at application_cfc$cf.udfCall(C:\realistiq\production\iqweb\application.cfc:243):243at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:414):414at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:223):223at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:37):37at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2265):2265at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2228):2228at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:456):456at lucee.loader.servlet.CFMLServlet.service(Unknown Source):-1at javax.servlet.http.HttpServlet.service(HttpServlet.java:848):848at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684):684at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501):501at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137):137at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557):557at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231):231at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086):1086at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:428):428at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193):193at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020):1020at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135):135at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:245):245at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154):154at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116):116at org.eclipse.jetty.server.Server.handle(Server.java:370):370at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494):494at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:971):971at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1033):1033at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644):644at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235):235at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82):82at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:667):667at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52):52at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608):608at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543):543at java.lang.Thread.run(Thread.java:745):745
TagContext
Array
Rows: 11
1
Struct
codePrintHTML
string161: !---&gt;&lt;cfqueryparam attributecollection=&quot;#item#&quot;&gt;&lt;!---<br>162: !---&gt;&lt;/cfif&gt;&lt;/cfloop&gt;<br><b>163: &lt;/cfquery&gt;</b><br>164: <br>165: &lt;cfset result.setResult(q)&gt;<br>
codePrintPlain
string161: !---><cfqueryparam attributecollection="#item#"><!---162: !---></cfif></cfloop>163: </cfquery>164: 165: <cfset result.setResult(q)>
column
number0
id
string??
line
number163
Raw_Trace
stringorg.lucee.cfml.base_cfc$cf.udfCall1(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc:163)
template
stringC:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc
type
stringcfml
2
Struct
codePrintHTML
string51: <br>52: // invoke the query and return the result<br><b>53: return invokeTag();</b><br>54: }<br>55: <br>
codePrintPlain
string51: 52: // invoke the query and return the result53: return invokeTag();54: }55:
column
number0
id
string??
line
number53
Raw_Trace
stringorg.lucee.cfml.query_cfc$cf.udfCall(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Query.cfc:53)
template
stringC:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Query.cfc
type
stringcfml
3
Struct
codePrintHTML
string220: }<br>221: <br><b>222: local.query = local.queryservice.execute(sql=this['sql']);</b><br>223: <br>224: local.recordset = local.query.getResult();<br>
codePrintPlain
string220: }221: 222: local.query = local.queryservice.execute(sql=this['sql']);223: 224: local.recordset = local.query.getResult();
column
number0
id
string??
line
number222
Raw_Trace
stringiqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc:222)
template
stringC:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc
type
stringcfml
4
Struct
codePrintHTML
string125: this['sql'] = arguments.generatedcontent;<br>126: <br><b>127: local.retQuery = this.query();</b><br>128: <br>129: StructDelete(arguments, &quot;generatedcontent&quot;);<br>
codePrintPlain
string125: this['sql'] = arguments.generatedcontent;126: 127: local.retQuery = this.query();128: 129: StructDelete(arguments, "generatedcontent");
column
number0
id
string??
line
number127
Raw_Trace
stringiqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc:127)
template
stringC:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc
type
stringcfml
5
Struct
codePrintHTML
string1640: <br>1641: #ListLast(arguments.mlsid) neq currmlsid ? 'union' : ''#<br><b>1642: &lt;/cfloop&gt;</b><br>1643: ) data_union<br>1644: <br>
codePrintPlain
string1640: 1641: #ListLast(arguments.mlsid) neq currmlsid ? 'union' : ''#1642: </cfloop>1643: ) data_union1644:
column
number0
id
string??
line
number1642
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2(C:\realistiq\production\iqweb\components\listings.cfc:1642)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
6
Struct
codePrintHTML
string234: &lt;cfinvokeargument name=&quot;layout&quot; value=&quot;list_field&quot;&gt;<br>235: &lt;cfinvokeargument name=&quot;field&quot; value=&quot;#field#&quot;&gt;<br><b>236: &lt;/cfinvoke&gt;</b><br>237: <br>238: &lt;cfif retFieldData.status neq 0&gt;<br>
codePrintPlain
string234: <cfinvokeargument name="layout" value="list_field">235: <cfinvokeargument name="field" value="#field#">236: </cfinvoke>237: 238: <cfif retFieldData.status neq 0>
column
number0
id
string??
line
number236
Raw_Trace
stringiqweb.app._real_estate_cfm270$cf.call(C:\realistiq\production\iqweb\app\_real-estate.cfm:236)
template
stringC:\realistiq\production\iqweb\app\_real-estate.cfm
type
stringcfml
7
Struct
codePrintHTML
string78: &lt;cfelse&gt;<br>79: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/app/_#local.PageName#.cfm&quot;)&gt;<br><b>80: &lt;cfsavecontent variable=&quot;local.retVal&quot;&gt;&lt;cfinclude template=&quot;#request.AppMapPath#/app/_#local.PageName#.cfm&quot; /&gt;&lt;/cfsavecontent&gt;</b><br>81: &lt;cfelse&gt;<br>82: &lt;cfset MissingFile = local.PageName&gt;<br>
codePrintPlain
string78: <cfelse>79: <cfif FileExists("#request.AppAbsolutePath#/app/_#local.PageName#.cfm")>80: <cfsavecontent variable="local.retVal"><cfinclude template="#request.AppMapPath#/app/_#local.PageName#.cfm" /></cfsavecontent>81: <cfelse>82: <cfset MissingFile = local.PageName>
column
number0
id
string??
line
number80
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:80)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
8
Struct
codePrintHTML
string159: <br>160: &lt;div class=&quot;#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#&quot;&gt;<br><b>161: #REQUEST.iqLib.RenderPage()#</b><br>162: &lt;/div&gt;<br>163: &lt;/div&gt;<br>
codePrintPlain
string159: 160: <div class="#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#">161: #REQUEST.iqLib.RenderPage()#162: </div>163: </div>
column
number0
id
string??
line
number161
Raw_Trace
stringiqweb.sitetemplates._06.layouts._site_cfm$cf.call(C:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm:161)
template
stringC:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm
type
stringcfml
9
Struct
codePrintHTML
string49: &lt;cfsavecontent variable=&quot;local.retVal&quot;&gt;&lt;cfinclude template=&quot;#request.CustomMapPath#/layouts/_#local.Layout#.cfm&quot; /&gt;&lt;/cfsavecontent&gt;<br>50: &lt;cfelseif FileExists(&quot;#request.AppAbsolutePath#/sitetemplates/#request.DOMAIN.TemplateName#/layouts/_#local.Layout#.cfm&quot;)&gt;<br><b>51: &lt;cfsavecontent variable=&quot;local.retVal&quot;&gt;&lt;cfinclude template=&quot;#request.AppMapPath#/sitetemplates/#request.DOMAIN.TemplateName#/layouts/_#local.Layout#.cfm&quot; /&gt;&lt;/cfsavecontent&gt;</b><br>52: &lt;cfelse&gt;<br>53: &lt;cfset local.retVal = &quot;&lt;strong&gt;File Not Found.&lt;/strong&gt;&lt;br&gt;The file &amp;quot;&lt;em&gt;#request.AppAbsolutePath#/sitetemplates/#request.DOMAIN.TemplateName#/layouts/_#local.Layout#.cfm&lt;/em&gt;&amp;quot; could not be found.&quot;&gt;<br>
codePrintPlain
string49: <cfsavecontent variable="local.retVal"><cfinclude template="#request.CustomMapPath#/layouts/_#local.Layout#.cfm" /></cfsavecontent>50: <cfelseif FileExists("#request.AppAbsolutePath#/sitetemplates/#request.DOMAIN.TemplateName#/layouts/_#local.Layout#.cfm")>51: <cfsavecontent variable="local.retVal"><cfinclude template="#request.AppMapPath#/sitetemplates/#request.DOMAIN.TemplateName#/layouts/_#local.Layout#.cfm" /></cfsavecontent>52: <cfelse>53: <cfset local.retVal = "<strong>File Not Found.</strong><br>The file &quot;<em>#request.AppAbsolutePath#/sitetemplates/#request.DOMAIN.TemplateName#/layouts/_#local.Layout#.cfm</em>&quot; could not be found.">
column
number0
id
string??
line
number51
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:51)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
10
Struct
codePrintHTML
string31: &lt;/cfif&gt;<br>32: <br><b>33: &lt;cfreturn doLayout()&gt;</b><br>34: &lt;/cfif&gt;<br>35: &lt;/cffunction&gt;<br>
codePrintPlain
string31: </cfif>32: 33: <cfreturn doLayout()>34: </cfif>35: </cffunction>
column
number0
id
string??
line
number33
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:33)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
11
Struct
codePrintHTML
string241: }<br>242: <br><b>243: writeOutput(request.iqLib.RenderContent());</b><br>244: }<br>245: }<br>
codePrintPlain
string241: }242: 243: writeOutput(request.iqLib.RenderContent());244: }245: }
column
number0
id
string??
line
number243
Raw_Trace
stringapplication_cfc$cf.udfCall(C:\realistiq\production\iqweb\application.cfc:243)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string

Real Estate by IQWeb_brunswick

Catch
Entries: 15
additional
Struct
SQL
stringselect data.*, sold_data.sold_count, median_data.median_dom, median_data.median_sq_foot, median_data.median_list_price, median_data.median_saleprice, median_data.median_list_ppsqf, median_data.median_sale_ppsqffrom (select sum(fieldcount) as fieldcount, field, fielddata, avg(avg_list_price) as avg_list_price, avg(avg_ppsqf) as avg_ppsqf, avg(avg_dom) as avg_dom, avg(avg_sq_foot) as avg_sq_footfrom (select count(listingid) as fieldcount, 'mls_ncregional' as mlsid, '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 [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (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, 'mls_ncregional' as mlsid, 'brunswick' as field, brunswick as fielddatafrom [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (saleprice != 0)and (deleteflag = 'y')and (len(brunswick) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2016%')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 [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (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.2000
DriverName
stringMicrosoft JDBC Driver 4.1 for SQL Server
DriverVersion
string4.1.5605.100
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, 'mls_ncregional' as mlsid, '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 [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (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, 'mls_ncregional' as mlsid, 'brunswick' as field, brunswick as fielddatafrom [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (saleprice != 0)and (deleteflag = 'y')and (len(brunswick) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2016%')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 [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (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, 'mls_ncregional' as mlsid, '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 [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (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, 'mls_ncregional' as mlsid, 'brunswick' as field, brunswick as fielddatafrom [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (saleprice != 0)and (deleteflag = 'y')and (len(brunswick) > 1)and (propertytype in ('Residential','Commercial','Land','MultiFamily'))and (datetime like '2016%')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 [data-5].[mls_ncregional].[dbo].listings WITH (NOLOCK)where (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
stringat com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216):216at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1522):1522at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404):404at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350):350at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696):5696at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1716):1716at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180):180at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155):155at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332):332at lucee.runtime.db.driver.state.StateUtil.execute(StateUtil.java:145):145at lucee.runtime.db.driver.state.StatePreparedStatement.execute(StatePreparedStatement.java:135):135at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:240):240at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:252):252at lucee.runtime.tag.Query.executeDatasoure(Query.java:802):802at lucee.runtime.tag.Query.doEndTag(Query.java:604):604at org.lucee.cfml.base_cfc$cf.udfCall1(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc:163):163at org.lucee.cfml.base_cfc$cf.udfCall(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:766):766at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593at org.lucee.cfml.query_cfc$cf.udfCall(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Query.cfc:53):53at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1778):1778at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1603):1603at iqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc:222):222at iqquery_cfc$cf.udfCall(C:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593at iqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc:127):127at iqquery_cfc$cf.udfCall(C:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1778):1778at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:562):562at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:204):204at components.listings_cfc$cf.udfCall2(C:\realistiq\production\iqweb\components\listings.cfc:1642):1642at components.listings_cfc$cf.udfCall(C:\realistiq\production\iqweb\components\listings.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1774):1774at lucee.runtime.tag.Invoke.doComponent(Invoke.java:221):221at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:194):194at iqweb.app._real_estate_cfm270$cf.call(C:\realistiq\production\iqweb\app\_real-estate.cfm:236):236at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:954):954at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:858):858at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:80):80at lib.iq_cfc$cf.udfCall(C:\realistiq\production\iqweb\lib\iq.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593at iqweb.sitetemplates._06.layouts._site_cfm$cf.call(C:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm:161):161at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:954):954at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:858):858at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:51):51at lib.iq_cfc$cf.udfCall(C:\realistiq\production\iqweb\lib\iq.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:766):766at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:33):33at lib.iq_cfc$cf.udfCall(C:\realistiq\production\iqweb\lib\iq.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593at application_cfc$cf.udfCall(C:\realistiq\production\iqweb\application.cfc:243):243at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:414):414at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:223):223at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:37):37at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2265):2265at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2228):2228at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:456):456at lucee.loader.servlet.CFMLServlet.service(Unknown Source):-1at javax.servlet.http.HttpServlet.service(HttpServlet.java:848):848at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684):684at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501):501at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137):137at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557):557at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231):231at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086):1086at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:428):428at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193):193at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020):1020at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135):135at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:245):245at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154):154at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116):116at org.eclipse.jetty.server.Server.handle(Server.java:370):370at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494):494at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:971):971at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1033):1033at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644):644at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235):235at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82):82at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:667):667at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52):52at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608):608at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543):543at java.lang.Thread.run(Thread.java:745):745
TagContext
Array
Rows: 11
1
Struct
codePrintHTML
string161: !---&gt;&lt;cfqueryparam attributecollection=&quot;#item#&quot;&gt;&lt;!---<br>162: !---&gt;&lt;/cfif&gt;&lt;/cfloop&gt;<br><b>163: &lt;/cfquery&gt;</b><br>164: <br>165: &lt;cfset result.setResult(q)&gt;<br>
codePrintPlain
string161: !---><cfqueryparam attributecollection="#item#"><!---162: !---></cfif></cfloop>163: </cfquery>164: 165: <cfset result.setResult(q)>
column
number0
id
string??
line
number163
Raw_Trace
stringorg.lucee.cfml.base_cfc$cf.udfCall1(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc:163)
template
stringC:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc
type
stringcfml
2
Struct
codePrintHTML
string51: <br>52: // invoke the query and return the result<br><b>53: return invokeTag();</b><br>54: }<br>55: <br>
codePrintPlain
string51: 52: // invoke the query and return the result53: return invokeTag();54: }55:
column
number0
id
string??
line
number53
Raw_Trace
stringorg.lucee.cfml.query_cfc$cf.udfCall(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Query.cfc:53)
template
stringC:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Query.cfc
type
stringcfml
3
Struct
codePrintHTML
string220: }<br>221: <br><b>222: local.query = local.queryservice.execute(sql=this['sql']);</b><br>223: <br>224: local.recordset = local.query.getResult();<br>
codePrintPlain
string220: }221: 222: local.query = local.queryservice.execute(sql=this['sql']);223: 224: local.recordset = local.query.getResult();
column
number0
id
string??
line
number222
Raw_Trace
stringiqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc:222)
template
stringC:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc
type
stringcfml
4
Struct
codePrintHTML
string125: this['sql'] = arguments.generatedcontent;<br>126: <br><b>127: local.retQuery = this.query();</b><br>128: <br>129: StructDelete(arguments, &quot;generatedcontent&quot;);<br>
codePrintPlain
string125: this['sql'] = arguments.generatedcontent;126: 127: local.retQuery = this.query();128: 129: StructDelete(arguments, "generatedcontent");
column
number0
id
string??
line
number127
Raw_Trace
stringiqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc:127)
template
stringC:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc
type
stringcfml
5
Struct
codePrintHTML
string1640: <br>1641: #ListLast(arguments.mlsid) neq currmlsid ? 'union' : ''#<br><b>1642: &lt;/cfloop&gt;</b><br>1643: ) data_union<br>1644: <br>
codePrintPlain
string1640: 1641: #ListLast(arguments.mlsid) neq currmlsid ? 'union' : ''#1642: </cfloop>1643: ) data_union1644:
column
number0
id
string??
line
number1642
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2(C:\realistiq\production\iqweb\components\listings.cfc:1642)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
6
Struct
codePrintHTML
string234: &lt;cfinvokeargument name=&quot;layout&quot; value=&quot;list_field&quot;&gt;<br>235: &lt;cfinvokeargument name=&quot;field&quot; value=&quot;#field#&quot;&gt;<br><b>236: &lt;/cfinvoke&gt;</b><br>237: <br>238: &lt;cfif retFieldData.status neq 0&gt;<br>
codePrintPlain
string234: <cfinvokeargument name="layout" value="list_field">235: <cfinvokeargument name="field" value="#field#">236: </cfinvoke>237: 238: <cfif retFieldData.status neq 0>
column
number0
id
string??
line
number236
Raw_Trace
stringiqweb.app._real_estate_cfm270$cf.call(C:\realistiq\production\iqweb\app\_real-estate.cfm:236)
template
stringC:\realistiq\production\iqweb\app\_real-estate.cfm
type
stringcfml
7
Struct
codePrintHTML
string78: &lt;cfelse&gt;<br>79: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/app/_#local.PageName#.cfm&quot;)&gt;<br><b>80: &lt;cfsavecontent variable=&quot;local.retVal&quot;&gt;&lt;cfinclude template=&quot;#request.AppMapPath#/app/_#local.PageName#.cfm&quot; /&gt;&lt;/cfsavecontent&gt;</b><br>81: &lt;cfelse&gt;<br>82: &lt;cfset MissingFile = local.PageName&gt;<br>
codePrintPlain
string78: <cfelse>79: <cfif FileExists("#request.AppAbsolutePath#/app/_#local.PageName#.cfm")>80: <cfsavecontent variable="local.retVal"><cfinclude template="#request.AppMapPath#/app/_#local.PageName#.cfm" /></cfsavecontent>81: <cfelse>82: <cfset MissingFile = local.PageName>
column
number0
id
string??
line
number80
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:80)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
8
Struct
codePrintHTML
string159: <br>160: &lt;div class=&quot;#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#&quot;&gt;<br><b>161: #REQUEST.iqLib.RenderPage()#</b><br>162: &lt;/div&gt;<br>163: &lt;/div&gt;<br>
codePrintPlain
string159: 160: <div class="#request.page eq 'listings' or request.page eq 'rentals'? 'container-fluid' : 'container'#">161: #REQUEST.iqLib.RenderPage()#162: </div>163: </div>
column
number0
id
string??
line
number161
Raw_Trace
stringiqweb.sitetemplates._06.layouts._site_cfm$cf.call(C:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm:161)
template
stringC:\realistiq\production\iqweb\sitetemplates\06\layouts\_site.cfm
type
stringcfml
9
Struct
codePrintHTML
string49: &lt;cfsavecontent variable=&quot;local.retVal&quot;&gt;&lt;cfinclude template=&quot;#request.CustomMapPath#/layouts/_#local.Layout#.cfm&quot; /&gt;&lt;/cfsavecontent&gt;<br>50: &lt;cfelseif FileExists(&quot;#request.AppAbsolutePath#/sitetemplates/#request.DOMAIN.TemplateName#/layouts/_#local.Layout#.cfm&quot;)&gt;<br><b>51: &lt;cfsavecontent variable=&quot;local.retVal&quot;&gt;&lt;cfinclude template=&quot;#request.AppMapPath#/sitetemplates/#request.DOMAIN.TemplateName#/layouts/_#local.Layout#.cfm&quot; /&gt;&lt;/cfsavecontent&gt;</b><br>52: &lt;cfelse&gt;<br>53: &lt;cfset local.retVal = &quot;&lt;strong&gt;File Not Found.&lt;/strong&gt;&lt;br&gt;The file &amp;quot;&lt;em&gt;#request.AppAbsolutePath#/sitetemplates/#request.DOMAIN.TemplateName#/layouts/_#local.Layout#.cfm&lt;/em&gt;&amp;quot; could not be found.&quot;&gt;<br>
codePrintPlain
string49: <cfsavecontent variable="local.retVal"><cfinclude template="#request.CustomMapPath#/layouts/_#local.Layout#.cfm" /></cfsavecontent>50: <cfelseif FileExists("#request.AppAbsolutePath#/sitetemplates/#request.DOMAIN.TemplateName#/layouts/_#local.Layout#.cfm")>51: <cfsavecontent variable="local.retVal"><cfinclude template="#request.AppMapPath#/sitetemplates/#request.DOMAIN.TemplateName#/layouts/_#local.Layout#.cfm" /></cfsavecontent>52: <cfelse>53: <cfset local.retVal = "<strong>File Not Found.</strong><br>The file &quot;<em>#request.AppAbsolutePath#/sitetemplates/#request.DOMAIN.TemplateName#/layouts/_#local.Layout#.cfm</em>&quot; could not be found.">
column
number0
id
string??
line
number51
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:51)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
10
Struct
codePrintHTML
string31: &lt;/cfif&gt;<br>32: <br><b>33: &lt;cfreturn doLayout()&gt;</b><br>34: &lt;/cfif&gt;<br>35: &lt;/cffunction&gt;<br>
codePrintPlain
string31: </cfif>32: 33: <cfreturn doLayout()>34: </cfif>35: </cffunction>
column
number0
id
string??
line
number33
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:33)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
11
Struct
codePrintHTML
string241: }<br>242: <br><b>243: writeOutput(request.iqLib.RenderContent());</b><br>244: }<br>245: }<br>
codePrintPlain
string241: }242: 243: writeOutput(request.iqLib.RenderContent());244: }245: }
column
number0
id
string??
line
number243
Raw_Trace
stringapplication_cfc$cf.udfCall(C:\realistiq\production\iqweb\application.cfc:243)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string