Dump Results
Catch
Entries: 15
additional
Struct (ordered)
SQL
stringDECLARE @PageNumber AS INT, @RowspPage AS INTSET @PageNumber = 1SET @RowspPage = 25select *, ROW_NUMBER() OVER (ORDER BY ID ASC, List_Price desc) AS RowNumberfrom (SELECT ID = (CASEWHEN (companyid = 'iq_cb_select') 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 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 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.PropertyType,l.PublicID AS LA_PublicID,l.CompanyID,l.StatusCode,l.Area,l.DisplayAddress,l.DisplayRemarks,l.DisplayCMA,l.Lat,l.Lon,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.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.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.secondpublicid as listingagentsecondpublicid,l.publicid as listingagentpublicid,agents.officeid as listingagentofficeid,agents_teams_members.agentteamid as listingagentteamidFROM Listings l WITH (NOLOCK)LEFT OUTER JOIN PropertyID WITH (NOLOCK)ON PropertyID.MLSID = l.mlsidAND PropertyID.ML_Number = l.ML_NumberAND PropertyID.dbTable IN ('Commercial','Land','MultiFamily','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')LEFT OUTER JOIN agents WITH (NOLOCK)ON agents.publicid = l.publicidWHERE (l.mlsid IN ('mls_tulsa'))AND (l.propertytype IN ('Commercial','Land','MultiFamily','Residential')))dt ORDER BY ID ASC, List_Price desc, ML_Number ASCOFFSET ((@PageNumber - 1) * @RowspPage) ROWSFETCH NEXT @RowspPage ROWS ONLY;
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string12.00.2000
DriverName
stringMicrosoft JDBC Driver 4.0 for SQL Server
DriverVersion
string4.0.2206.100
Datasource
stringiq_cb_select
DataSource
stringiq_cb_select
Detail
stringCannot construct data type date, some of the arguments have values which are not valid.
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
string
NativeErrorCode
number289
queryError
stringDECLARE @PageNumber AS INT, @RowspPage AS INTSET @PageNumber = 1SET @RowspPage = 25select *, ROW_NUMBER() OVER (ORDER BY ID ASC, List_Price desc) AS RowNumberfrom (SELECT ID = (CASEWHEN (companyid = 'iq_cb_select') 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 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 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.PropertyType,l.PublicID AS LA_PublicID,l.CompanyID,l.StatusCode,l.Area,l.DisplayAddress,l.DisplayRemarks,l.DisplayCMA,l.Lat,l.Lon,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.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.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.secondpublicid as listingagentsecondpublicid,l.publicid as listingagentpublicid,agents.officeid as listingagentofficeid,agents_teams_members.agentteamid as listingagentteamidFROM Listings l WITH (NOLOCK)LEFT OUTER JOIN PropertyID WITH (NOLOCK)ON PropertyID.MLSID = l.mlsidAND PropertyID.ML_Number = l.ML_NumberAND PropertyID.dbTable IN ('Commercial','Land','MultiFamily','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')LEFT OUTER JOIN agents WITH (NOLOCK)ON agents.publicid = l.publicidWHERE (l.mlsid IN ('mls_tulsa'))AND (l.propertytype IN ('Commercial','Land','MultiFamily','Residential')))dt ORDER BY ID ASC, List_Price desc, ML_Number ASCOFFSET ((@PageNumber - 1) * @RowspPage) ROWSFETCH NEXT @RowspPage ROWS ONLY;
Sql
stringDECLARE @PageNumber AS INT, @RowspPage AS INTSET @PageNumber = 1SET @RowspPage = 25select *, ROW_NUMBER() OVER (ORDER BY ID ASC, List_Price desc) AS RowNumberfrom (SELECT ID = (CASEWHEN (companyid = 'iq_cb_select') 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 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 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.PropertyType,l.PublicID AS LA_PublicID,l.CompanyID,l.StatusCode,l.Area,l.DisplayAddress,l.DisplayRemarks,l.DisplayCMA,l.Lat,l.Lon,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.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.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.secondpublicid as listingagentsecondpublicid,l.publicid as listingagentpublicid,agents.officeid as listingagentofficeid,agents_teams_members.agentteamid as listingagentteamidFROM Listings l WITH (NOLOCK)LEFT OUTER JOIN PropertyID WITH (NOLOCK)ON PropertyID.MLSID = l.mlsidAND PropertyID.ML_Number = l.ML_NumberAND PropertyID.dbTable IN ('Commercial','Land','MultiFamily','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')LEFT OUTER JOIN agents WITH (NOLOCK)ON agents.publicid = l.publicidWHERE (l.mlsid IN ('mls_tulsa'))AND (l.propertytype IN ('Commercial','Land','MultiFamily','Residential')))dt ORDER BY ID ASC, List_Price desc, ML_Number ASCOFFSET ((@PageNumber - 1) * @RowspPage) ROWSFETCH NEXT @RowspPage ROWS ONLY;
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:4853)at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1781)at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1034)at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:450)at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:283)at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:221)at lucee.runtime.tag.Query.executeDatasoure(Query.java:839)at lucee.runtime.tag.Query.doEndTag(Query.java:597)at org.lucee.cfml.base_cfc$cf.udfCall1(/org/lucee/cfml/Base.cfc:110)at org.lucee.cfml.base_cfc$cf.udfCall(/org/lucee/cfml/Base.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:772)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:755)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1697)at org.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:53)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:211)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1935)at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:825)at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1712)at iqquery_cfc$cf.udfCall1(/iqquery.cfc:232)at iqquery_cfc$cf.udfCall(/iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1918)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:755)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1697)at iqquery_cfc$cf.udfCall1(/iqquery.cfc:141)at iqquery_cfc$cf.udfCall(/iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:211)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1935)at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:569)at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:207)at components.listings_cfc$cf.udfCall1_000022(/components/listings.cfc:1101)at components.listings_cfc$cf.udfCall1(/components/listings.cfc:702)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:338)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:211)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1931)at lucee.runtime.tag.Invoke.doComponent(Invoke.java:221)at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:194)at components.listing_cfc$cf.udfCall(/components/listing.cfc:34)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:211)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1931)at lucee.runtime.tag.Invoke.doComponent(Invoke.java:221)at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:194)at iqweb.app._slw_cfm$cf.call(/iqapp_mappath/iqweb/app/_slw.cfm:9)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:924)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:838)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:822)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:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:772)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:755)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1697)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:57)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:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:772)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:755)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1697)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:42)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:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1918)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:755)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1697)at application_cfc$cf.udfCall(/Application.cfc:265)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:338)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:225)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1918)at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:422)at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:224)at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2394)at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2385)at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2353)at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:907)at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102)at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:62)at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684)at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501)at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557)at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086)at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:428)at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020)at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:245)at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154)at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)at org.eclipse.jetty.server.Server.handle(Server.java:370)at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494)at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:971)at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1033)at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644)at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:667)at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)at java.lang.Thread.run(Thread.java:745)
TagContext
Array
Rows: 12
1
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number110
Raw_Trace
stringorg.lucee.cfml.base_cfc$cf.udfCall1(/org/lucee/cfml/Base.cfc:110)
template
string/org/lucee/cfml/Base.cfc
type
stringcfml
2
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number53
Raw_Trace
stringorg.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:53)
template
string/org/lucee/cfml/Query.cfc
type
stringcfml
3
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number232
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:232)
template
string/iqquery.cfc
type
stringcfml
4
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number141
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:141)
template
string/iqquery.cfc
type
stringcfml
5
Struct
codePrintHTML
string1099: 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;)<br>1100: &lt;/cfif&gt;<br><b>1101: &lt;/cfif&gt;</b><br>1102: )dt<br>1103: <br>
codePrintPlain
string1099: 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">)1100: </cfif>1101: </cfif>1102: )dt1103:
column
number0
id
string??
line
number1101
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall1_000022(/components/listings.cfc:1101)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
6
Struct
codePrintHTML
string700: &lt;cfif arguments.countonly neq &quot;f&quot;&gt;<br>701: &lt;cfreturn local.retval&gt;<br><b>702: &lt;/cfif&gt;</b><br>703: <br>704: &lt;!--- only do this durring debugging ---&gt;<br>
codePrintPlain
string700: <cfif arguments.countonly neq "f">701: <cfreturn local.retval>702: </cfif>703: 704: <!--- only do this durring debugging --->
column
number0
id
string??
line
number702
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall1(/components/listings.cfc:702)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
7
Struct
codePrintHTML
string32: &lt;cfinvokeargument name=&quot;propertytype&quot; value=&quot;#arguments.propertytype#&quot;&gt;<br>33: &lt;cfinvokeargument name=&quot;view_from&quot; value=&quot;#arguments.view_from#&quot;&gt;<br><b>34: &lt;/cfinvoke&gt;</b><br>35: <br>36: &lt;cfif retListing.Status EQ 1&gt;<br>
codePrintPlain
string32: <cfinvokeargument name="propertytype" value="#arguments.propertytype#">33: <cfinvokeargument name="view_from" value="#arguments.view_from#">34: </cfinvoke>35: 36: <cfif retListing.Status EQ 1>
column
number0
id
string??
line
number34
Raw_Trace
stringcomponents.listing_cfc$cf.udfCall(/components/listing.cfc:34)
template
stringC:\realistiq\production\iqweb\components\listing.cfc
type
stringcfml
8
Struct
codePrintHTML
string7: &lt;cfinvokeargument name=&quot;MLNumber&quot; value=&quot;#REQUEST.DOMAIN.ML_Number#&quot;&gt;<br>8: &lt;cfinvokeargument name=&quot;PropertyType&quot; value=&quot;#REQUEST.DOMAIN.PropertyType_List#&quot;&gt;<br><b>9: &lt;/cfinvoke&gt;</b><br>10: &lt;cfif retListing.status neq 0&gt;<br>11: #retListing.content#<br>
codePrintPlain
string7: <cfinvokeargument name="MLNumber" value="#REQUEST.DOMAIN.ML_Number#">8: <cfinvokeargument name="PropertyType" value="#REQUEST.DOMAIN.PropertyType_List#">9: </cfinvoke>10: <cfif retListing.status neq 0>11: #retListing.content#
column
number0
id
string??
line
number9
Raw_Trace
stringiqweb.app._slw_cfm$cf.call(/iqapp_mappath/iqweb/app/_slw.cfm:9)
template
stringC:\realistiq\production\iqweb\app\_slw.cfm
type
stringcfml
9
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
10
Struct
codePrintHTML
string55: &lt;cfif local.Layout EQ &quot;none&quot;&gt;<br>56: &lt;cfscript&gt;<br><b>57: RenderPage();</b><br>58: &lt;/cfscript&gt;<br>59: &lt;cfelse&gt;<br>
codePrintPlain
string55: <cfif local.Layout EQ "none">56: <cfscript>57: RenderPage();58: </cfscript>59: <cfelse>
column
number0
id
string??
line
number57
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:57)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
11
Struct
codePrintHTML
string40: <br>41: &lt;cfscript&gt;<br><b>42: doLayout();</b><br>43: &lt;/cfscript&gt;<br>44: &lt;/cfif&gt;<br>
codePrintPlain
string40: 41: <cfscript>42: doLayout();43: </cfscript>44: </cfif>
column
number0
id
string??
line
number42
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:42)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
12
Struct
codePrintHTML
string263: local.url.process(cgi.path_info);<br>264: <br><b>265: writeOutput(request.iqLib.RenderContent());</b><br>266: }<br>267: }<br>
codePrintPlain
string263: local.url.process(cgi.path_info);264: 265: writeOutput(request.iqLib.RenderContent());266: }267: }
column
number0
id
string??
line
number265
Raw_Trace
stringapplication_cfc$cf.udfCall(/Application.cfc:265)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string