SITE:jchanning.buybrenham.com
SERVER:iq-web-1
DATA SERVER:cust-sql-5
COMPANY ID:iq_cb_properties_unlimited
USER:N/A
ACTING AS:N/A
REFERER:
REMOTE ADDRESS:18.208.186.19
USER AGENT:CCBot/2.0 (https://commoncrawl.org/faq/)
REQUEST URL:http://jchanning.buybrenham.com/real-estate/city
DATE:11/12/2019 15:12:02



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 , 'city' as field , city 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(city) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) group by city ) 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 , 'city' as field , city as fielddata from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (saleprice != 0) and (deleteflag = 'y') and (len(city) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) and (datetime like '2019%') group by city )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 city 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 city ORDER BY cast(list_price as bigint)) , c = COUNT(listingid) OVER (PARTITION BY city) from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (deleteflag = 'n') and (len(city) > 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 , 'city' as field , city 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(city) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) group by city ) 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 , 'city' as field , city as fielddata from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (saleprice != 0) and (deleteflag = 'y') and (len(city) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) and (datetime like '2019%') group by city )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 city 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 city ORDER BY cast(list_price as bigint)) , c = COUNT(listingid) OVER (PARTITION BY city) from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (deleteflag = 'n') and (len(city) > 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 , 'city' as field , city 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(city) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) group by city ) 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 , 'city' as field , city as fielddata from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (saleprice != 0) and (deleteflag = 'y') and (len(city) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) and (datetime like '2019%') group by city )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 city 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 city ORDER BY cast(list_price as bigint)) , c = COUNT(listingid) OVER (PARTITION BY city) from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (deleteflag = 'n') and (len(city) > 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_000128(/components/listings.cfc:3453) at components.listings_cfc$cf.udfCall2(/components/listings.cfc:3345) 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._13.layouts._site_cfm$cf.call(/production/iqweb/sitetemplates/13/layouts/_site.cfm:230) 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
string3451: <br> 3452: order by data.fielddata<br> <b>3453: &lt;/cfiqquery&gt;</b><br> 3454: &lt;/cfoutput&gt;<br> 3455: <br>
codePrintPlain
string3451: 3452: order by data.fielddata 3453: </cfiqquery> 3454: </cfoutput> 3455:
column
number0
id
string??
line
number3453
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2_000128(/components/listings.cfc:3453)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
4
Struct
codePrintHTML
string3343: &lt;cfset local.retVal.Content = &quot;&quot;&gt;<br> 3344: <br> <b>3345: &lt;cftry&gt;</b><br> 3346: &lt;cfoutput&gt;<br> 3347: <br>
codePrintPlain
string3343: <cfset local.retVal.Content = ""> 3344: 3345: <cftry> 3346: <cfoutput> 3347:
column
number0
id
string??
line
number3345
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2(/components/listings.cfc:3345)
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
string228: &lt;/cfif&gt;<br> 229: &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>230: #request.iqlib.RenderPage()#</b><br> 231: &lt;/div&gt;<br> 232: &lt;/div&gt;<br>
codePrintPlain
string228: </cfif> 229: <div class="#request.page eq 'listings' or request.page eq 'rentals' or request.page eq 'house-value' ? 'container-fluid' : 'container'#"> 230: #request.iqlib.RenderPage()# 231: </div> 232: </div>
column
number0
id
string??
line
number230
Raw_Trace
stringiqweb.sitetemplates._13.layouts._site_cfm$cf.call(/production/iqweb/sitetemplates/13/layouts/_site.cfm:230)
template
stringC:\realistiq\production\iqweb\sitetemplates\13\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 City

Real Estate by City Main Image
SITE:jchanning.buybrenham.com
SERVER:iq-web-1
DATA SERVER:cust-sql-5
COMPANY ID:iq_cb_properties_unlimited
USER:N/A
ACTING AS:N/A
REFERER:
REMOTE ADDRESS:18.208.186.19
USER AGENT:CCBot/2.0 (https://commoncrawl.org/faq/)
REQUEST URL:http://jchanning.buybrenham.com/real-estate/city
DATE:11/12/2019 15:12:02



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 , 'city' as field , city 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(city) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) group by city ) 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 , 'city' as field , city as fielddata from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (saleprice != 0) and (deleteflag = 'y') and (len(city) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) and (datetime like '2019%') group by city )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 city 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 city ORDER BY cast(list_price as bigint)) , c = COUNT(listingid) OVER (PARTITION BY city) from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (deleteflag = 'n') and (len(city) > 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 , 'city' as field , city 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(city) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) group by city ) 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 , 'city' as field , city as fielddata from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (saleprice != 0) and (deleteflag = 'y') and (len(city) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) and (datetime like '2019%') group by city )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 city 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 city ORDER BY cast(list_price as bigint)) , c = COUNT(listingid) OVER (PARTITION BY city) from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (deleteflag = 'n') and (len(city) > 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 , 'city' as field , city 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(city) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) group by city ) 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 , 'city' as field , city as fielddata from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (saleprice != 0) and (deleteflag = 'y') and (len(city) > 1) and (propertytype in ('Commercial','MultiFamily','Residential','Land')) and (datetime like '2019%') group by city )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 city 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 city ORDER BY cast(list_price as bigint)) , c = COUNT(listingid) OVER (PARTITION BY city) from listings WITH (NOLOCK) where mlsid in ('mls_har') AND (deleteflag = 'n') and (len(city) > 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_000128(/components/listings.cfc:3453) at components.listings_cfc$cf.udfCall2(/components/listings.cfc:3345) 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._13.layouts._site_cfm$cf.call(/production/iqweb/sitetemplates/13/layouts/_site.cfm:230) 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
string3451: <br> 3452: order by data.fielddata<br> <b>3453: &lt;/cfiqquery&gt;</b><br> 3454: &lt;/cfoutput&gt;<br> 3455: <br>
codePrintPlain
string3451: 3452: order by data.fielddata 3453: </cfiqquery> 3454: </cfoutput> 3455:
column
number0
id
string??
line
number3453
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2_000128(/components/listings.cfc:3453)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
4
Struct
codePrintHTML
string3343: &lt;cfset local.retVal.Content = &quot;&quot;&gt;<br> 3344: <br> <b>3345: &lt;cftry&gt;</b><br> 3346: &lt;cfoutput&gt;<br> 3347: <br>
codePrintPlain
string3343: <cfset local.retVal.Content = ""> 3344: 3345: <cftry> 3346: <cfoutput> 3347:
column
number0
id
string??
line
number3345
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2(/components/listings.cfc:3345)
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
string228: &lt;/cfif&gt;<br> 229: &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>230: #request.iqlib.RenderPage()#</b><br> 231: &lt;/div&gt;<br> 232: &lt;/div&gt;<br>
codePrintPlain
string228: </cfif> 229: <div class="#request.page eq 'listings' or request.page eq 'rentals' or request.page eq 'house-value' ? 'container-fluid' : 'container'#"> 230: #request.iqlib.RenderPage()# 231: </div> 232: </div>
column
number0
id
string??
line
number230
Raw_Trace
stringiqweb.sitetemplates._13.layouts._site_cfm$cf.call(/production/iqweb/sitetemplates/13/layouts/_site.cfm:230)
template
stringC:\realistiq\production\iqweb\sitetemplates\13\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