IQWeb_Real_Estate_Default_Header

IQWeb_Real_Estate_Default_Header Main Image
SITE:culbekath109.coldwellbankerishome.com
SERVER:web-0
REFERER:
REMOTE ADDRESS:54.198.243.51
USER AGENT:CCBot/2.0 (http://commoncrawl.org/faq/)
REQUEST URL:http://culbekath109.coldwellbankerishome.com/real-estate/school-district/5402-coldwater-evsd
DATE:07/20/2018 13:10:19



EXCEPTION
Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT COMPANY = (CASEWHEN (companyid = 'iq_cb_heritage') THEN (1)ELSE (2)END),l.id, 0 AS DistanceFROM Listings l WITH (NOLOCK)WHERE (l.mlsid IN ('mls_cincinnati','mls_dayton','mls_westohio'))and (l.propertytype IN ('Commercial','Land','MultiFamily','Residential'))AND (l.DeleteFlag = 'N')AND (l.SchoolDistrict IN ('5402 coldwater evsd'))AND (l.isprivate = 'f') ORDER BY List_Price desc, ML_Number ASC
DataSource
stringiq_cb_heritage
Detail
stringConnection reset by peer: socket write error
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
string
NativeErrorCode
number0
queryError
stringSELECT COMPANY = (CASEWHEN (companyid = 'iq_cb_heritage') THEN (1)ELSE (2)END),l.id, 0 AS DistanceFROM Listings l WITH (NOLOCK)WHERE (l.mlsid IN ('mls_cincinnati','mls_dayton','mls_westohio'))and (l.propertytype IN ('Commercial','Land','MultiFamily','Residential'))AND (l.DeleteFlag = 'N')AND (l.SchoolDistrict IN ('5402 coldwater evsd'))AND (l.isprivate = 'f') ORDER BY List_Price desc, ML_Number ASC
Sql
stringSELECT COMPANY = (CASEWHEN (companyid = 'iq_cb_heritage') THEN (1)ELSE (2)END),l.id, 0 AS DistanceFROM Listings l WITH (NOLOCK)WHERE (l.mlsid IN ('mls_cincinnati','mls_dayton','mls_westohio'))and (l.propertytype IN ('Commercial','Land','MultiFamily','Residential'))AND (l.DeleteFlag = 'N')AND (l.SchoolDistrict IN ('5402 coldwater evsd'))AND (l.isprivate = 'f') ORDER BY List_Price desc, ML_Number ASC
SQLState
string08S01
StackTrace
stringlucee.runtime.exp.DatabaseException: at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2400)at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2384)at com.microsoft.sqlserver.jdbc.TDSChannel.write(IOBuffer.java:1900)at com.microsoft.sqlserver.jdbc.TDSWriter.flush(IOBuffer.java:4291)at com.microsoft.sqlserver.jdbc.TDSWriter.writePacket(IOBuffer.java:4192)at com.microsoft.sqlserver.jdbc.TDSWriter.endMessage(IOBuffer.java:3198)at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7929)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:438)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:385)at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:367)at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:301)at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:280)at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:224)at lucee.runtime.tag.Query.executeDatasoure(Query.java:951)at lucee.runtime.tag.Query.doEndTag(Query.java:700)at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:84)at iqquery_cfc$cf.udfCall1(/iqquery.cfc:229)at iqquery_cfc$cf.udfCall(/iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:366)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:703)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1972)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1698)at iqquery_cfc$cf.udfCall1(/iqquery.cfc:134)at iqquery_cfc$cf.udfCall(/iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:366)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:704)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1989)at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:569)at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:207)at components.listings_cfc$cf.udfCall1_000017(/components/listings.cfc:704)at components.listings_cfc$cf.udfCall1(/components/listings.cfc:524)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:366)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:704)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1985)at lucee.runtime.tag.Invoke.doComponent(Invoke.java:221)at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:194)at iqweb.app._real_estate_cfm270$cf.call(/iqapp_mappath/iqweb/app/_real-estate.cfm:157)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:939)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:833)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:817)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:91)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:366)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:703)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1972)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1698)at iqweb.sitetemplates._24.layouts._site_cfm$cf.call(/iqapp_mappath/iqweb/sitetemplates/24/layouts/_site.cfm:295)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:939)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:833)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:817)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:70)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:366)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:771)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1698)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:51)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:366)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:703)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1972)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1698)at application_cfc$cf.udfCall(/Application.cfc:281)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:366)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:703)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1972)at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:419)at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:221)at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2405)at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2395)at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2363)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
number229
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:229)
template
string/iqquery.cfc
type
stringcfml
2
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number134
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:134)
template
string/iqquery.cfc
type
stringcfml
3
Struct
codePrintHTML
string702: &lt;cfif arguments.propertystory eq &quot;T&quot;&gt;AND (l.propertystory != &lt;cfiqqueryparam value=&quot;&quot; cfsqltype=&quot;cf_sql_varchar&quot;&gt; and l.propertystorystatus = &lt;cfiqqueryparam value=&quot;a&quot; cfsqltype=&quot;cf_sql_varchar&quot;&gt;)&lt;/cfif&gt;<br>703: &lt;cfif arguments.distance NEQ 0&gt;AND (dbo.fn_LatLongDistance(#arguments.lat#, #arguments.lon#, l.lat, l.lon) between &lt;cfiqqueryparam value=&quot;0&quot; cfsqltype=&quot;cf_sql_numeric&quot;&gt; and &lt;cfiqqueryparam value=&quot;#arguments.distance#&quot; cfsqltype=&quot;cf_sql_numeric&quot;&gt;)&lt;/cfif&gt;<br><b>704: &lt;/cfif&gt;</b><br>705: ORDER BY #arguments.officelistingsfirst eq 't' ? 'COMPANY ASC,' : ''# #arguments.lat neq 0 and arguments.lon neq 0 ? 'distance, ' : ''# #arguments.OrderBy# #LCase(arguments.OrderDirection)#, ML_Number ASC<br>706: &lt;/cfiqquery&gt;<br>
codePrintPlain
string702: <cfif arguments.propertystory eq "T">AND (l.propertystory != <cfiqqueryparam value="" cfsqltype="cf_sql_varchar"> and l.propertystorystatus = <cfiqqueryparam value="a" cfsqltype="cf_sql_varchar">)</cfif>703: <cfif arguments.distance NEQ 0>AND (dbo.fn_LatLongDistance(#arguments.lat#, #arguments.lon#, l.lat, l.lon) between <cfiqqueryparam value="0" cfsqltype="cf_sql_numeric"> and <cfiqqueryparam value="#arguments.distance#" cfsqltype="cf_sql_numeric">)</cfif>704: </cfif>705: ORDER BY #arguments.officelistingsfirst eq 't' ? 'COMPANY ASC,' : ''# #arguments.lat neq 0 and arguments.lon neq 0 ? 'distance, ' : ''# #arguments.OrderBy# #LCase(arguments.OrderDirection)#, ML_Number ASC706: </cfiqquery>
column
number0
id
string??
line
number704
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall1_000017(/components/listings.cfc:704)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
4
Struct
codePrintHTML
string522: <br>523: &lt;cfreturn local.retVal&gt;<br><b>524: &lt;/cfif&gt;</b><br>525: <br>526: &lt;cfoutput&gt;<br>
codePrintPlain
string522: 523: <cfreturn local.retVal>524: </cfif>525: 526: <cfoutput>
column
number0
id
string??
line
number524
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall1(/components/listings.cfc:524)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
5
Struct
codePrintHTML
string155: &lt;cfinvokeargument name=&quot;maxrows&quot; value=&quot;24&quot;&gt;<br>156: &lt;cfinvokeargument name=&quot;impression_from&quot; value=&quot;Search Results&quot;&gt;<br><b>157: &lt;/cfinvoke&gt;</b><br>158: <br>159: &lt;cfif retListings.Status EQ 1 or fieldvalue eq &quot;&quot;&gt;<br>
codePrintPlain
string155: <cfinvokeargument name="maxrows" value="24">156: <cfinvokeargument name="impression_from" value="Search Results">157: </cfinvoke>158: 159: <cfif retListings.Status EQ 1 or fieldvalue eq "">
column
number0
id
string??
line
number157
Raw_Trace
stringiqweb.app._real_estate_cfm270$cf.call(/iqapp_mappath/iqweb/app/_real-estate.cfm:157)
template
stringC:\realistiq\production\iqweb\app\_real-estate.cfm
type
stringcfml
6
Struct
codePrintHTML
string89: <br>90: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/app/_#local.PageName#.cfm&quot;)&gt;<br><b>91: &lt;cfinclude template=&quot;#request.AppMapPath#/app/_#local.PageName#.cfm&quot; /&gt;</b><br>92: &lt;cfelse&gt;<br>93: &lt;cfset MissingFile = local.PageName&gt;<br>
codePrintPlain
string89: 90: <cfif FileExists("#request.AppAbsolutePath#/app/_#local.PageName#.cfm")>91: <cfinclude template="#request.AppMapPath#/app/_#local.PageName#.cfm" />92: <cfelse>93: <cfset MissingFile = local.PageName>
column
number0
id
string??
line
number91
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:91)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
7
Struct
codePrintHTML
string293: &lt;/cfif&gt;<br>294: &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>295: #request.iqlib.RenderPage()#</b><br>296: &lt;/div&gt;<br>297: &lt;/div&gt;<br>
codePrintPlain
string293: </cfif>294: <div class="#request.page eq 'listings' or request.page eq 'rentals' or request.page eq 'house-value' ? 'container-fluid' : 'container'#">295: #request.iqlib.RenderPage()#296: </div>297: </div>
column
number0
id
string??
line
number295
Raw_Trace
stringiqweb.sitetemplates._24.layouts._site_cfm$cf.call(/iqapp_mappath/iqweb/sitetemplates/24/layouts/_site.cfm:295)
template
stringC:\realistiq\production\iqweb\sitetemplates\24\layouts\_site.cfm
type
stringcfml
8
Struct
codePrintHTML
string68: &lt;cfelse&gt;<br>69: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot;)&gt;<br><b>70: &lt;cfinclude template=&quot;#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot; /&gt;</b><br>71: &lt;cfelse&gt;<br>72: &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
string68: <cfelse>69: <cfif FileExists("#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm")>70: <cfinclude template="#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm" />71: <cfelse>72: <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
number70
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:70)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
9
Struct
codePrintHTML
string49: <br>50: &lt;cfscript&gt;<br><b>51: doLayout();</b><br>52: &lt;/cfscript&gt;<br>53: &lt;/cfif&gt;<br>
codePrintPlain
string49: 50: <cfscript>51: doLayout();52: </cfscript>53: </cfif>
column
number0
id
string??
line
number51
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:51)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
10
Struct
codePrintHTML
string279: local.url.process(cgi.path_info);<br>280: <br><b>281: writeOutput(request.iqlib.RenderContent());</b><br>282: }<br>283: }<br>
codePrintPlain
string279: local.url.process(cgi.path_info);280: 281: writeOutput(request.iqlib.RenderContent());282: }283: }
column
number0
id
string??
line
number281
Raw_Trace
stringapplication_cfc$cf.udfCall(/Application.cfc:281)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string