ID: | 021D75494A404995A71239712076D715 | SITE: | www.terrilawrencehomes.com | SERVER: | lvd-web-7 | DATA SERVER: | cust-sql-0 | COMPANY ID: | iq_cb_sea_coast | USER: | N/A | ACTING AS: | N/A | REFERER: | | REMOTE ADDRESS: | 3.236.86.184 | USER AGENT: | CCBot/2.0 (https://commoncrawl.org/faq/) | REQUEST URL: | http://www.terrilawrencehomes.com/for-sale/121-cellars-way-wallace-nc-28466/99-1238135 | DATE: | 10/06/2024 00:16:02 |
Catch Entries: 15 | additional | Struct (ordered) | SQL | string | select 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, 'communityname' as field, communityname 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(cast(sq_foot as bigint)) as avg_sq_footfrom listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (deleteflag = 'n')AND len(adddatetime) >= 8and (len(communityname) > 1)and (propertytype in ('Commercial','Land','MultiFamily','Residential'))and (communityname in ('River Landing'))group by communityname) 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, 'communityname' as field, communityname as fielddatafrom listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (saleprice != 0)and (deleteflag = 'y')AND len(adddatetime) >= 8and (len(communityname) > 1)and (propertytype in ('Commercial','Land','MultiFamily','Residential'))and (datetime like '2024%')and (communityname in ('River Landing'))group by communityname)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 communityname 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 communityname ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY communityname)from listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND deleteflag = 'n'AND len(adddatetime) >= 8AND sq_foot > 0AND len(communityname) > 1AND propertytype in ('Commercial','Land','MultiFamily','Residential')AND communityname in ('River Landing')) 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 | string | Microsoft SQL Server |
| DatabaseVersion | | DriverName | string | Microsoft JDBC Driver 12.2 for SQL Server |
| DriverVersion | | Datasource | |
| DataSource | | Detail | | ErrorCode | | Extended_Info | | ExtendedInfo | | Message | string | Could not complete cursor operation because the table schema changed after the cursor was declared. |
| NativeErrorCode | | queryError | string | select 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, 'communityname' as field, communityname 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(cast(sq_foot as bigint)) as avg_sq_footfrom listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (deleteflag = 'n')AND len(adddatetime) >= 8and (len(communityname) > 1)and (propertytype in ('Commercial','Land','MultiFamily','Residential'))and (communityname in ('River Landing'))group by communityname) 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, 'communityname' as field, communityname as fielddatafrom listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (saleprice != 0)and (deleteflag = 'y')AND len(adddatetime) >= 8and (len(communityname) > 1)and (propertytype in ('Commercial','Land','MultiFamily','Residential'))and (datetime like '2024%')and (communityname in ('River Landing'))group by communityname)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 communityname 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 communityname ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY communityname)from listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND deleteflag = 'n'AND len(adddatetime) >= 8AND sq_foot > 0AND len(communityname) > 1AND propertytype in ('Commercial','Land','MultiFamily','Residential')AND communityname in ('River Landing')) 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 | string | select 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, 'communityname' as field, communityname 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(cast(sq_foot as bigint)) as avg_sq_footfrom listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (deleteflag = 'n')AND len(adddatetime) >= 8and (len(communityname) > 1)and (propertytype in ('Commercial','Land','MultiFamily','Residential'))and (communityname in ('River Landing'))group by communityname) 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, 'communityname' as field, communityname as fielddatafrom listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND (saleprice != 0)and (deleteflag = 'y')AND len(adddatetime) >= 8and (len(communityname) > 1)and (propertytype in ('Commercial','Land','MultiFamily','Residential'))and (datetime like '2024%')and (communityname in ('River Landing'))group by communityname)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 communityname 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 communityname ORDER BY cast(list_price as bigint)), c = COUNT(listingid) OVER (PARTITION BY communityname)from listings WITH (NOLOCK)where mlsid in ('mls_ncregional')AND deleteflag = 'n'AND len(adddatetime) >= 8AND sq_foot > 0AND len(communityname) > 1AND propertytype in ('Commercial','Land','MultiFamily','Residential')AND communityname in ('River Landing')) 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 | | StackTrace | string | lucee.runtime.exp.DatabaseException: Could not complete cursor operation because the table schema changed after the cursor was declared.at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:305)at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer$FetchBufferTokenHandler.onEOF(SQLServerResultSet.java:5467)at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:138)at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:42)at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5542)at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1821)at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1105)at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:701)at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:304)at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235)at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135)at lucee.runtime.tag.Query._doEndTag(Query.java:700)at lucee.runtime.tag.Query.doEndTag(Query.java:566)at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:86)at iqquery_cfc$cf.udfCall1(/iqquery.cfc:247)at iqquery_cfc$cf.udfCall(/iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:786)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1775)at iqquery_cfc$cf.udfCall1(/iqquery.cfc:132)at iqquery_cfc$cf.udfCall(/iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952)at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:560)at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:206)at components.listings_cfc$cf$8.udfCall2_000129(/components/listings.cfc:4287)at components.listings_cfc$cf$8.udfCall2(/components/listings.cfc:4160)at components.listings_cfc$cf$8.udfCall(/components/listings.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1947)at lucee.runtime.tag.Invoke.doComponent(Invoke.java:209)at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:186)at components.listing_layout_cfc$cf.udfCall_000061(/components/listing_layout.cfc:3490)at components.listing_layout_cfc$cf.udfCall(/components/listing_layout.cfc:3243)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1947)at lucee.runtime.tag.Invoke.doComponent(Invoke.java:209)at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:186)at components.listing_cfc$cf.udfCall(/components/listing.cfc:155)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1947)at lucee.runtime.tag.Invoke.doComponent(Invoke.java:209)at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:186)at app._listing_cfm$cf$3.call(/app/_listing.cfm:27)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:87)at lib.iq_cfc$cf.udfCall(/lib/iq.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1775)at templates.homepage._04.layouts._site_cfm$cf$6.call(/templates/homepage/04/layouts/_site.cfm:191)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:48)at lib.iq_cfc$cf.udfCall(/lib/iq.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:786)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1775)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:28)at lib.iq_cfc$cf.udfCall(/lib/iq.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1775)at application_cfc$cf.udfCall(/application.cfc:246)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444)at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218)at lucee.runtime.listener.ModernAppListener.onRequest(ModernAppListener.java:107)at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493)at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478)at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449)at lucee.runtime.engine.Request.exe(Request.java:45)at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216)at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162)at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)at org.apache.tomcat.util.net.Nio2Endpoint$SocketProcessor.doRun(Nio2Endpoint.java:1713)at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)at org.apache.tomcat.util.net.AbstractEndpoint.processSocket(AbstractEndpoint.java:1265)at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:641)at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:619)at java.base/sun.nio.ch.Invoker.invokeUnchecked(Invoker.java:127)at java.base/sun.nio.ch.Invoker$2.run(Invoker.java:219)at java.base/sun.nio.ch.AsynchronousChannelGroupImpl$1.run(AsynchronousChannelGroupImpl.java:112)at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)at java.base/java.lang.Thread.run(Thread.java:829) |
| TagContext | Array Rows: 13 | 1 | Struct | codePrintHTML | | codePrintPlain | | column | | id | | line | | Raw_Trace | string | iqquery_cfc$cf.udfCall1(/iqquery.cfc:247) |
| template | | type | |
| 2 | Struct | codePrintHTML | | codePrintPlain | | column | | id | | line | | Raw_Trace | string | iqquery_cfc$cf.udfCall1(/iqquery.cfc:132) |
| template | | type | |
| 3 | Struct | codePrintHTML | string | 4285: <br>4286: order by data.fielddata<br><b>4287: </cfiqquery></b><br>4288: </cfoutput><br>4289: <br> |
| codePrintPlain | string | 4285: 4286: order by data.fielddata4287: </cfiqquery>4288: </cfoutput>4289: |
| column | | id | | line | | Raw_Trace | string | components.listings_cfc$cf$8.udfCall2_000129(/components/listings.cfc:4287) |
| template | string | C:\backatyou\code\sites\components\listings.cfc |
| type | |
| 4 | Struct | codePrintHTML | string | 4158: <cfset local.startRow = 1><br>4159: <br><b>4160: <cftry></b><br>4161: <cfoutput><br>4162: <br> |
| codePrintPlain | string | 4158: <cfset local.startRow = 1>4159: 4160: <cftry>4161: <cfoutput>4162: |
| column | | id | | line | | Raw_Trace | string | components.listings_cfc$cf$8.udfCall2(/components/listings.cfc:4160) |
| template | string | C:\backatyou\code\sites\components\listings.cfc |
| type | |
| 5 | Struct | codePrintHTML | string | 3488: <cfinvokeargument name="field" value="#local.field#"><br>3489: <cfinvokeargument name="fieldvalue" value="#local.fieldvalue#"><br><b>3490: <cfinvokeargument name="propertytype" value="#arguments.rsListings.propertytype#"></b><br>3491: <cfinvokeargument name="mlsid" value="#arguments.rsListings.mlsid#"><br>3492: </cfinvoke><br> |
| codePrintPlain | string | 3488: <cfinvokeargument name="field" value="#local.field#">3489: <cfinvokeargument name="fieldvalue" value="#local.fieldvalue#">3490: <cfinvokeargument name="propertytype" value="#arguments.rsListings.propertytype#">3491: <cfinvokeargument name="mlsid" value="#arguments.rsListings.mlsid#">3492: </cfinvoke> |
| column | | id | | line | | Raw_Trace | string | components.listing_layout_cfc$cf.udfCall_000061(/components/listing_layout.cfc:3490) |
| template | string | C:\backatyou\code\sites\components\listing_layout.cfc |
| type | |
| 6 | Struct | codePrintHTML | string | 3241: <br>3242: </cfif><br><b>3243: </cfif></b><br>3244: <br>3245: <!--- Open House Sidebar View ---><br> |
| codePrintPlain | string | 3241: 3242: </cfif>3243: </cfif>3244: 3245: <!--- Open House Sidebar View ---> |
| column | | id | | line | | Raw_Trace | string | components.listing_layout_cfc$cf.udfCall(/components/listing_layout.cfc:3243) |
| template | string | C:\backatyou\code\sites\components\listing_layout.cfc |
| type | |
| 7 | Struct | codePrintHTML | string | 153: <cfinvokeargument name="rsListings" value="#retListing.query#"><br>154: <cfinvokeargument name="view_from" value="#arguments.view_from#"><br><b>155: </cfinvoke></b><br>156: <cfelse><br>157: <cfinvoke component="listing_layout" method="NoRecords" returnvariable="LOCAL.retLayout"><br> |
| codePrintPlain | string | 153: <cfinvokeargument name="rsListings" value="#retListing.query#">154: <cfinvokeargument name="view_from" value="#arguments.view_from#">155: </cfinvoke>156: <cfelse>157: <cfinvoke component="listing_layout" method="NoRecords" returnvariable="LOCAL.retLayout"> |
| column | | id | | line | | Raw_Trace | string | components.listing_cfc$cf.udfCall(/components/listing.cfc:155) |
| template | string | C:\backatyou\code\sites\components\listing.cfc |
| type | |
| 8 | Struct | codePrintHTML | string | 25: <cfinvokeargument name="view_from" value="Listing Details Page"><br>26: <cfinvokeargument name="showdeleted" value="#structKeyExists(application.settings, 'showoffmarketlistings') && application.settings.showoffmarketlistings == 'F' ? 'F' : 'T'#"><br><b>27: <!--- <cfinvokeargument name="showdeleted" value="F"> ---></b><br>28: </cfinvoke><br>29: <br> |
| codePrintPlain | string | 25: <cfinvokeargument name="view_from" value="Listing Details Page">26: <cfinvokeargument name="showdeleted" value="#structKeyExists(application.settings, 'showoffmarketlistings') && application.settings.showoffmarketlistings == 'F' ? 'F' : 'T'#">27: <!--- <cfinvokeargument name="showdeleted" value="F"> --->28: </cfinvoke>29: |
| column | | id | | line | | Raw_Trace | string | app._listing_cfm$cf$3.call(/app/_listing.cfm:27) |
| template | string | C:\backatyou\code\sites\app\_listing.cfm |
| type | |
| 9 | Struct | codePrintHTML | string | 85: <cfelse> ---><br>86: <cfif fileExists("#request.appAbsolutePath#/app/_#local.PageName#.cfm")><br><b>87: <cfinclude template="/app/_#local.PageName#.cfm" /></b><br>88: <cfelse><br>89: <cfset MissingFile = local.PageName><br> |
| codePrintPlain | string | 85: <cfelse> --->86: <cfif fileExists("#request.appAbsolutePath#/app/_#local.PageName#.cfm")>87: <cfinclude template="/app/_#local.PageName#.cfm" />88: <cfelse>89: <cfset MissingFile = local.PageName> |
| column | | id | | line | | Raw_Trace | string | lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:87) |
| template | string | C:\backatyou\code\sites\lib\iq.cfc |
| type | |
| 10 | Struct | codePrintHTML | string | 189: </cfif><br>190: <div class="#request.page eq 'listings' or request.page eq 'rentals' or request.page eq 'house-value' ? 'container-fluid' : 'container'#"><br><b>191: #request.iqlib.RenderPage()#</b><br>192: </div><br>193: </div><br> |
| codePrintPlain | string | 189: </cfif>190: <div class="#request.page eq 'listings' or request.page eq 'rentals' or request.page eq 'house-value' ? 'container-fluid' : 'container'#">191: #request.iqlib.RenderPage()#192: </div>193: </div> |
| column | | id | | line | | Raw_Trace | string | templates.homepage._04.layouts._site_cfm$cf$6.call(/templates/homepage/04/layouts/_site.cfm:191) |
| template | string | C:\backatyou\code\sites\templates\homepage\04\layouts\_site.cfm |
| type | |
| 11 | Struct | codePrintHTML | string | 46: <cfif fileExists("#request.appAbsolutePath##request.domain.homepagetemplatepath#/layouts/_#local.Layout#.cfm")><br>47: <cfsavecontent variable="local.output"><br><b>48: <cfinclude template="#request.domain.homepagetemplatepath#/layouts/_#local.Layout#.cfm" /></b><br>49: <br>50: <cfset local.remote_addr = (StructKeyExists(GetHttpRequestData().headers, "x-ha-xff") ? ListFirst(GetHttpRequestData().headers["x-ha-xff"], ":") : (StructKeyExists(GetHttpRequestData().headers, "x-forwarded-for") ? ListFirst(GetHttpRequestData().headers["x-forwarded-for"], ":") : CGI.REMOTE_ADDR))><br> |
| codePrintPlain | string | 46: <cfif fileExists("#request.appAbsolutePath##request.domain.homepagetemplatepath#/layouts/_#local.Layout#.cfm")>47: <cfsavecontent variable="local.output">48: <cfinclude template="#request.domain.homepagetemplatepath#/layouts/_#local.Layout#.cfm" />49: 50: <cfset local.remote_addr = (StructKeyExists(GetHttpRequestData().headers, "x-ha-xff") ? ListFirst(GetHttpRequestData().headers["x-ha-xff"], ":") : (StructKeyExists(GetHttpRequestData().headers, "x-forwarded-for") ? ListFirst(GetHttpRequestData().headers["x-forwarded-for"], ":") : CGI.REMOTE_ADDR))> |
| column | | id | | line | | Raw_Trace | string | lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:48) |
| template | string | C:\backatyou\code\sites\lib\iq.cfc |
| type | |
| 12 | Struct | codePrintHTML | string | 26: </cfif><br>27: <cfscript><br><b>28: doLayout();</b><br>29: </cfscript><br>30: </cfif><br> |
| codePrintPlain | string | 26: </cfif>27: <cfscript>28: doLayout();29: </cfscript>30: </cfif> |
| column | | id | | line | | Raw_Trace | string | lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:28) |
| template | string | C:\backatyou\code\sites\lib\iq.cfc |
| type | |
| 13 | Struct | codePrintHTML | string | 244: <cfset local.url.process(CGI.path_info) /><br>245: <cfsavecontent variable="template_layout"><br><b>246: <cfoutput>#request.iqlib.RenderContent()#</cfoutput></b><br>247: </cfsavecontent><br>248: <br> |
| codePrintPlain | string | 244: <cfset local.url.process(CGI.path_info) />245: <cfsavecontent variable="template_layout">246: <cfoutput>#request.iqlib.RenderContent()#</cfoutput>247: </cfsavecontent>248: |
| column | | id | | line | | Raw_Trace | string | application_cfc$cf.udfCall(/application.cfc:246) |
| template | string | C:\backatyou\code\sites\application.cfc |
| type | |
|
| type | | where | |
|