Lydia Vessels - Coldwell Banker Hearthside
SITE:lvessels.cbhre.com
SERVER:iq-web-3
DATA SERVER:cust-sql-3
COMPANY ID:iq_cb_hearthside
REFERER:
REMOTE ADDRESS:3.80.85.76
USER AGENT:CCBot/2.0 (https://commoncrawl.org/faq/)
REQUEST URL:http://lvessels.cbhre.com/real-estate/area
DATE:12/18/2018 21:55:14



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_ppsqf from ( 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_foot from ( select count(listingid) as fieldcount , 'area' as field , area 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_foot from listings WITH (NOLOCK) where mlsid in ('mls_gardenstate','mls_lehighvalley','mls_capemay','mls_jerseyshore','mls_bright','mls_bright_trend') AND (deleteflag = 'n') and (len(area) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) group by area ) data_union group by data_union.fielddata, data_union.field ) data left outer join ( select sum(sold_count) as sold_count , field , fielddata from ( select count(listingid) as sold_count , 'area' as field , area as fielddata from listings WITH (NOLOCK) where mlsid in ('mls_gardenstate','mls_lehighvalley','mls_capemay','mls_jerseyshore','mls_bright','mls_bright_trend') AND (saleprice != 0) and (deleteflag = 'y') and (len(area) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) and (datetime like '2018%') group by area )sold_union group by sold_union.fielddata, sold_union.field ) sold_data on sold_data.fielddata = data.fielddata left 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_ppsqf from ( select area 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 area ORDER BY cast(list_price as bigint)) , c = COUNT(listingid) OVER (PARTITION BY area) from listings WITH (NOLOCK) where mlsid in ('mls_gardenstate','mls_lehighvalley','mls_capemay','mls_jerseyshore','mls_bright','mls_bright_trend') AND (deleteflag = 'n') and (len(area) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) ) median_union where median_union.rn IN ((median_union.c + 1)/2, (median_union.c + 2)/2) group by median_union.fielddata ) median_data on median_data.fielddata = data.fielddata order by data.fielddata
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string13.00.1601
DriverName
stringMicrosoft JDBC Driver 6.2 for SQL Server
DriverVersion
string6.2.2.0
Datasource
stringiq_cb_hearthside
DataSource
stringiq_cb_hearthside
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringArithmetic overflow error converting expression to data type int.
NativeErrorCode
number8115
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_ppsqf from ( 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_foot from ( select count(listingid) as fieldcount , 'area' as field , area 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_foot from listings WITH (NOLOCK) where mlsid in ('mls_gardenstate','mls_lehighvalley','mls_capemay','mls_jerseyshore','mls_bright','mls_bright_trend') AND (deleteflag = 'n') and (len(area) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) group by area ) data_union group by data_union.fielddata, data_union.field ) data left outer join ( select sum(sold_count) as sold_count , field , fielddata from ( select count(listingid) as sold_count , 'area' as field , area as fielddata from listings WITH (NOLOCK) where mlsid in ('mls_gardenstate','mls_lehighvalley','mls_capemay','mls_jerseyshore','mls_bright','mls_bright_trend') AND (saleprice != 0) and (deleteflag = 'y') and (len(area) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) and (datetime like '2018%') group by area )sold_union group by sold_union.fielddata, sold_union.field ) sold_data on sold_data.fielddata = data.fielddata left 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_ppsqf from ( select area 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 area ORDER BY cast(list_price as bigint)) , c = COUNT(listingid) OVER (PARTITION BY area) from listings WITH (NOLOCK) where mlsid in ('mls_gardenstate','mls_lehighvalley','mls_capemay','mls_jerseyshore','mls_bright','mls_bright_trend') AND (deleteflag = 'n') and (len(area) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) ) median_union where median_union.rn IN ((median_union.c + 1)/2, (median_union.c + 2)/2) group by median_union.fielddata ) median_data on median_data.fielddata = data.fielddata order 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_ppsqf from ( 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_foot from ( select count(listingid) as fieldcount , 'area' as field , area 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_foot from listings WITH (NOLOCK) where mlsid in ('mls_gardenstate','mls_lehighvalley','mls_capemay','mls_jerseyshore','mls_bright','mls_bright_trend') AND (deleteflag = 'n') and (len(area) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) group by area ) data_union group by data_union.fielddata, data_union.field ) data left outer join ( select sum(sold_count) as sold_count , field , fielddata from ( select count(listingid) as sold_count , 'area' as field , area as fielddata from listings WITH (NOLOCK) where mlsid in ('mls_gardenstate','mls_lehighvalley','mls_capemay','mls_jerseyshore','mls_bright','mls_bright_trend') AND (saleprice != 0) and (deleteflag = 'y') and (len(area) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) and (datetime like '2018%') group by area )sold_union group by sold_union.fielddata, sold_union.field ) sold_data on sold_data.fielddata = data.fielddata left 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_ppsqf from ( select area 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 area ORDER BY cast(list_price as bigint)) , c = COUNT(listingid) OVER (PARTITION BY area) from listings WITH (NOLOCK) where mlsid in ('mls_gardenstate','mls_lehighvalley','mls_capemay','mls_jerseyshore','mls_bright','mls_bright_trend') AND (deleteflag = 'n') and (len(area) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) ) median_union where median_union.rn IN ((median_union.c + 1)/2, (median_union.c + 2)/2) group by median_union.fielddata ) median_data on median_data.fielddata = data.fielddata order by data.fielddata
SQLState
stringS0002
StackTrace
stringlucee.runtime.exp.DatabaseException: Arithmetic overflow error converting expression to data type int. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:6309) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1651) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:987) at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:470) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:290) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:226) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1133) at lucee.runtime.tag.Query._doEndTag(Query.java:693) at lucee.runtime.tag.Query.doEndTag(Query.java:583) at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:86) at iqquery_cfc$cf.udfCall1(/iqquery.cfc:265) at iqquery_cfc$cf.udfCall(/iqquery.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:692) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1725) at iqquery_cfc$cf.udfCall1(/iqquery.cfc:155) at iqquery_cfc$cf.udfCall(/iqquery.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:694) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2010) at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:569) at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:207) at components.listings_cfc$cf.udfCall2_000124(/components/listings.cfc:3335) at components.listings_cfc$cf.udfCall2(/components/listings.cfc:3227) at components.listings_cfc$cf.udfCall(/components/listings.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:694) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2006) at lucee.runtime.tag.Invoke.doComponent(Invoke.java:224) at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:197) at iqweb.app._real_estate_cfm270$cf.call(/production/iqweb/app/_real-estate.cfm:431) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:830) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:812) 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:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:692) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1725) at iqweb.sitetemplates._24.layouts._site_cfm$cf.call(/production/iqweb/sitetemplates/24/layouts/_site.cfm:326) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:830) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:812) at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:59) at lib.iq_cfc$cf.udfCall(/lib/iq.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:809) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1725) at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:39) at lib.iq_cfc$cf.udfCall(/lib/iq.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:692) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1725) at application_cfc$cf.udfCall(/application.cfc:307) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:692) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:438) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:216) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2480) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2470) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2443) at lucee.runtime.engine.Request.exe(Request.java:44) at lucee.runtime.engine.Request.run(Request.java:30)
TagContext
Array
1
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number265
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:265)
template
string/iqquery.cfc
type
stringcfml
2
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number155
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:155)
template
string/iqquery.cfc
type
stringcfml
3
Struct
codePrintHTML
string3333: <br> 3334: order by data.fielddata<br> <b>3335: &lt;/cfiqquery&gt;</b><br> 3336: &lt;/cfoutput&gt;<br> 3337: <br>
codePrintPlain
string3333: 3334: order by data.fielddata 3335: </cfiqquery> 3336: </cfoutput> 3337:
column
number0
id
string??
line
number3335
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2_000124(/components/listings.cfc:3335)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
4
Struct
codePrintHTML
string3225: &lt;cfset local.retVal.Content = &quot;&quot;&gt;<br> 3226: <br> <b>3227: &lt;cftry&gt;</b><br> 3228: &lt;cfoutput&gt;<br> 3229: <br>
codePrintPlain
string3225: <cfset local.retVal.Content = ""> 3226: 3227: <cftry> 3228: <cfoutput> 3229:
column
number0
id
string??
line
number3227
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2(/components/listings.cfc:3227)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
5
Struct
codePrintHTML
string429: &lt;cfinvokeargument name=&quot;layout&quot; value=&quot;list_field&quot;&gt;<br> 430: &lt;cfinvokeargument name=&quot;field&quot; value=&quot;#field#&quot;&gt;<br> <b>431: &lt;/cfinvoke&gt;</b><br> 432: <br> 433: &lt;cfif retFieldData.status neq 0&gt;<br>
codePrintPlain
string429: <cfinvokeargument name="layout" value="list_field"> 430: <cfinvokeargument name="field" value="#field#"> 431: </cfinvoke> 432: 433: <cfif retFieldData.status neq 0>
column
number0
id
string??
line
number431
Raw_Trace
stringiqweb.app._real_estate_cfm270$cf.call(/production/iqweb/app/_real-estate.cfm:431)
template
stringC:\realistiq\production\iqweb\app\_real-estate.cfm
type
stringcfml
6
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
7
Struct
codePrintHTML
string324: &lt;/cfif&gt;<br> 325: &lt;div class=&quot;#request.page eq 'listings' or request.page eq 'rentals' or request.page eq 'house-value' ? 'container-fluid' : 'container'#&quot;&gt;<br> <b>326: #request.iqlib.RenderPage()#</b><br> 327: &lt;/div&gt;<br> 328: &lt;/div&gt;<br>
codePrintPlain
string324: </cfif> 325: <div class="#request.page eq 'listings' or request.page eq 'rentals' or request.page eq 'house-value' ? 'container-fluid' : 'container'#"> 326: #request.iqlib.RenderPage()# 327: </div> 328: </div>
column
number0
id
string??
line
number326
Raw_Trace
stringiqweb.sitetemplates._24.layouts._site_cfm$cf.call(/production/iqweb/sitetemplates/24/layouts/_site.cfm:326)
template
stringC:\realistiq\production\iqweb\sitetemplates\24\layouts\_site.cfm
type
stringcfml
8
Struct
codePrintHTML
string57: &lt;cfelse&gt;<br> 58: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot;)&gt;<br> <b>59: &lt;cfinclude template=&quot;#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot; /&gt;</b><br> 60: &lt;cfelse&gt;<br> 61: &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
string57: <cfelse> 58: <cfif FileExists("#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm")> 59: <cfinclude template="#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm" /> 60: <cfelse> 61: <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
number59
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:59)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
9
Struct
codePrintHTML
string37: &lt;/cfif&gt;<br> 38: &lt;cfscript&gt;<br> <b>39: doLayout();</b><br> 40: &lt;/cfscript&gt;<br> 41: &lt;/cfif&gt;<br>
codePrintPlain
string37: </cfif> 38: <cfscript> 39: doLayout(); 40: </cfscript> 41: </cfif>
column
number0
id
string??
line
number39
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:39)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
10
Struct
codePrintHTML
string305: local.url.process(cgi.path_info);<br> 306: <br> <b>307: writeOutput(request.iqlib.RenderContent());</b><br> 308: }<br> 309: }<br>
codePrintPlain
string305: local.url.process(cgi.path_info); 306: 307: writeOutput(request.iqlib.RenderContent()); 308: } 309: }
column
number0
id
string??
line
number307
Raw_Trace
stringapplication_cfc$cf.udfCall(/application.cfc:307)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string

Real Estate by Area

Real Estate by Area Main Image
SITE:lvessels.cbhre.com
SERVER:iq-web-3
DATA SERVER:cust-sql-3
COMPANY ID:iq_cb_hearthside
REFERER:
REMOTE ADDRESS:3.80.85.76
USER AGENT:CCBot/2.0 (https://commoncrawl.org/faq/)
REQUEST URL:http://lvessels.cbhre.com/real-estate/area
DATE:12/18/2018 21:55:14



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_ppsqf from ( 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_foot from ( select count(listingid) as fieldcount , 'area' as field , area 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_foot from listings WITH (NOLOCK) where mlsid in ('mls_gardenstate','mls_lehighvalley','mls_capemay','mls_jerseyshore','mls_bright','mls_bright_trend') AND (deleteflag = 'n') and (len(area) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) group by area ) data_union group by data_union.fielddata, data_union.field ) data left outer join ( select sum(sold_count) as sold_count , field , fielddata from ( select count(listingid) as sold_count , 'area' as field , area as fielddata from listings WITH (NOLOCK) where mlsid in ('mls_gardenstate','mls_lehighvalley','mls_capemay','mls_jerseyshore','mls_bright','mls_bright_trend') AND (saleprice != 0) and (deleteflag = 'y') and (len(area) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) and (datetime like '2018%') group by area )sold_union group by sold_union.fielddata, sold_union.field ) sold_data on sold_data.fielddata = data.fielddata left 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_ppsqf from ( select area 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 area ORDER BY cast(list_price as bigint)) , c = COUNT(listingid) OVER (PARTITION BY area) from listings WITH (NOLOCK) where mlsid in ('mls_gardenstate','mls_lehighvalley','mls_capemay','mls_jerseyshore','mls_bright','mls_bright_trend') AND (deleteflag = 'n') and (len(area) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) ) median_union where median_union.rn IN ((median_union.c + 1)/2, (median_union.c + 2)/2) group by median_union.fielddata ) median_data on median_data.fielddata = data.fielddata order by data.fielddata
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string13.00.1601
DriverName
stringMicrosoft JDBC Driver 6.2 for SQL Server
DriverVersion
string6.2.2.0
Datasource
stringiq_cb_hearthside
DataSource
stringiq_cb_hearthside
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringArithmetic overflow error converting expression to data type int.
NativeErrorCode
number8115
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_ppsqf from ( 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_foot from ( select count(listingid) as fieldcount , 'area' as field , area 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_foot from listings WITH (NOLOCK) where mlsid in ('mls_gardenstate','mls_lehighvalley','mls_capemay','mls_jerseyshore','mls_bright','mls_bright_trend') AND (deleteflag = 'n') and (len(area) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) group by area ) data_union group by data_union.fielddata, data_union.field ) data left outer join ( select sum(sold_count) as sold_count , field , fielddata from ( select count(listingid) as sold_count , 'area' as field , area as fielddata from listings WITH (NOLOCK) where mlsid in ('mls_gardenstate','mls_lehighvalley','mls_capemay','mls_jerseyshore','mls_bright','mls_bright_trend') AND (saleprice != 0) and (deleteflag = 'y') and (len(area) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) and (datetime like '2018%') group by area )sold_union group by sold_union.fielddata, sold_union.field ) sold_data on sold_data.fielddata = data.fielddata left 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_ppsqf from ( select area 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 area ORDER BY cast(list_price as bigint)) , c = COUNT(listingid) OVER (PARTITION BY area) from listings WITH (NOLOCK) where mlsid in ('mls_gardenstate','mls_lehighvalley','mls_capemay','mls_jerseyshore','mls_bright','mls_bright_trend') AND (deleteflag = 'n') and (len(area) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) ) median_union where median_union.rn IN ((median_union.c + 1)/2, (median_union.c + 2)/2) group by median_union.fielddata ) median_data on median_data.fielddata = data.fielddata order 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_ppsqf from ( 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_foot from ( select count(listingid) as fieldcount , 'area' as field , area 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_foot from listings WITH (NOLOCK) where mlsid in ('mls_gardenstate','mls_lehighvalley','mls_capemay','mls_jerseyshore','mls_bright','mls_bright_trend') AND (deleteflag = 'n') and (len(area) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) group by area ) data_union group by data_union.fielddata, data_union.field ) data left outer join ( select sum(sold_count) as sold_count , field , fielddata from ( select count(listingid) as sold_count , 'area' as field , area as fielddata from listings WITH (NOLOCK) where mlsid in ('mls_gardenstate','mls_lehighvalley','mls_capemay','mls_jerseyshore','mls_bright','mls_bright_trend') AND (saleprice != 0) and (deleteflag = 'y') and (len(area) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) and (datetime like '2018%') group by area )sold_union group by sold_union.fielddata, sold_union.field ) sold_data on sold_data.fielddata = data.fielddata left 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_ppsqf from ( select area 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 area ORDER BY cast(list_price as bigint)) , c = COUNT(listingid) OVER (PARTITION BY area) from listings WITH (NOLOCK) where mlsid in ('mls_gardenstate','mls_lehighvalley','mls_capemay','mls_jerseyshore','mls_bright','mls_bright_trend') AND (deleteflag = 'n') and (len(area) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) ) median_union where median_union.rn IN ((median_union.c + 1)/2, (median_union.c + 2)/2) group by median_union.fielddata ) median_data on median_data.fielddata = data.fielddata order by data.fielddata
SQLState
stringS0002
StackTrace
stringlucee.runtime.exp.DatabaseException: Arithmetic overflow error converting expression to data type int. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:6309) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1651) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:987) at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:470) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:290) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:226) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1133) at lucee.runtime.tag.Query._doEndTag(Query.java:693) at lucee.runtime.tag.Query.doEndTag(Query.java:583) at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:86) at iqquery_cfc$cf.udfCall1(/iqquery.cfc:265) at iqquery_cfc$cf.udfCall(/iqquery.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:692) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1725) at iqquery_cfc$cf.udfCall1(/iqquery.cfc:155) at iqquery_cfc$cf.udfCall(/iqquery.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:694) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2010) at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:569) at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:207) at components.listings_cfc$cf.udfCall2_000124(/components/listings.cfc:3335) at components.listings_cfc$cf.udfCall2(/components/listings.cfc:3227) at components.listings_cfc$cf.udfCall(/components/listings.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:694) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2006) at lucee.runtime.tag.Invoke.doComponent(Invoke.java:224) at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:197) at iqweb.app._real_estate_cfm270$cf.call(/production/iqweb/app/_real-estate.cfm:431) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:830) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:812) 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:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:692) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1725) at iqweb.sitetemplates._24.layouts._site_cfm$cf.call(/production/iqweb/sitetemplates/24/layouts/_site.cfm:326) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:830) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:812) at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:59) at lib.iq_cfc$cf.udfCall(/lib/iq.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:809) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1725) at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:39) at lib.iq_cfc$cf.udfCall(/lib/iq.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:692) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1725) at application_cfc$cf.udfCall(/application.cfc:307) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:692) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:438) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:216) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2480) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2470) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2443) at lucee.runtime.engine.Request.exe(Request.java:44) at lucee.runtime.engine.Request.run(Request.java:30)
TagContext
Array
1
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number265
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:265)
template
string/iqquery.cfc
type
stringcfml
2
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number155
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:155)
template
string/iqquery.cfc
type
stringcfml
3
Struct
codePrintHTML
string3333: <br> 3334: order by data.fielddata<br> <b>3335: &lt;/cfiqquery&gt;</b><br> 3336: &lt;/cfoutput&gt;<br> 3337: <br>
codePrintPlain
string3333: 3334: order by data.fielddata 3335: </cfiqquery> 3336: </cfoutput> 3337:
column
number0
id
string??
line
number3335
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2_000124(/components/listings.cfc:3335)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
4
Struct
codePrintHTML
string3225: &lt;cfset local.retVal.Content = &quot;&quot;&gt;<br> 3226: <br> <b>3227: &lt;cftry&gt;</b><br> 3228: &lt;cfoutput&gt;<br> 3229: <br>
codePrintPlain
string3225: <cfset local.retVal.Content = ""> 3226: 3227: <cftry> 3228: <cfoutput> 3229:
column
number0
id
string??
line
number3227
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2(/components/listings.cfc:3227)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
5
Struct
codePrintHTML
string429: &lt;cfinvokeargument name=&quot;layout&quot; value=&quot;list_field&quot;&gt;<br> 430: &lt;cfinvokeargument name=&quot;field&quot; value=&quot;#field#&quot;&gt;<br> <b>431: &lt;/cfinvoke&gt;</b><br> 432: <br> 433: &lt;cfif retFieldData.status neq 0&gt;<br>
codePrintPlain
string429: <cfinvokeargument name="layout" value="list_field"> 430: <cfinvokeargument name="field" value="#field#"> 431: </cfinvoke> 432: 433: <cfif retFieldData.status neq 0>
column
number0
id
string??
line
number431
Raw_Trace
stringiqweb.app._real_estate_cfm270$cf.call(/production/iqweb/app/_real-estate.cfm:431)
template
stringC:\realistiq\production\iqweb\app\_real-estate.cfm
type
stringcfml
6
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
7
Struct
codePrintHTML
string324: &lt;/cfif&gt;<br> 325: &lt;div class=&quot;#request.page eq 'listings' or request.page eq 'rentals' or request.page eq 'house-value' ? 'container-fluid' : 'container'#&quot;&gt;<br> <b>326: #request.iqlib.RenderPage()#</b><br> 327: &lt;/div&gt;<br> 328: &lt;/div&gt;<br>
codePrintPlain
string324: </cfif> 325: <div class="#request.page eq 'listings' or request.page eq 'rentals' or request.page eq 'house-value' ? 'container-fluid' : 'container'#"> 326: #request.iqlib.RenderPage()# 327: </div> 328: </div>
column
number0
id
string??
line
number326
Raw_Trace
stringiqweb.sitetemplates._24.layouts._site_cfm$cf.call(/production/iqweb/sitetemplates/24/layouts/_site.cfm:326)
template
stringC:\realistiq\production\iqweb\sitetemplates\24\layouts\_site.cfm
type
stringcfml
8
Struct
codePrintHTML
string57: &lt;cfelse&gt;<br> 58: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot;)&gt;<br> <b>59: &lt;cfinclude template=&quot;#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot; /&gt;</b><br> 60: &lt;cfelse&gt;<br> 61: &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
string57: <cfelse> 58: <cfif FileExists("#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm")> 59: <cfinclude template="#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm" /> 60: <cfelse> 61: <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
number59
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:59)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
9
Struct
codePrintHTML
string37: &lt;/cfif&gt;<br> 38: &lt;cfscript&gt;<br> <b>39: doLayout();</b><br> 40: &lt;/cfscript&gt;<br> 41: &lt;/cfif&gt;<br>
codePrintPlain
string37: </cfif> 38: <cfscript> 39: doLayout(); 40: </cfscript> 41: </cfif>
column
number0
id
string??
line
number39
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:39)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
10
Struct
codePrintHTML
string305: local.url.process(cgi.path_info);<br> 306: <br> <b>307: writeOutput(request.iqlib.RenderContent());</b><br> 308: }<br> 309: }<br>
codePrintPlain
string305: local.url.process(cgi.path_info); 306: 307: writeOutput(request.iqlib.RenderContent()); 308: } 309: }
column
number0
id
string??
line
number307
Raw_Trace
stringapplication_cfc$cf.udfCall(/application.cfc:307)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string