SITE:kevinmcfall.zhouserealtygroup.com
SERVER:iq-web-0
DATA SERVER:cust-sql-1
COMPANY ID:iq_zhouse
USER:N/A
ACTING AS:N/A
REFERER:
REMOTE ADDRESS:3.223.3.101
USER AGENT:CCBot/2.0 (https://commoncrawl.org/faq/)
REQUEST URL:http://kevinmcfall.zhouserealtygroup.com/print/16000-gulf-shores-drive-boca-grande-fl-33921/40-1807338
DATE:03/30/2020 16:21:40



Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT *, ROW_NUMBER() OVER (ORDER BY list_price desc) + 0 AS RowNumber FROM ( SELECT COMPANY = ( CASE WHEN (companyid = 'iq_zhouse') THEN (1) ELSE (2) END ), 0 AS Distance, 'f' AS iswatching, l.image_path AS ImagePath, l.url, '' AS SortOrder, '' AS AgentPublicID, '' AS AgentImagePath, '' AS AgentFirstName, '' 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 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.LA_Name, 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(AddDateTime,4), substring(AddDateTime,5, 2), substring(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.secondpublicid as listingagentsecondpublicid, l.publicid as listingagentpublicid, agents.officeid as listingagentofficeid, agents_teams_members.agentteamid as listingagentteamid FROM Listings l WITH (NOLOCK) LEFT OUTER JOIN PropertyID WITH (NOLOCK) ON PropertyID.MLSID = l.mlsid AND PropertyID.ML_Number = l.ML_Number AND PropertyID.dbTable IN ('residential') AND PropertyID.Status = 'A' LEFT OUTER JOIN agents_teams_members WITH (NOLOCK) ON agents_teams_members.publicid = l.publicid and agents_teams_members.publicid in (select publicid from agents_teams where agents_teams.status = 'a') and agents_teams_members.publicid not in (select publicid from agents_teams where agents_teams.status = 'i') LEFT OUTER JOIN agents WITH (NOLOCK) ON agents.publicid = l.publicid WHERE l.id in (1170739,2244447,2670048,1209716,1387975,1145827,2687327,1022287,133413,2688184,645995,1178118,1765835,1209762,1350235,1413916,2677346,1812030,339954,1682594,1486274,1257500,1386419,1791416,1751973) ) dt ORDER BY list_price desc, ml_number ASC
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string13.00.1601
DriverName
stringMicrosoft JDBC Driver 6.2 for SQL Server
DriverVersion
string6.2.2.0
Datasource
stringiq_zhouse
DataSource
stringiq_zhouse
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 *, ROW_NUMBER() OVER (ORDER BY list_price desc) + 0 AS RowNumber FROM ( SELECT COMPANY = ( CASE WHEN (companyid = 'iq_zhouse') THEN (1) ELSE (2) END ), 0 AS Distance, 'f' AS iswatching, l.image_path AS ImagePath, l.url, '' AS SortOrder, '' AS AgentPublicID, '' AS AgentImagePath, '' AS AgentFirstName, '' 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 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.LA_Name, 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(AddDateTime,4), substring(AddDateTime,5, 2), substring(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.secondpublicid as listingagentsecondpublicid, l.publicid as listingagentpublicid, agents.officeid as listingagentofficeid, agents_teams_members.agentteamid as listingagentteamid FROM Listings l WITH (NOLOCK) LEFT OUTER JOIN PropertyID WITH (NOLOCK) ON PropertyID.MLSID = l.mlsid AND PropertyID.ML_Number = l.ML_Number AND PropertyID.dbTable IN ('residential') AND PropertyID.Status = 'A' LEFT OUTER JOIN agents_teams_members WITH (NOLOCK) ON agents_teams_members.publicid = l.publicid and agents_teams_members.publicid in (select publicid from agents_teams where agents_teams.status = 'a') and agents_teams_members.publicid not in (select publicid from agents_teams where agents_teams.status = 'i') LEFT OUTER JOIN agents WITH (NOLOCK) ON agents.publicid = l.publicid WHERE l.id in (1170739,2244447,2670048,1209716,1387975,1145827,2687327,1022287,133413,2688184,645995,1178118,1765835,1209762,1350235,1413916,2677346,1812030,339954,1682594,1486274,1257500,1386419,1791416,1751973) ) dt ORDER BY list_price desc, ml_number ASC
Sql
stringSELECT *, ROW_NUMBER() OVER (ORDER BY list_price desc) + 0 AS RowNumber FROM ( SELECT COMPANY = ( CASE WHEN (companyid = 'iq_zhouse') THEN (1) ELSE (2) END ), 0 AS Distance, 'f' AS iswatching, l.image_path AS ImagePath, l.url, '' AS SortOrder, '' AS AgentPublicID, '' AS AgentImagePath, '' AS AgentFirstName, '' 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 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.LA_Name, 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(AddDateTime,4), substring(AddDateTime,5, 2), substring(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.secondpublicid as listingagentsecondpublicid, l.publicid as listingagentpublicid, agents.officeid as listingagentofficeid, agents_teams_members.agentteamid as listingagentteamid FROM Listings l WITH (NOLOCK) LEFT OUTER JOIN PropertyID WITH (NOLOCK) ON PropertyID.MLSID = l.mlsid AND PropertyID.ML_Number = l.ML_Number AND PropertyID.dbTable IN ('residential') AND PropertyID.Status = 'A' LEFT OUTER JOIN agents_teams_members WITH (NOLOCK) ON agents_teams_members.publicid = l.publicid and agents_teams_members.publicid in (select publicid from agents_teams where agents_teams.status = 'a') and agents_teams_members.publicid not in (select publicid from agents_teams where agents_teams.status = 'i') LEFT OUTER JOIN agents WITH (NOLOCK) ON agents.publicid = l.publicid WHERE l.id in (1170739,2244447,2670048,1209716,1387975,1145827,2687327,1022287,133413,2688184,645995,1178118,1765835,1209762,1350235,1413916,2677346,1812030,339954,1682594,1486274,1257500,1386419,1791416,1751973) ) dt ORDER BY list_price desc, ml_number ASC
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:478) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:278) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:215) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1060) at lucee.runtime.tag.Query._doEndTag(Query.java:660) at lucee.runtime.tag.Query.doEndTag(Query.java:542) 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: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 iqquery_cfc$cf.udfCall1(/iqquery.cfc:155) at iqquery_cfc$cf.udfCall(/iqquery.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:1917) at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:542) at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:204) at components.listings_cfc$cf.udfCall2(/components/listings.cfc:1709) 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 components.listing_cfc$cf.udfCall(/components/listing.cfc:44) 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._utils_printlisting_cfm322$cf.call(/production/iqweb/app/_utils.printlisting.cfm:24) 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:109) 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.app._utils_cfm$cf.call(/production/iqweb/app/_utils.cfm:2) 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.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:55) 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
Rows: 11
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
string1707: ml_number ASC<br> 1708: <br> <b>1709: &lt;/cfiqquery&gt;</b><br> 1710: <br> 1711: &lt;!--- was it cached or not ---&gt;<br>
codePrintPlain
string1707: ml_number ASC 1708: 1709: </cfiqquery> 1710: 1711: <!--- was it cached or not --->
column
number0
id
string??
line
number1709
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall2(/components/listings.cfc:1709)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
4
Struct
codePrintHTML
string42: &lt;cfinvokeargument name=&quot;propertytype&quot; value=&quot;#arguments.propertytype#&quot;&gt;<br> 43: &lt;cfinvokeargument name=&quot;view_from&quot; value=&quot;#arguments.view_from#&quot;&gt;<br> <b>44: &lt;/cfinvoke&gt;</b><br> 45: <br> 46: &lt;cfif retListing.Status EQ 1&gt;<br>
codePrintPlain
string42: <cfinvokeargument name="propertytype" value="#arguments.propertytype#"> 43: <cfinvokeargument name="view_from" value="#arguments.view_from#"> 44: </cfinvoke> 45: 46: <cfif retListing.Status EQ 1>
column
number0
id
string??
line
number44
Raw_Trace
stringcomponents.listing_cfc$cf.udfCall(/components/listing.cfc:44)
template
stringC:\realistiq\production\iqweb\components\listing.cfc
type
stringcfml
5
Struct
codePrintHTML
string22: &lt;cfinvokeargument name=&quot;view_from&quot; value=&quot;Print Listing Page&quot;&gt;<br> 23: &lt;cfinvokeargument name=&quot;layout&quot; value=&quot;print&quot;&gt;<br> <b>24: &lt;/cfinvoke&gt;</b><br> 25: &lt;/cfif&gt;<br> 26: <br>
codePrintPlain
string22: <cfinvokeargument name="view_from" value="Print Listing Page"> 23: <cfinvokeargument name="layout" value="print"> 24: </cfinvoke> 25: </cfif> 26:
column
number0
id
string??
line
number24
Raw_Trace
stringiqweb.app._utils_printlisting_cfm322$cf.call(/production/iqweb/app/_utils.printlisting.cfm:24)
template
stringC:\realistiq\production\iqweb\app\_utils.printlisting.cfm
type
stringcfml
6
Struct
codePrintHTML
string107: <br> 108: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/app/_#local.PageName#.cfm&quot;)&gt;<br> <b>109: &lt;cfinclude template=&quot;#request.AppMapPath#/app/_#local.PageName#.cfm&quot; /&gt;</b><br> 110: &lt;cfelse&gt;<br> 111: &lt;cfset MissingFile = local.PageName&gt;<br>
codePrintPlain
string107: 108: <cfif FileExists("#request.AppAbsolutePath#/app/_#local.PageName#.cfm")> 109: <cfinclude template="#request.AppMapPath#/app/_#local.PageName#.cfm" /> 110: <cfelse> 111: <cfset MissingFile = local.PageName>
column
number0
id
string??
line
number109
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:109)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
7
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
stringiqweb.app._utils_cfm$cf.call(/production/iqweb/app/_utils.cfm:2)
template
stringC:\realistiq\production\iqweb\app\_utils.cfm
type
stringcfml
8
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
9
Struct
codePrintHTML
string53: &lt;cfif local.Layout EQ &quot;none&quot;&gt;<br> 54: &lt;cfscript&gt;<br> <b>55: RenderPage();</b><br> 56: &lt;/cfscript&gt;<br> 57: &lt;cfelse&gt;<br>
codePrintPlain
string53: <cfif local.Layout EQ "none"> 54: <cfscript> 55: RenderPage(); 56: </cfscript> 57: <cfelse>
column
number0
id
string??
line
number55
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:55)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
10
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
11
Struct
codePrintHTML
string343: &lt;cfset local.url = new lib.url() /&gt;<br> 344: &lt;cfset local.url.process(CGI.path_info) /&gt;<br> <b>345: &lt;cfoutput&gt;#request.iqlib.RenderContent()#&lt;/cfoutput&gt;</b><br> 346: &lt;/cfif&gt;<br> 347: &lt;/cfif&gt;<br>
codePrintPlain
string343: <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
number0
id
string??
line
number345
Raw_Trace
stringapplication_cfc$cf.udfCall(/application.cfc:345)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string