ID:892E56CFC16F4F64979F8E898799AE64
SITE:www.pcianchetta.com
SERVER:lvd-web-3
DATA SERVER:cust-sql-0
COMPANY ID:iq_cb_tony_hubbard
USER:N/A
ACTING AS:N/A
REFERER:
REMOTE ADDRESS:100.28.0.143
USER AGENT:CCBot/2.0 (https://commoncrawl.org/faq/)
REQUEST URL:http://www.pcianchetta.com/print/5637-autumn-shire-drive-zephyrhills-fl-33541/10277-3948156
DATE:07/24/2024 14:47:22



Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT ROW_NUMBER() OVER ( ORDER BY list_price desc, ml_number ASC ) + 0 AS RowNumber, * FROM ( SELECT DISTINCT COMPANY = ( CASE WHEN (companyid = 'iq_cb_tony_hubbard') THEN (1) ELSE (2) END ) ,IS_OFFICE_LISTING = CASE WHEN (A.OfficeID in ('CBTH01')) THEN (1) ELSE (0) END ,IS_AGENT_LISTING = ( CASE WHEN ( LEN('8135314635') > 0 AND ( L.PUBLICID IN ('8135314635') OR L.SECONDPUBLICID IN ('8135314635') ) ) THEN (1) ELSE (0) END ), 0 AS Distance, 'f' AS iswatching, l.image_path AS ImagePath, l.url, '' AS SortOrder, '' AS AgentPublicID, '' AS AgentImagePath, '' AS AgentFirstName, '' AS AgentMiddleName, '' AS AgentLastName, '' AS AgentPhone, '' AS AgentCell, '' AS AgentFax, '' AS AgentEmail, '' AS AgentWebsiteAddress, '' AS AgentTeam, '' AS AgentCertification, '' AS AgentLicenseNumber, '' AS AgentBioPath, '' AS AgentHasBlog, '' AS AgentURL, '' AS SecondAgentPublicID, '' AS SecondAgentImagePath, '' AS SecondAgentFirstName, '' AS SecondAgentMiddleName, '' AS SecondAgentLastName, '' AS SecondAgentPhone, '' AS SecondAgentCell, '' AS SecondAgentFax, '' AS SecondAgentEmail, '' AS SecondAgentWebsiteAddress, '' AS SecondAgentTeam, '' AS SecondAgentCertification, '' AS SecondAgentLicenseNumber, '' AS SecondAgentBioPath, '' AS SecondAgentHasBlog, '' AS SecondAgentURL, '' AS OfficeID, '' AS OfficeName, '' AS OfficePhone, '' AS OfficeAddress, '' AS OfficeCity, '' AS OfficeState, '' AS OfficeZip, '' AS OfficeDomain, '' AS LogoPath, '' AS LogoPathSmall, '' AS leadpublicid, '' AS AudioTour, PropertyID.PropertyID, 'list_price' AS OrderBy, 'desc' AS OrderDirection, l.MLSID, l.listingid, l.ListingType, l.PropertyType, l.PublicID AS LA_PublicID, l.CompanyID, l.StatusCode, l.Area, l.DisplayAddress, l.DisplayRemarks, l.DisplayCMA, l.Lat, ROUND(l.Lat,5,0) as latitude, l.Lon, ROUND(l.Lon,5,0) as longitude, l.List_Price, l.LO_Name, l.LO_Phone, l.LO_Email, l.LA_Name, l.LA_Phone, l.LA_Email, l.ML_Number, l.PublicID, l.SecondPublicID, l.StreetAddress, l.City, l.State, l.Zip_Code, l.County, l.SchoolDistrict, l.ElementarySchool, l.JRHighSchool, l.HighSchool, DATEDIFF ( "D" , DATEFROMPARTS(left(l.AddDateTime,4), substring(l.AddDateTime,5, 2), substring(l.AddDateTime,7, 2)) , getdate() ) AS DaysOnSite, l.ReducedDateTime, l.AddDateTime, l.Prev_List_Price, l.VirtualTourID, l.Images, l.SubType, l.Optional_01, l.Optional_02, l.Optional_03, l.Optional_04, l.Optional_05, l.Optional_06, l.Optional_07, l.Optional_08, l.Optional_09, l.Optional_10, l.Optional_11, l.Optional_12, l.Optional_13, l.Optional_14, l.Optional_15, l.Optional_16, l.Optional_17, l.Optional_18, l.Optional_19, l.Optional_20, l.VideoTour, l.SecondVideoTour, l.MLS_Remarks, l.Description, l.MLS_StatusCode, l.Orig_List_Price, l.SalePrice, l.ListingDateTime, l.DateTime, l.ClosingDateTime, l.ContractDateTime, l.DOM, l.REO, l.ShortSale, l.LO_ID, l.LA_ID, l.BO_ID, l.BA_ID, l.BO_Name, l.BA_Name, l.image_list, l.image_data, l.custom_image_data, l.DeleteFlag, l.isprivate, '' AS OpenHouseSchedule, '' AS BathsString, l.Baths, l.FullBaths, l.HalfBaths, l.ThreeQuarterBaths, l.Beds, l.Garage, l.Style, l.sq_foot, l.Year_Built, l.Pool, l.Acreage, l.Story, l.Previews, l.Featured, l.CommunityName, l.PropertyView, l.Waterfront, l.Golfcourse, l.Basement, l.Carport, l.PatioSQ_Foot, l.BuildingName, l.UnitFloor, l.HOA, l.HoaDues, l.Zoning, l.sq_foot_Office, l.Units, l.AskingPricePersq_foot, l.SalesTerms, l.SaleType, l.sq_foot_Vacant, l.SuiteNumber, l.SuiteFloor, l.GrossBuildingArea, l.GrossLeaseArea, l.BuildingClass, l.LegalDescription, l.Occupancy, l.TenantOccupancyBasis, l.ConstructionStatus, l.YearRenovated, l.LeedCertification, l.Buildings, l.ParkingType, l.ParkingSpaces, l.PotentialRentalIncome, l.NetOperatingIncome, l.CapRate, l.InternalRateOfReturn, l.CashOnCash, l.PotentialRentalIncomeRemarks, l.NoiRemarks, l.CapRateRemarks, l.LoanBalance, l.InterestRate, l.AmortizationPeriod, l.MaturityDate, l.subarea, l.propertystory, l.propertystorystatus, l.lastModificationDateTime, l.lo_comp, l.bo_comp, l.lo_comp_display, l.bo_comp_display, l.secondpublicid as listingagentsecondpublicid, l.publicid as listingagentpublicid, agents.officeid as listingagentofficeid FROM Listings_Archive l WITH (NOLOCK) LEFT JOIN Agents A WITH (NOLOCK) ON A.PublicID = L.PublicID AND A.[Status] = 'A' LEFT JOIN PropertyID WITH (NOLOCK) ON PropertyID.MLSID = l.mlsid AND PropertyID.ML_Number = l.ML_Number AND PropertyID.dbTable IN ('Commercial','Land','MultiFamily','Residential') AND PropertyID.Status = 'A' LEFT JOIN agents_teams TEAMS WITH (NOLOCK) ON TEAMS.Status = 'A' AND TEAMS.PublicID = l.publicid LEFT JOIN agents WITH (NOLOCK) ON agents.publicid = l.publicid WHERE l.id in ( select cast(value as int) from openjson( '["3457325"]' ) ) AND l.adddatetime <> '' ) dt ORDER BY list_price desc, ml_number ASC
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string13.00.1601
DriverName
stringMicrosoft JDBC Driver 12.2 for SQL Server
DriverVersion
string12.2.0.0
Datasource
stringiq_cb_tony_hubbard
DataSource
stringiq_cb_tony_hubbard
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringInvalid column name 'lo_comp_display'.
NativeErrorCode
number207
queryError
stringSELECT ROW_NUMBER() OVER ( ORDER BY list_price desc, ml_number ASC ) + 0 AS RowNumber, * FROM ( SELECT DISTINCT COMPANY = ( CASE WHEN (companyid = 'iq_cb_tony_hubbard') THEN (1) ELSE (2) END ) ,IS_OFFICE_LISTING = CASE WHEN (A.OfficeID in ('CBTH01')) THEN (1) ELSE (0) END ,IS_AGENT_LISTING = ( CASE WHEN ( LEN('8135314635') > 0 AND ( L.PUBLICID IN ('8135314635') OR L.SECONDPUBLICID IN ('8135314635') ) ) THEN (1) ELSE (0) END ), 0 AS Distance, 'f' AS iswatching, l.image_path AS ImagePath, l.url, '' AS SortOrder, '' AS AgentPublicID, '' AS AgentImagePath, '' AS AgentFirstName, '' AS AgentMiddleName, '' AS AgentLastName, '' AS AgentPhone, '' AS AgentCell, '' AS AgentFax, '' AS AgentEmail, '' AS AgentWebsiteAddress, '' AS AgentTeam, '' AS AgentCertification, '' AS AgentLicenseNumber, '' AS AgentBioPath, '' AS AgentHasBlog, '' AS AgentURL, '' AS SecondAgentPublicID, '' AS SecondAgentImagePath, '' AS SecondAgentFirstName, '' AS SecondAgentMiddleName, '' AS SecondAgentLastName, '' AS SecondAgentPhone, '' AS SecondAgentCell, '' AS SecondAgentFax, '' AS SecondAgentEmail, '' AS SecondAgentWebsiteAddress, '' AS SecondAgentTeam, '' AS SecondAgentCertification, '' AS SecondAgentLicenseNumber, '' AS SecondAgentBioPath, '' AS SecondAgentHasBlog, '' AS SecondAgentURL, '' AS OfficeID, '' AS OfficeName, '' AS OfficePhone, '' AS OfficeAddress, '' AS OfficeCity, '' AS OfficeState, '' AS OfficeZip, '' AS OfficeDomain, '' AS LogoPath, '' AS LogoPathSmall, '' AS leadpublicid, '' AS AudioTour, PropertyID.PropertyID, 'list_price' AS OrderBy, 'desc' AS OrderDirection, l.MLSID, l.listingid, l.ListingType, l.PropertyType, l.PublicID AS LA_PublicID, l.CompanyID, l.StatusCode, l.Area, l.DisplayAddress, l.DisplayRemarks, l.DisplayCMA, l.Lat, ROUND(l.Lat,5,0) as latitude, l.Lon, ROUND(l.Lon,5,0) as longitude, l.List_Price, l.LO_Name, l.LO_Phone, l.LO_Email, l.LA_Name, l.LA_Phone, l.LA_Email, l.ML_Number, l.PublicID, l.SecondPublicID, l.StreetAddress, l.City, l.State, l.Zip_Code, l.County, l.SchoolDistrict, l.ElementarySchool, l.JRHighSchool, l.HighSchool, DATEDIFF ( "D" , DATEFROMPARTS(left(l.AddDateTime,4), substring(l.AddDateTime,5, 2), substring(l.AddDateTime,7, 2)) , getdate() ) AS DaysOnSite, l.ReducedDateTime, l.AddDateTime, l.Prev_List_Price, l.VirtualTourID, l.Images, l.SubType, l.Optional_01, l.Optional_02, l.Optional_03, l.Optional_04, l.Optional_05, l.Optional_06, l.Optional_07, l.Optional_08, l.Optional_09, l.Optional_10, l.Optional_11, l.Optional_12, l.Optional_13, l.Optional_14, l.Optional_15, l.Optional_16, l.Optional_17, l.Optional_18, l.Optional_19, l.Optional_20, l.VideoTour, l.SecondVideoTour, l.MLS_Remarks, l.Description, l.MLS_StatusCode, l.Orig_List_Price, l.SalePrice, l.ListingDateTime, l.DateTime, l.ClosingDateTime, l.ContractDateTime, l.DOM, l.REO, l.ShortSale, l.LO_ID, l.LA_ID, l.BO_ID, l.BA_ID, l.BO_Name, l.BA_Name, l.image_list, l.image_data, l.custom_image_data, l.DeleteFlag, l.isprivate, '' AS OpenHouseSchedule, '' AS BathsString, l.Baths, l.FullBaths, l.HalfBaths, l.ThreeQuarterBaths, l.Beds, l.Garage, l.Style, l.sq_foot, l.Year_Built, l.Pool, l.Acreage, l.Story, l.Previews, l.Featured, l.CommunityName, l.PropertyView, l.Waterfront, l.Golfcourse, l.Basement, l.Carport, l.PatioSQ_Foot, l.BuildingName, l.UnitFloor, l.HOA, l.HoaDues, l.Zoning, l.sq_foot_Office, l.Units, l.AskingPricePersq_foot, l.SalesTerms, l.SaleType, l.sq_foot_Vacant, l.SuiteNumber, l.SuiteFloor, l.GrossBuildingArea, l.GrossLeaseArea, l.BuildingClass, l.LegalDescription, l.Occupancy, l.TenantOccupancyBasis, l.ConstructionStatus, l.YearRenovated, l.LeedCertification, l.Buildings, l.ParkingType, l.ParkingSpaces, l.PotentialRentalIncome, l.NetOperatingIncome, l.CapRate, l.InternalRateOfReturn, l.CashOnCash, l.PotentialRentalIncomeRemarks, l.NoiRemarks, l.CapRateRemarks, l.LoanBalance, l.InterestRate, l.AmortizationPeriod, l.MaturityDate, l.subarea, l.propertystory, l.propertystorystatus, l.lastModificationDateTime, l.lo_comp, l.bo_comp, l.lo_comp_display, l.bo_comp_display, l.secondpublicid as listingagentsecondpublicid, l.publicid as listingagentpublicid, agents.officeid as listingagentofficeid FROM Listings_Archive l WITH (NOLOCK) LEFT JOIN Agents A WITH (NOLOCK) ON A.PublicID = L.PublicID AND A.[Status] = 'A' LEFT JOIN PropertyID WITH (NOLOCK) ON PropertyID.MLSID = l.mlsid AND PropertyID.ML_Number = l.ML_Number AND PropertyID.dbTable IN ('Commercial','Land','MultiFamily','Residential') AND PropertyID.Status = 'A' LEFT JOIN agents_teams TEAMS WITH (NOLOCK) ON TEAMS.Status = 'A' AND TEAMS.PublicID = l.publicid LEFT JOIN agents WITH (NOLOCK) ON agents.publicid = l.publicid WHERE l.id in ( select cast(value as int) from openjson( '["3457325"]' ) ) AND l.adddatetime <> '' ) dt ORDER BY list_price desc, ml_number ASC
Sql
stringSELECT ROW_NUMBER() OVER ( ORDER BY list_price desc, ml_number ASC ) + 0 AS RowNumber, * FROM ( SELECT DISTINCT COMPANY = ( CASE WHEN (companyid = 'iq_cb_tony_hubbard') THEN (1) ELSE (2) END ) ,IS_OFFICE_LISTING = CASE WHEN (A.OfficeID in ('CBTH01')) THEN (1) ELSE (0) END ,IS_AGENT_LISTING = ( CASE WHEN ( LEN('8135314635') > 0 AND ( L.PUBLICID IN ('8135314635') OR L.SECONDPUBLICID IN ('8135314635') ) ) THEN (1) ELSE (0) END ), 0 AS Distance, 'f' AS iswatching, l.image_path AS ImagePath, l.url, '' AS SortOrder, '' AS AgentPublicID, '' AS AgentImagePath, '' AS AgentFirstName, '' AS AgentMiddleName, '' AS AgentLastName, '' AS AgentPhone, '' AS AgentCell, '' AS AgentFax, '' AS AgentEmail, '' AS AgentWebsiteAddress, '' AS AgentTeam, '' AS AgentCertification, '' AS AgentLicenseNumber, '' AS AgentBioPath, '' AS AgentHasBlog, '' AS AgentURL, '' AS SecondAgentPublicID, '' AS SecondAgentImagePath, '' AS SecondAgentFirstName, '' AS SecondAgentMiddleName, '' AS SecondAgentLastName, '' AS SecondAgentPhone, '' AS SecondAgentCell, '' AS SecondAgentFax, '' AS SecondAgentEmail, '' AS SecondAgentWebsiteAddress, '' AS SecondAgentTeam, '' AS SecondAgentCertification, '' AS SecondAgentLicenseNumber, '' AS SecondAgentBioPath, '' AS SecondAgentHasBlog, '' AS SecondAgentURL, '' AS OfficeID, '' AS OfficeName, '' AS OfficePhone, '' AS OfficeAddress, '' AS OfficeCity, '' AS OfficeState, '' AS OfficeZip, '' AS OfficeDomain, '' AS LogoPath, '' AS LogoPathSmall, '' AS leadpublicid, '' AS AudioTour, PropertyID.PropertyID, 'list_price' AS OrderBy, 'desc' AS OrderDirection, l.MLSID, l.listingid, l.ListingType, l.PropertyType, l.PublicID AS LA_PublicID, l.CompanyID, l.StatusCode, l.Area, l.DisplayAddress, l.DisplayRemarks, l.DisplayCMA, l.Lat, ROUND(l.Lat,5,0) as latitude, l.Lon, ROUND(l.Lon,5,0) as longitude, l.List_Price, l.LO_Name, l.LO_Phone, l.LO_Email, l.LA_Name, l.LA_Phone, l.LA_Email, l.ML_Number, l.PublicID, l.SecondPublicID, l.StreetAddress, l.City, l.State, l.Zip_Code, l.County, l.SchoolDistrict, l.ElementarySchool, l.JRHighSchool, l.HighSchool, DATEDIFF ( "D" , DATEFROMPARTS(left(l.AddDateTime,4), substring(l.AddDateTime,5, 2), substring(l.AddDateTime,7, 2)) , getdate() ) AS DaysOnSite, l.ReducedDateTime, l.AddDateTime, l.Prev_List_Price, l.VirtualTourID, l.Images, l.SubType, l.Optional_01, l.Optional_02, l.Optional_03, l.Optional_04, l.Optional_05, l.Optional_06, l.Optional_07, l.Optional_08, l.Optional_09, l.Optional_10, l.Optional_11, l.Optional_12, l.Optional_13, l.Optional_14, l.Optional_15, l.Optional_16, l.Optional_17, l.Optional_18, l.Optional_19, l.Optional_20, l.VideoTour, l.SecondVideoTour, l.MLS_Remarks, l.Description, l.MLS_StatusCode, l.Orig_List_Price, l.SalePrice, l.ListingDateTime, l.DateTime, l.ClosingDateTime, l.ContractDateTime, l.DOM, l.REO, l.ShortSale, l.LO_ID, l.LA_ID, l.BO_ID, l.BA_ID, l.BO_Name, l.BA_Name, l.image_list, l.image_data, l.custom_image_data, l.DeleteFlag, l.isprivate, '' AS OpenHouseSchedule, '' AS BathsString, l.Baths, l.FullBaths, l.HalfBaths, l.ThreeQuarterBaths, l.Beds, l.Garage, l.Style, l.sq_foot, l.Year_Built, l.Pool, l.Acreage, l.Story, l.Previews, l.Featured, l.CommunityName, l.PropertyView, l.Waterfront, l.Golfcourse, l.Basement, l.Carport, l.PatioSQ_Foot, l.BuildingName, l.UnitFloor, l.HOA, l.HoaDues, l.Zoning, l.sq_foot_Office, l.Units, l.AskingPricePersq_foot, l.SalesTerms, l.SaleType, l.sq_foot_Vacant, l.SuiteNumber, l.SuiteFloor, l.GrossBuildingArea, l.GrossLeaseArea, l.BuildingClass, l.LegalDescription, l.Occupancy, l.TenantOccupancyBasis, l.ConstructionStatus, l.YearRenovated, l.LeedCertification, l.Buildings, l.ParkingType, l.ParkingSpaces, l.PotentialRentalIncome, l.NetOperatingIncome, l.CapRate, l.InternalRateOfReturn, l.CashOnCash, l.PotentialRentalIncomeRemarks, l.NoiRemarks, l.CapRateRemarks, l.LoanBalance, l.InterestRate, l.AmortizationPeriod, l.MaturityDate, l.subarea, l.propertystory, l.propertystorystatus, l.lastModificationDateTime, l.lo_comp, l.bo_comp, l.lo_comp_display, l.bo_comp_display, l.secondpublicid as listingagentsecondpublicid, l.publicid as listingagentpublicid, agents.officeid as listingagentofficeid FROM Listings_Archive l WITH (NOLOCK) LEFT JOIN Agents A WITH (NOLOCK) ON A.PublicID = L.PublicID AND A.[Status] = 'A' LEFT JOIN PropertyID WITH (NOLOCK) ON PropertyID.MLSID = l.mlsid AND PropertyID.ML_Number = l.ML_Number AND PropertyID.dbTable IN ('Commercial','Land','MultiFamily','Residential') AND PropertyID.Status = 'A' LEFT JOIN agents_teams TEAMS WITH (NOLOCK) ON TEAMS.Status = 'A' AND TEAMS.PublicID = l.publicid LEFT JOIN agents WITH (NOLOCK) ON agents.publicid = l.publicid WHERE l.id in ( select cast(value as int) from openjson( '["3457325"]' ) ) AND l.adddatetime <> '' ) dt ORDER BY list_price desc, ml_number ASC
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: Invalid column name 'lo_comp_display'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1695) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:620) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:539) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7685) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4048) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:272) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:246) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:516) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:328) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:296) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135) at lucee.runtime.tag.Query._doEndTag(Query.java:700) at lucee.runtime.tag.Query.doEndTag(Query.java:566) at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:86) at iqquery_cfc$cf.udfCall1(/iqquery.cfc:247) at iqquery_cfc$cf.udfCall(/iqquery.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:786) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1775) at iqquery_cfc$cf.udfCall1(/iqquery.cfc:132) at iqquery_cfc$cf.udfCall(/iqquery.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952) at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:560) at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:206) at components.listings_cfc$cf$5.udfCall1_000020(/components/listings.cfc:1258) at components.listings_cfc$cf$5.udfCall1(/components/listings.cfc:892) at components.listings_cfc$cf$5.udfCall(/components/listings.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1947) at lucee.runtime.tag.Invoke.doComponent(Invoke.java:209) at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:186) at components.listing_cfc$cf.udfCall(/components/listing.cfc:46) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:699) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1947) at lucee.runtime.tag.Invoke.doComponent(Invoke.java:209) at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:186) at app._utils_printlisting_cfm322$cf.call(/app/_utils.printlisting.cfm:23) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at lib.iq_cfc$cf$1.udfCall1(/lib/iq.cfc:112) at lib.iq_cfc$cf$1.udfCall(/lib/iq.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1775) at app._utils_cfm$cf.call(/app/_utils.cfm:2) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at lib.iq_cfc$cf$1.udfCall1(/lib/iq.cfc:87) at lib.iq_cfc$cf$1.udfCall(/lib/iq.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:786) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1775) at lib.iq_cfc$cf$1.udfCall1(/lib/iq.cfc:43) at lib.iq_cfc$cf$1.udfCall(/lib/iq.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:786) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1775) at lib.iq_cfc$cf$1.udfCall1(/lib/iq.cfc:28) at lib.iq_cfc$cf$1.udfCall(/lib/iq.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1775) at application_cfc$cf.udfCall(/application.cfc:246) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218) at lucee.runtime.listener.ModernAppListener.onRequest(ModernAppListener.java:107) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) at org.apache.tomcat.util.net.Nio2Endpoint$SocketProcessor.doRun(Nio2Endpoint.java:1713) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.net.AbstractEndpoint.processSocket(AbstractEndpoint.java:1265) at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:641) at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:619) at java.base/sun.nio.ch.Invoker.invokeUnchecked(Invoker.java:127) at java.base/sun.nio.ch.Invoker$2.run(Invoker.java:219) at java.base/sun.nio.ch.AsynchronousChannelGroupImpl$1.run(AsynchronousChannelGroupImpl.java:112) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:829)
TagContext
Array
Rows: 12
1
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number247
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:247)
template
string/iqquery.cfc
type
stringcfml
2
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number132
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:132)
template
string/iqquery.cfc
type
stringcfml
3
Struct
codePrintHTML
string1256: #arguments.OrderBy# #LCase(arguments.OrderDirection)#,<br> 1257: ml_number ASC<br> <b>1258: &lt;/cfiqquery&gt;</b><br> 1259: <br> 1260: &lt;!--- was it cached or not ---&gt;<br>
codePrintPlain
string1256: #arguments.OrderBy# #LCase(arguments.OrderDirection)#, 1257: ml_number ASC 1258: </cfiqquery> 1259: 1260: <!--- was it cached or not --->
column
number0
id
string??
line
number1258
Raw_Trace
stringcomponents.listings_cfc$cf$5.udfCall1_000020(/components/listings.cfc:1258)
template
stringC:\backatyou\code\sites\components\listings.cfc
type
stringcfml
4
Struct
codePrintHTML
string890: &lt;cfset local.retVal.TotalRowCount = rsCount.RecordCount&gt;<br> 891: <br> <b>892: &lt;cfif arguments.countonly EQ &quot;f&quot;&gt;</b><br> 893: &lt;!--- REVIEW COUNT QUERY RESULTS BEFORE GETTING FULL LISTING DETAILS ---&gt;<br> 894: &lt;cfif arguments.RowLimit NEQ 0 AND local.retVal.TotalRowCount GT arguments.RowLimit&gt;<br>
codePrintPlain
string890: <cfset local.retVal.TotalRowCount = rsCount.RecordCount> 891: 892: <cfif arguments.countonly EQ "f"> 893: <!--- REVIEW COUNT QUERY RESULTS BEFORE GETTING FULL LISTING DETAILS ---> 894: <cfif arguments.RowLimit NEQ 0 AND local.retVal.TotalRowCount GT arguments.RowLimit>
column
number0
id
string??
line
number892
Raw_Trace
stringcomponents.listings_cfc$cf$5.udfCall1(/components/listings.cfc:892)
template
stringC:\backatyou\code\sites\components\listings.cfc
type
stringcfml
5
Struct
codePrintHTML
string44: &lt;cfinvokeargument name=&quot;propertytype&quot; value=&quot;#arguments.propertytype#&quot;&gt;<br> 45: &lt;cfinvokeargument name=&quot;view_from&quot; value=&quot;#arguments.view_from#&quot;&gt;<br> <b>46: &lt;/cfinvoke&gt;</b><br> 47: <br> 48: &lt;cfif retListing.Status EQ 1&gt;<br>
codePrintPlain
string44: <cfinvokeargument name="propertytype" value="#arguments.propertytype#"> 45: <cfinvokeargument name="view_from" value="#arguments.view_from#"> 46: </cfinvoke> 47: 48: <cfif retListing.Status EQ 1>
column
number0
id
string??
line
number46
Raw_Trace
stringcomponents.listing_cfc$cf.udfCall(/components/listing.cfc:46)
template
stringC:\backatyou\code\sites\components\listing.cfc
type
stringcfml
6
Struct
codePrintHTML
string21: &lt;cfinvokeargument name=&quot;view_from&quot; value=&quot;Print Listing Page&quot;&gt;<br> 22: &lt;cfinvokeargument name=&quot;layout&quot; value=&quot;print&quot;&gt;<br> <b>23: &lt;/cfinvoke&gt;</b><br> 24: &lt;/cfif&gt;<br> 25: <br>
codePrintPlain
string21: <cfinvokeargument name="view_from" value="Print Listing Page"> 22: <cfinvokeargument name="layout" value="print"> 23: </cfinvoke> 24: </cfif> 25:
column
number0
id
string??
line
number23
Raw_Trace
stringapp._utils_printlisting_cfm322$cf.call(/app/_utils.printlisting.cfm:23)
template
stringC:\backatyou\code\sites\app\_utils.printlisting.cfm
type
stringcfml
7
Struct
codePrintHTML
string110: <br> 111: &lt;cfif fileExists(&quot;#request.appAbsolutePath#/app/_#local.PageName#.cfm&quot;)&gt;<br> <b>112: &lt;cfinclude template=&quot;/app/_#local.PageName#.cfm&quot; /&gt;</b><br> 113: &lt;cfelse&gt;<br> 114: &lt;cfset MissingFile = local.PageName&gt;<br>
codePrintPlain
string110: 111: <cfif fileExists("#request.appAbsolutePath#/app/_#local.PageName#.cfm")> 112: <cfinclude template="/app/_#local.PageName#.cfm" /> 113: <cfelse> 114: <cfset MissingFile = local.PageName>
column
number0
id
string??
line
number112
Raw_Trace
stringlib.iq_cfc$cf$1.udfCall1(/lib/iq.cfc:112)
template
stringC:\backatyou\code\sites\lib\iq.cfc
type
stringcfml
8
Struct
codePrintHTML
string1: &lt;cfoutput&gt;<br> <b>2: #request.iqlib.renderCat()#</b><br> 3: &lt;/cfoutput&gt;<br>
codePrintPlain
string1: <cfoutput> 2: #request.iqlib.renderCat()# 3: </cfoutput>
column
number0
id
string??
line
number2
Raw_Trace
stringapp._utils_cfm$cf.call(/app/_utils.cfm:2)
template
stringC:\backatyou\code\sites\app\_utils.cfm
type
stringcfml
9
Struct
codePrintHTML
string85: &lt;cfelse&gt; ---&gt;<br> 86: &lt;cfif fileExists(&quot;#request.appAbsolutePath#/app/_#local.PageName#.cfm&quot;)&gt;<br> <b>87: &lt;cfinclude template=&quot;/app/_#local.PageName#.cfm&quot; /&gt;</b><br> 88: &lt;cfelse&gt;<br> 89: &lt;cfset MissingFile = local.PageName&gt;<br>
codePrintPlain
string85: <cfelse> ---> 86: <cfif fileExists("#request.appAbsolutePath#/app/_#local.PageName#.cfm")> 87: <cfinclude template="/app/_#local.PageName#.cfm" /> 88: <cfelse> 89: <cfset MissingFile = local.PageName>
column
number0
id
string??
line
number87
Raw_Trace
stringlib.iq_cfc$cf$1.udfCall1(/lib/iq.cfc:87)
template
stringC:\backatyou\code\sites\lib\iq.cfc
type
stringcfml
10
Struct
codePrintHTML
string41: &lt;cfif local.Layout EQ &quot;none&quot;&gt;<br> 42: &lt;cfscript&gt;<br> <b>43: RenderPage();</b><br> 44: &lt;/cfscript&gt;<br> 45: &lt;cfelse&gt;<br>
codePrintPlain
string41: <cfif local.Layout EQ "none"> 42: <cfscript> 43: RenderPage(); 44: </cfscript> 45: <cfelse>
column
number0
id
string??
line
number43
Raw_Trace
stringlib.iq_cfc$cf$1.udfCall1(/lib/iq.cfc:43)
template
stringC:\backatyou\code\sites\lib\iq.cfc
type
stringcfml
11
Struct
codePrintHTML
string26: &lt;/cfif&gt;<br> 27: &lt;cfscript&gt;<br> <b>28: doLayout();</b><br> 29: &lt;/cfscript&gt;<br> 30: &lt;/cfif&gt;<br>
codePrintPlain
string26: </cfif> 27: <cfscript> 28: doLayout(); 29: </cfscript> 30: </cfif>
column
number0
id
string??
line
number28
Raw_Trace
stringlib.iq_cfc$cf$1.udfCall1(/lib/iq.cfc:28)
template
stringC:\backatyou\code\sites\lib\iq.cfc
type
stringcfml
12
Struct
codePrintHTML
string244: &lt;cfset local.url.process(CGI.path_info) /&gt;<br> 245: &lt;cfsavecontent variable=&quot;template_layout&quot;&gt;<br> <b>246: &lt;cfoutput&gt;#request.iqlib.RenderContent()#&lt;/cfoutput&gt;</b><br> 247: &lt;/cfsavecontent&gt;<br> 248: <br>
codePrintPlain
string244: <cfset local.url.process(CGI.path_info) /> 245: <cfsavecontent variable="template_layout"> 246: <cfoutput>#request.iqlib.RenderContent()#</cfoutput> 247: </cfsavecontent> 248:
column
number0
id
string??
line
number246
Raw_Trace
stringapplication_cfc$cf.udfCall(/application.cfc:246)
template
stringC:\backatyou\code\sites\application.cfc
type
stringcfml
type
stringdatabase
where
string