SELECT COMPANY = (
CASE
WHEN (companyid = 'iq_cb_mm_parrish') THEN (1)
ELSE (2)
END
)
,l.id
,0 AS Distance
FROM Listings l WITH (NOLOCK)
WHERE l.mlsid IN (:SQL_PARAM_1)
AND l.propertytype IN (:SQL_PARAM_2)
AND l.listingtype IN (
| SITE: | www.teamgainesville.com |
| SERVER: | iq-web-0 |
| DATA SERVER: | cust-sql-1 |
| COMPANY ID: | iq_cb_mm_parrish |
| USER: | N/A |
| ACTING AS: | N/A |
| REFERER: | |
| REMOTE ADDRESS: | 18.232.51.69 |
| USER AGENT: | CCBot/2.0 (https://commoncrawl.org/faq/) |
| REQUEST URL: | http://www.teamgainesville.com/real-estate/zip/32618 |
| DATE: | 04/07/2020 20:35:09 |
| Catch |
| additional | |
| Detail | |
| ErrNumber | |
| ErrorCode | |
| Extended_Info | |
| ExtendedInfo | |
| Message | | string | variable [RSCOUNT] doesn't exist |
|
| StackTrace | | string | lucee.runtime.exp.ExpressionException: variable [RSCOUNT] doesn't exist
at lucee.runtime.type.scope.UndefinedImpl.get(UndefinedImpl.java:237)
at lucee.runtime.type.scope.UndefinedImpl.get(UndefinedImpl.java:179)
at components.listings_cfc$cf.udfCall1(/components/listings.cfc:659)
at components.listings_cfc$cf.udfCall(/components/listings.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:200)
at lucee.runtime.tag.Invoke.doFunction(Invoke.java:222)
at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:194)
at components.listings_cfc$cf.udfCall2(/components/listings.cfc:1397)
at components.listings_cfc$cf.udfCall(/components/listings.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:205)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:681)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1912)
at lucee.runtime.tag.Invoke.doComponent(Invoke.java:209)
at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:186)
at iqweb.app._real_estate_cfm270$cf.call(/production/iqweb/app/_real-estate.cfm:161)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:944)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:836)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:818)
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:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:680)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
at iqweb.sitetemplates._09.layouts._site_cfm$cf.call(/production/iqweb/sitetemplates/09/layouts/_site.cfm:245)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:944)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:836)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:818)
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:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:779)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
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:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:680)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:785)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1709)
at application_cfc$cf.udfCall(/application.cfc:345)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:342)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:215)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:680)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1898)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:436)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:215)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:42)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2415)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2405)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2380)
at lucee.runtime.engine.Request.exe(Request.java:43)
at lucee.runtime.engine.Request.run(Request.java:29)
|
|
| TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 657: <br>
658: <cfif arguments.return_type EQ "query"><br>
<b>659: <cfreturn rsCount></b><br>
660: <cfelse><br>
661: <cfreturn serializeJSON(local.retVal)><br>
|
| | codePrintPlain | | string | 657:
658: <cfif arguments.return_type EQ "query">
659: <cfreturn rsCount>
660: <cfelse>
661: <cfreturn serializeJSON(local.retVal)>
|
| | column | | | id | | | line | | | Raw_Trace | | string | components.listings_cfc$cf.udfCall1(/components/listings.cfc:659) |
| | template | | string | C:\realistiq\production\iqweb\components\listings.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 1395: <cfinvoke method="search" returnvariable="rsCount" argumentCollection="#local.searchArgs#"><br>
1396: <cfinvokeargument name="return_type" value="query"><br>
<b>1397: </cfinvoke></b><br>
1398: <br>
1399: <cfset local.retVal.TotalRowCount = rsCount.RecordCount><br>
|
| | codePrintPlain | | string | 1395: <cfinvoke method="search" returnvariable="rsCount" argumentCollection="#local.searchArgs#">
1396: <cfinvokeargument name="return_type" value="query">
1397: </cfinvoke>
1398:
1399: <cfset local.retVal.TotalRowCount = rsCount.RecordCount>
|
| | column | | | id | | | line | | | Raw_Trace | | string | components.listings_cfc$cf.udfCall2(/components/listings.cfc:1397) |
| | template | | string | C:\realistiq\production\iqweb\components\listings.cfc |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 159: <cfinvokeargument name="maxrows" value="24"><br>
160: <cfinvokeargument name="impression_from" value="Search Results"><br>
<b>161: </cfinvoke></b><br>
162: <br>
163: <cfif retListings.Status EQ 1 or fieldvalue eq ""><br>
|
| | codePrintPlain | | string | 159: <cfinvokeargument name="maxrows" value="24">
160: <cfinvokeargument name="impression_from" value="Search Results">
161: </cfinvoke>
162:
163: <cfif retListings.Status EQ 1 or fieldvalue eq "">
|
| | column | | | id | | | line | | | Raw_Trace | | string | iqweb.app._real_estate_cfm270$cf.call(/production/iqweb/app/_real-estate.cfm:161) |
| | template | | string | C:\realistiq\production\iqweb\app\_real-estate.cfm |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | 80: <br>
81: <cfif FileExists("#request.AppAbsolutePath#/app/_#local.PageName#.cfm")><br>
<b>82: <cfinclude template="#request.AppMapPath#/app/_#local.PageName#.cfm" /></b><br>
83: <cfelse><br>
84: <cfset MissingFile = local.PageName><br>
|
| | codePrintPlain | | string | 80:
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 | | | id | | | line | | | Raw_Trace | | string | lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:82) |
| | template | | string | C:\realistiq\production\iqweb\lib\iq.cfc |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 243: </cfif><br>
244: <div class="#request.page eq 'listings' or request.page eq 'rentals' or request.page eq 'house-value' ? 'container-fluid' : 'container'#"><br>
<b>245: #request.iqlib.RenderPage()#</b><br>
246: </div><br>
247: </div><br>
|
| | codePrintPlain | | string | 243: </cfif>
244: <div class="#request.page eq 'listings' or request.page eq 'rentals' or request.page eq 'house-value' ? 'container-fluid' : 'container'#">
245: #request.iqlib.RenderPage()#
246: </div>
247: </div>
|
| | column | | | id | | | line | | | Raw_Trace | | string | iqweb.sitetemplates._09.layouts._site_cfm$cf.call(/production/iqweb/sitetemplates/09/layouts/_site.cfm:245) |
| | template | | string | C:\realistiq\production\iqweb\sitetemplates\09\layouts\_site.cfm |
| | type | |
| | 6 | | Struct | | codePrintHTML | | string | 57: <cfelse><br>
58: <cfif FileExists("#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm")><br>
<b>59: <cfinclude template="#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm" /></b><br>
60: <cfelse><br>
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.<br>
|
| | codePrintPlain | | string | 57: <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 "<em>#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm</em>" could not be found.
|
| | column | | | id | | | line | | | Raw_Trace | | string | lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:59) |
| | template | | string | C:\realistiq\production\iqweb\lib\iq.cfc |
| | type | |
| | 7 | | Struct | | codePrintHTML | | string | 37: </cfif><br>
38: <cfscript><br>
<b>39: doLayout();</b><br>
40: </cfscript><br>
41: </cfif><br>
|
| | codePrintPlain | | string | 37: </cfif>
38: <cfscript>
39: doLayout();
40: </cfscript>
41: </cfif>
|
| | column | | | id | | | line | | | Raw_Trace | | string | lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:39) |
| | template | | string | C:\realistiq\production\iqweb\lib\iq.cfc |
| | type | |
| | 8 | | Struct | | codePrintHTML | | string | 343: <cfset local.url = new lib.url() /><br>
344: <cfset local.url.process(CGI.path_info) /><br>
<b>345: <cfoutput>#request.iqlib.RenderContent()#</cfoutput></b><br>
346: </cfif><br>
347: </cfif><br>
|
| | codePrintPlain | | string | 343: <cfset local.url = new lib.url() />
344: <cfset local.url.process(CGI.path_info) />
345: <cfoutput>#request.iqlib.RenderContent()#</cfoutput>
346: </cfif>
347: </cfif>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall(/application.cfc:345) |
| | template | | string | C:\realistiq\production\iqweb\application.cfc |
| | type | |
|
|
| type | |
