SITE:www.buybrenham.com
SERVER:iq-web-3
DATA SERVER:cust-sql-5
COMPANY ID:iq_cb_properties_unlimited
USER:N/A
ACTING AS:N/A
REFERER:
REMOTE ADDRESS:3.229.122.219
USER AGENT:CCBot/2.0 (https://commoncrawl.org/faq/)
REQUEST URL:http://www.buybrenham.com/real-estate/county
DATE:12/05/2019 06:30:30


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 , 'county' as field , county 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_foot from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (deleteflag = 'n') and (len(county) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) group by county ) 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 , 'county' as field , county as fielddata from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (saleprice != 0) and (deleteflag = 'y') and (len(county) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) and (datetime like '2019%') group by county )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 county 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 county ORDER BY cast(list_price as bigint)) , c = COUNT(listingid) OVER (PARTITION BY county) from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (deleteflag = 'n') and (len(county) > 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.4001
DriverName
stringMicrosoft JDBC Driver 6.2 for SQL Server
DriverVersion
string6.2.2.0
Datasource
stringiq_cb_properties_unlimited
DataSource
stringiq_cb_properties_unlimited
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringCannot construct data type date, some of the arguments have values which are not valid.
NativeErrorCode
number289
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 , 'county' as field , county 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_foot from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (deleteflag = 'n') and (len(county) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) group by county ) 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 , 'county' as field , county as fielddata from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (saleprice != 0) and (deleteflag = 'y') and (len(county) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) and (datetime like '2019%') group by county )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 county 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 county ORDER BY cast(list_price as bigint)) , c = COUNT(listingid) OVER (PARTITION BY county) from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (deleteflag = 'n') and (len(county) > 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 , 'county' as field , county 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_foot from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (deleteflag = 'n') and (len(county) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) group by county ) 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 , 'county' as field , county as fielddata from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (saleprice != 0) and (deleteflag = 'y') and (len(county) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) and (datetime like '2019%') group by county )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 county 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 county ORDER BY cast(list_price as bigint)) , c = COUNT(listingid) OVER (PARTITION BY county) from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (deleteflag = 'n') and (len(county) > 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
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: Cannot construct data type date, some of the arguments have values which are not valid. 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_000136(/components/listings.cfc:3853) at components.listings_cfc$cf.udfCall2(/components/listings.cfc:3745) 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:452) 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._31.layouts._site_cfm$cf.call(/production/iqweb/sitetemplates/31/layouts/_site.cfm:165) 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:325) 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
string3851: <br> 3852: order by data.fielddata<br> <b>3853: &lt;/cfiqquery&gt;</b><br> 3854: &lt;/cfoutput&gt;<br> 3855: <br>
codePrintPlain
string3851: 3852: order by data.fielddata 3853: </cfiqquery> 3854: </cfoutput> 3855:
column
number0
id
string??
line
number3853
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2_000136(/components/listings.cfc:3853)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
4
Struct
codePrintHTML
string3743: &lt;cfset local.retVal.Content = &quot;&quot;&gt;<br> 3744: <br> <b>3745: &lt;cftry&gt;</b><br> 3746: &lt;cfoutput&gt;<br> 3747: <br>
codePrintPlain
string3743: <cfset local.retVal.Content = ""> 3744: 3745: <cftry> 3746: <cfoutput> 3747:
column
number0
id
string??
line
number3745
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2(/components/listings.cfc:3745)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
5
Struct
codePrintHTML
string450: &lt;cfinvokeargument name=&quot;layout&quot; value=&quot;list_field&quot;&gt;<br> 451: &lt;cfinvokeargument name=&quot;field&quot; value=&quot;#field#&quot;&gt;<br> <b>452: &lt;/cfinvoke&gt;</b><br> 453: <br> 454: &lt;cfif retFieldData.status neq 0&gt;<br>
codePrintPlain
string450: <cfinvokeargument name="layout" value="list_field"> 451: <cfinvokeargument name="field" value="#field#"> 452: </cfinvoke> 453: 454: <cfif retFieldData.status neq 0>
column
number0
id
string??
line
number452
Raw_Trace
stringiqweb.app._real_estate_cfm270$cf.call(/production/iqweb/app/_real-estate.cfm:452)
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
string163: &lt;/cfif&gt;<br> 164: &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>165: #request.iqlib.RenderPage()#</b><br> 166: &lt;/div&gt;<br> 167: &lt;/div&gt;<br>
codePrintPlain
string163: </cfif> 164: <div class="#request.page eq 'listings' or request.page eq 'rentals' or request.page eq 'house-value' ? 'container-fluid' : 'container'#"> 165: #request.iqlib.RenderPage()# 166: </div> 167: </div>
column
number0
id
string??
line
number165
Raw_Trace
stringiqweb.sitetemplates._31.layouts._site_cfm$cf.call(/production/iqweb/sitetemplates/31/layouts/_site.cfm:165)
template
stringC:\realistiq\production\iqweb\sitetemplates\31\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
string323: &lt;cfset local.url = new lib.url() /&gt;<br> 324: &lt;cfset local.url.process(CGI.path_info) /&gt;<br> <b>325: &lt;cfoutput&gt;#request.iqlib.RenderContent()#&lt;/cfoutput&gt;</b><br> 326: &lt;/cfif&gt;<br> 327: &lt;/cfif&gt;<br>
codePrintPlain
string323: <cfset local.url = new lib.url() /> 324: <cfset local.url.process(CGI.path_info) /> 325: <cfoutput>#request.iqlib.RenderContent()#</cfoutput> 326: </cfif> 327: </cfif>
column
number0
id
string??
line
number325
Raw_Trace
stringapplication_cfc$cf.udfCall(/application.cfc:325)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string

Real Estate by County

Real Estate by County Main Image
SITE:www.buybrenham.com
SERVER:iq-web-3
DATA SERVER:cust-sql-5
COMPANY ID:iq_cb_properties_unlimited
USER:N/A
ACTING AS:N/A
REFERER:
REMOTE ADDRESS:3.229.122.219
USER AGENT:CCBot/2.0 (https://commoncrawl.org/faq/)
REQUEST URL:http://www.buybrenham.com/real-estate/county
DATE:12/05/2019 06:30:30


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 , 'county' as field , county 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_foot from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (deleteflag = 'n') and (len(county) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) group by county ) 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 , 'county' as field , county as fielddata from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (saleprice != 0) and (deleteflag = 'y') and (len(county) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) and (datetime like '2019%') group by county )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 county 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 county ORDER BY cast(list_price as bigint)) , c = COUNT(listingid) OVER (PARTITION BY county) from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (deleteflag = 'n') and (len(county) > 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.4001
DriverName
stringMicrosoft JDBC Driver 6.2 for SQL Server
DriverVersion
string6.2.2.0
Datasource
stringiq_cb_properties_unlimited
DataSource
stringiq_cb_properties_unlimited
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringCannot construct data type date, some of the arguments have values which are not valid.
NativeErrorCode
number289
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 , 'county' as field , county 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_foot from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (deleteflag = 'n') and (len(county) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) group by county ) 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 , 'county' as field , county as fielddata from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (saleprice != 0) and (deleteflag = 'y') and (len(county) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) and (datetime like '2019%') group by county )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 county 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 county ORDER BY cast(list_price as bigint)) , c = COUNT(listingid) OVER (PARTITION BY county) from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (deleteflag = 'n') and (len(county) > 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 , 'county' as field , county 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_foot from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (deleteflag = 'n') and (len(county) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) group by county ) 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 , 'county' as field , county as fielddata from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (saleprice != 0) and (deleteflag = 'y') and (len(county) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) and (datetime like '2019%') group by county )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 county 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 county ORDER BY cast(list_price as bigint)) , c = COUNT(listingid) OVER (PARTITION BY county) from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (deleteflag = 'n') and (len(county) > 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
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: Cannot construct data type date, some of the arguments have values which are not valid. 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_000136(/components/listings.cfc:3853) at components.listings_cfc$cf.udfCall2(/components/listings.cfc:3745) 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:452) 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._31.layouts._site_cfm$cf.call(/production/iqweb/sitetemplates/31/layouts/_site.cfm:165) 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:325) 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
string3851: <br> 3852: order by data.fielddata<br> <b>3853: &lt;/cfiqquery&gt;</b><br> 3854: &lt;/cfoutput&gt;<br> 3855: <br>
codePrintPlain
string3851: 3852: order by data.fielddata 3853: </cfiqquery> 3854: </cfoutput> 3855:
column
number0
id
string??
line
number3853
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2_000136(/components/listings.cfc:3853)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
4
Struct
codePrintHTML
string3743: &lt;cfset local.retVal.Content = &quot;&quot;&gt;<br> 3744: <br> <b>3745: &lt;cftry&gt;</b><br> 3746: &lt;cfoutput&gt;<br> 3747: <br>
codePrintPlain
string3743: <cfset local.retVal.Content = ""> 3744: 3745: <cftry> 3746: <cfoutput> 3747:
column
number0
id
string??
line
number3745
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2(/components/listings.cfc:3745)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
5
Struct
codePrintHTML
string450: &lt;cfinvokeargument name=&quot;layout&quot; value=&quot;list_field&quot;&gt;<br> 451: &lt;cfinvokeargument name=&quot;field&quot; value=&quot;#field#&quot;&gt;<br> <b>452: &lt;/cfinvoke&gt;</b><br> 453: <br> 454: &lt;cfif retFieldData.status neq 0&gt;<br>
codePrintPlain
string450: <cfinvokeargument name="layout" value="list_field"> 451: <cfinvokeargument name="field" value="#field#"> 452: </cfinvoke> 453: 454: <cfif retFieldData.status neq 0>
column
number0
id
string??
line
number452
Raw_Trace
stringiqweb.app._real_estate_cfm270$cf.call(/production/iqweb/app/_real-estate.cfm:452)
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
string163: &lt;/cfif&gt;<br> 164: &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>165: #request.iqlib.RenderPage()#</b><br> 166: &lt;/div&gt;<br> 167: &lt;/div&gt;<br>
codePrintPlain
string163: </cfif> 164: <div class="#request.page eq 'listings' or request.page eq 'rentals' or request.page eq 'house-value' ? 'container-fluid' : 'container'#"> 165: #request.iqlib.RenderPage()# 166: </div> 167: </div>
column
number0
id
string??
line
number165
Raw_Trace
stringiqweb.sitetemplates._31.layouts._site_cfm$cf.call(/production/iqweb/sitetemplates/31/layouts/_site.cfm:165)
template
stringC:\realistiq\production\iqweb\sitetemplates\31\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
string323: &lt;cfset local.url = new lib.url() /&gt;<br> 324: &lt;cfset local.url.process(CGI.path_info) /&gt;<br> <b>325: &lt;cfoutput&gt;#request.iqlib.RenderContent()#&lt;/cfoutput&gt;</b><br> 326: &lt;/cfif&gt;<br> 327: &lt;/cfif&gt;<br>
codePrintPlain
string323: <cfset local.url = new lib.url() /> 324: <cfset local.url.process(CGI.path_info) /> 325: <cfoutput>#request.iqlib.RenderContent()#</cfoutput> 326: </cfif> 327: </cfif>
column
number0
id
string??
line
number325
Raw_Trace
stringapplication_cfc$cf.udfCall(/application.cfc:325)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string

Coldwell Banker Unlimited Properties

Real Estate Links Our Domains