Dump Results
Catch
Entries: 15
additional
Struct
SQL
stringSELECT *FROM(SELECT *,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,'/assets/img/nophoto/nophoto-listings.jpg' AS ImagePath,'/assets/img/nophoto/nophoto-listings-thumb.jpg' AS ThumbPath,'/listing/68-' + cast(tblmls_tulsa_Listings.listingid as varchar) + '/' + lower(replace(replace(replace(tblmls_tulsa_Listings.streetaddress, ' ', '-'), '#', ''), '&', '')) + '-' + lower(replace(tblmls_tulsa_Listings.city, ' ', '-')) + '-' + lower(tblmls_tulsa_Listings.state) + '-' + tblmls_tulsa_Listings.zip_code as url,'' AS SortOrder,'' AS AgentPublicID,'' AS AgentImagePath,'' AS AgentThumbPath,'' 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 SecondAgentThumbPath,'' 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,'mls_tulsa' AS MLSID,tblmls_tulsa_Listings.listingid,tblmls_tulsa_Listings.PropertyType,tblmls_tulsa_Listings.PublicID AS LA_PublicID,tblmls_tulsa_Listings.CompanyID,tblmls_tulsa_Listings.StatusCode,tblmls_tulsa_Listings.Area,tblmls_tulsa_Listings.DisplayAddress,tblmls_tulsa_Listings.DisplayRemarks,tblmls_tulsa_Listings.DisplayCMA,tblmls_tulsa_Listings.Lat,tblmls_tulsa_Listings.Lon,tblmls_tulsa_Listings.List_Price,tblmls_tulsa_Listings.LO_Name,tblmls_tulsa_Listings.LA_Name,tblmls_tulsa_Listings.ML_Number,tblmls_tulsa_Listings.PublicID,tblmls_tulsa_Listings.SecondPublicID,tblmls_tulsa_Listings.StreetAddress,tblmls_tulsa_Listings.City,tblmls_tulsa_Listings.State,tblmls_tulsa_Listings.Zip_Code,tblmls_tulsa_Listings.County,tblmls_tulsa_Listings.SchoolDistrict,tblmls_tulsa_Listings.ElementarySchool,tblmls_tulsa_Listings.JRHighSchool,tblmls_tulsa_Listings.HighSchool,DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() ) AS DaysOnSite,tblmls_tulsa_Listings.ReducedDateTime,tblmls_tulsa_Listings.AddDateTime,tblmls_tulsa_Listings.Prev_List_Price,tblmls_tulsa_Listings.VirtualTourID,tblmls_tulsa_Listings.Images,tblmls_tulsa_Listings.SubType,tblmls_tulsa_Listings.Optional_01,tblmls_tulsa_Listings.Optional_02,tblmls_tulsa_Listings.Optional_03,tblmls_tulsa_Listings.Optional_04,tblmls_tulsa_Listings.Optional_05,tblmls_tulsa_Listings.Optional_06,tblmls_tulsa_Listings.Optional_07,tblmls_tulsa_Listings.Optional_08,tblmls_tulsa_Listings.Optional_09,tblmls_tulsa_Listings.Optional_10,tblmls_tulsa_Listings.Optional_11,tblmls_tulsa_Listings.Optional_12,tblmls_tulsa_Listings.Optional_13,tblmls_tulsa_Listings.Optional_14,tblmls_tulsa_Listings.Optional_15,tblmls_tulsa_Listings.Optional_16,tblmls_tulsa_Listings.Optional_17,tblmls_tulsa_Listings.Optional_18,tblmls_tulsa_Listings.Optional_19,tblmls_tulsa_Listings.Optional_20,tblmls_tulsa_Listings.VideoTour,tblmls_tulsa_Listings.MLS_Remarks,tblmls_tulsa_Listings.Description,tblmls_tulsa_Listings.MLS_StatusCode,tblmls_tulsa_Listings.Orig_List_Price,tblmls_tulsa_Listings.SalePrice,tblmls_tulsa_Listings.ListingDateTime,tblmls_tulsa_Listings.DateTime,tblmls_tulsa_Listings.ClosingDateTime,tblmls_tulsa_Listings.ContractDateTime,tblmls_tulsa_Listings.DOM,tblmls_tulsa_Listings.REO,tblmls_tulsa_Listings.ShortSale,tblmls_tulsa_Listings.LO_ID,tblmls_tulsa_Listings.LA_ID,tblmls_tulsa_Listings.BO_ID,tblmls_tulsa_Listings.BA_ID,tblmls_tulsa_Listings.BO_Name,tblmls_tulsa_Listings.BA_Name,tblmls_tulsa_Listings.Image_List,tblmls_tulsa_Listings.DeleteFlag,tblmls_tulsa_Listings.isprivate,'' AS OpenHouseSchedule,'' AS BathsString,tblmls_tulsa_Listings.Baths,tblmls_tulsa_Listings.FullBaths,tblmls_tulsa_Listings.HalfBaths,tblmls_tulsa_Listings.ThreeQuarterBaths,tblmls_tulsa_Listings.Beds,tblmls_tulsa_Listings.Garage,tblmls_tulsa_Listings.Style,tblmls_tulsa_Listings.sq_foot,tblmls_tulsa_Listings.Year_Built,tblmls_tulsa_Listings.Pool,tblmls_tulsa_Listings.Acreage,tblmls_tulsa_Listings.Story,tblmls_tulsa_Listings.Previews,tblmls_tulsa_Listings.Featured,tblmls_tulsa_Listings.CommunityName,tblmls_tulsa_Listings.PropertyView,tblmls_tulsa_Listings.Waterfront,tblmls_tulsa_Listings.Golfcourse,tblmls_tulsa_Listings.Basement,tblmls_tulsa_Listings.Carport,tblmls_tulsa_Listings.PatioSQ_Foot,tblmls_tulsa_Listings.BuildingName,tblmls_tulsa_Listings.UnitFloor,tblmls_tulsa_Listings.HOA,tblmls_tulsa_Listings.HoaDues,tblmls_tulsa_Listings.Zoning,tblmls_tulsa_Listings.sq_foot_Office,tblmls_tulsa_Listings.Units,tblmls_tulsa_Listings.AskingPricePersq_foot, tblmls_tulsa_Listings.SalesTerms,tblmls_tulsa_Listings.SaleType,tblmls_tulsa_Listings.sq_foot_Vacant,tblmls_tulsa_Listings.SuiteNumber,tblmls_tulsa_Listings.SuiteFloor,tblmls_tulsa_Listings.GrossBuildingArea, tblmls_tulsa_Listings.GrossLeaseArea, tblmls_tulsa_Listings.BuildingClass,tblmls_tulsa_Listings.LegalDescription, tblmls_tulsa_Listings.Occupancy,tblmls_tulsa_Listings.TenantOccupancyBasis, tblmls_tulsa_Listings.ConstructionStatus,tblmls_tulsa_Listings.YearRenovated, tblmls_tulsa_Listings.LeedCertification, tblmls_tulsa_Listings.Buildings, tblmls_tulsa_Listings.ParkingType, tblmls_tulsa_Listings.ParkingSpaces, tblmls_tulsa_Listings.PotentialRentalIncome, tblmls_tulsa_Listings.NetOperatingIncome, tblmls_tulsa_Listings.CapRate, tblmls_tulsa_Listings.InternalRateOfReturn, tblmls_tulsa_Listings.CashOnCash, tblmls_tulsa_Listings.PotentialRentalIncomeRemarks, tblmls_tulsa_Listings.NoiRemarks, tblmls_tulsa_Listings.CapRateRemarks, tblmls_tulsa_Listings.LoanBalance, tblmls_tulsa_Listings.InterestRate, tblmls_tulsa_Listings.AmortizationPeriod, tblmls_tulsa_Listings.MaturityDate,tblmls_tulsa_Listings.secondpublicid as listingagentsecondpublicid,tblmls_tulsa_Listings.publicid as listingagentpublicid,agents.officeid as listingagentofficeid,agents_teams_members.agentteamid as listingagentteamidFROM [data-0].[mls_tulsa].[dbo].listings AS tblmls_tulsa_Listings WITH (NOLOCK)LEFT OUTER JOIN PropertyID WITH (NOLOCK)ON PropertyID.MLSID = 'mls_tulsa'AND PropertyID.ML_Number = tblmls_tulsa_Listings.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 = tblmls_tulsa_Listings.publicidLEFT OUTER JOIN agents WITH (NOLOCK)ON agents.publicid = tblmls_tulsa_Listings.publicidWHERE (tblmls_tulsa_Listings.propertytype IN ('Commercial','Land','MultiFamily','Residential'))) dtUnion) dtDataWHERE dtData.RowNumber BETWEEN 1 AND 25 ORDER BY ID ASC, List_Price desc, ML_Number ASC
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
stringSELECT *FROM(SELECT *,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,'/assets/img/nophoto/nophoto-listings.jpg' AS ImagePath,'/assets/img/nophoto/nophoto-listings-thumb.jpg' AS ThumbPath,'/listing/68-' + cast(tblmls_tulsa_Listings.listingid as varchar) + '/' + lower(replace(replace(replace(tblmls_tulsa_Listings.streetaddress, ' ', '-'), '#', ''), '&', '')) + '-' + lower(replace(tblmls_tulsa_Listings.city, ' ', '-')) + '-' + lower(tblmls_tulsa_Listings.state) + '-' + tblmls_tulsa_Listings.zip_code as url,'' AS SortOrder,'' AS AgentPublicID,'' AS AgentImagePath,'' AS AgentThumbPath,'' 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 SecondAgentThumbPath,'' 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,'mls_tulsa' AS MLSID,tblmls_tulsa_Listings.listingid,tblmls_tulsa_Listings.PropertyType,tblmls_tulsa_Listings.PublicID AS LA_PublicID,tblmls_tulsa_Listings.CompanyID,tblmls_tulsa_Listings.StatusCode,tblmls_tulsa_Listings.Area,tblmls_tulsa_Listings.DisplayAddress,tblmls_tulsa_Listings.DisplayRemarks,tblmls_tulsa_Listings.DisplayCMA,tblmls_tulsa_Listings.Lat,tblmls_tulsa_Listings.Lon,tblmls_tulsa_Listings.List_Price,tblmls_tulsa_Listings.LO_Name,tblmls_tulsa_Listings.LA_Name,tblmls_tulsa_Listings.ML_Number,tblmls_tulsa_Listings.PublicID,tblmls_tulsa_Listings.SecondPublicID,tblmls_tulsa_Listings.StreetAddress,tblmls_tulsa_Listings.City,tblmls_tulsa_Listings.State,tblmls_tulsa_Listings.Zip_Code,tblmls_tulsa_Listings.County,tblmls_tulsa_Listings.SchoolDistrict,tblmls_tulsa_Listings.ElementarySchool,tblmls_tulsa_Listings.JRHighSchool,tblmls_tulsa_Listings.HighSchool,DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() ) AS DaysOnSite,tblmls_tulsa_Listings.ReducedDateTime,tblmls_tulsa_Listings.AddDateTime,tblmls_tulsa_Listings.Prev_List_Price,tblmls_tulsa_Listings.VirtualTourID,tblmls_tulsa_Listings.Images,tblmls_tulsa_Listings.SubType,tblmls_tulsa_Listings.Optional_01,tblmls_tulsa_Listings.Optional_02,tblmls_tulsa_Listings.Optional_03,tblmls_tulsa_Listings.Optional_04,tblmls_tulsa_Listings.Optional_05,tblmls_tulsa_Listings.Optional_06,tblmls_tulsa_Listings.Optional_07,tblmls_tulsa_Listings.Optional_08,tblmls_tulsa_Listings.Optional_09,tblmls_tulsa_Listings.Optional_10,tblmls_tulsa_Listings.Optional_11,tblmls_tulsa_Listings.Optional_12,tblmls_tulsa_Listings.Optional_13,tblmls_tulsa_Listings.Optional_14,tblmls_tulsa_Listings.Optional_15,tblmls_tulsa_Listings.Optional_16,tblmls_tulsa_Listings.Optional_17,tblmls_tulsa_Listings.Optional_18,tblmls_tulsa_Listings.Optional_19,tblmls_tulsa_Listings.Optional_20,tblmls_tulsa_Listings.VideoTour,tblmls_tulsa_Listings.MLS_Remarks,tblmls_tulsa_Listings.Description,tblmls_tulsa_Listings.MLS_StatusCode,tblmls_tulsa_Listings.Orig_List_Price,tblmls_tulsa_Listings.SalePrice,tblmls_tulsa_Listings.ListingDateTime,tblmls_tulsa_Listings.DateTime,tblmls_tulsa_Listings.ClosingDateTime,tblmls_tulsa_Listings.ContractDateTime,tblmls_tulsa_Listings.DOM,tblmls_tulsa_Listings.REO,tblmls_tulsa_Listings.ShortSale,tblmls_tulsa_Listings.LO_ID,tblmls_tulsa_Listings.LA_ID,tblmls_tulsa_Listings.BO_ID,tblmls_tulsa_Listings.BA_ID,tblmls_tulsa_Listings.BO_Name,tblmls_tulsa_Listings.BA_Name,tblmls_tulsa_Listings.Image_List,tblmls_tulsa_Listings.DeleteFlag,tblmls_tulsa_Listings.isprivate,'' AS OpenHouseSchedule,'' AS BathsString,tblmls_tulsa_Listings.Baths,tblmls_tulsa_Listings.FullBaths,tblmls_tulsa_Listings.HalfBaths,tblmls_tulsa_Listings.ThreeQuarterBaths,tblmls_tulsa_Listings.Beds,tblmls_tulsa_Listings.Garage,tblmls_tulsa_Listings.Style,tblmls_tulsa_Listings.sq_foot,tblmls_tulsa_Listings.Year_Built,tblmls_tulsa_Listings.Pool,tblmls_tulsa_Listings.Acreage,tblmls_tulsa_Listings.Story,tblmls_tulsa_Listings.Previews,tblmls_tulsa_Listings.Featured,tblmls_tulsa_Listings.CommunityName,tblmls_tulsa_Listings.PropertyView,tblmls_tulsa_Listings.Waterfront,tblmls_tulsa_Listings.Golfcourse,tblmls_tulsa_Listings.Basement,tblmls_tulsa_Listings.Carport,tblmls_tulsa_Listings.PatioSQ_Foot,tblmls_tulsa_Listings.BuildingName,tblmls_tulsa_Listings.UnitFloor,tblmls_tulsa_Listings.HOA,tblmls_tulsa_Listings.HoaDues,tblmls_tulsa_Listings.Zoning,tblmls_tulsa_Listings.sq_foot_Office,tblmls_tulsa_Listings.Units,tblmls_tulsa_Listings.AskingPricePersq_foot, tblmls_tulsa_Listings.SalesTerms,tblmls_tulsa_Listings.SaleType,tblmls_tulsa_Listings.sq_foot_Vacant,tblmls_tulsa_Listings.SuiteNumber,tblmls_tulsa_Listings.SuiteFloor,tblmls_tulsa_Listings.GrossBuildingArea, tblmls_tulsa_Listings.GrossLeaseArea, tblmls_tulsa_Listings.BuildingClass,tblmls_tulsa_Listings.LegalDescription, tblmls_tulsa_Listings.Occupancy,tblmls_tulsa_Listings.TenantOccupancyBasis, tblmls_tulsa_Listings.ConstructionStatus,tblmls_tulsa_Listings.YearRenovated, tblmls_tulsa_Listings.LeedCertification, tblmls_tulsa_Listings.Buildings, tblmls_tulsa_Listings.ParkingType, tblmls_tulsa_Listings.ParkingSpaces, tblmls_tulsa_Listings.PotentialRentalIncome, tblmls_tulsa_Listings.NetOperatingIncome, tblmls_tulsa_Listings.CapRate, tblmls_tulsa_Listings.InternalRateOfReturn, tblmls_tulsa_Listings.CashOnCash, tblmls_tulsa_Listings.PotentialRentalIncomeRemarks, tblmls_tulsa_Listings.NoiRemarks, tblmls_tulsa_Listings.CapRateRemarks, tblmls_tulsa_Listings.LoanBalance, tblmls_tulsa_Listings.InterestRate, tblmls_tulsa_Listings.AmortizationPeriod, tblmls_tulsa_Listings.MaturityDate,tblmls_tulsa_Listings.secondpublicid as listingagentsecondpublicid,tblmls_tulsa_Listings.publicid as listingagentpublicid,agents.officeid as listingagentofficeid,agents_teams_members.agentteamid as listingagentteamidFROM [data-0].[mls_tulsa].[dbo].listings AS tblmls_tulsa_Listings WITH (NOLOCK)LEFT OUTER JOIN PropertyID WITH (NOLOCK)ON PropertyID.MLSID = 'mls_tulsa'AND PropertyID.ML_Number = tblmls_tulsa_Listings.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 = tblmls_tulsa_Listings.publicidLEFT OUTER JOIN agents WITH (NOLOCK)ON agents.publicid = tblmls_tulsa_Listings.publicidWHERE (tblmls_tulsa_Listings.propertytype IN ('Commercial','Land','MultiFamily','Residential'))) dtUnion) dtDataWHERE dtData.RowNumber BETWEEN 1 AND 25 ORDER BY ID ASC, List_Price desc, ML_Number ASC
Sql
stringSELECT *FROM(SELECT *,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,'/assets/img/nophoto/nophoto-listings.jpg' AS ImagePath,'/assets/img/nophoto/nophoto-listings-thumb.jpg' AS ThumbPath,'/listing/68-' + cast(tblmls_tulsa_Listings.listingid as varchar) + '/' + lower(replace(replace(replace(tblmls_tulsa_Listings.streetaddress, ' ', '-'), '#', ''), '&', '')) + '-' + lower(replace(tblmls_tulsa_Listings.city, ' ', '-')) + '-' + lower(tblmls_tulsa_Listings.state) + '-' + tblmls_tulsa_Listings.zip_code as url,'' AS SortOrder,'' AS AgentPublicID,'' AS AgentImagePath,'' AS AgentThumbPath,'' 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 SecondAgentThumbPath,'' 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,'mls_tulsa' AS MLSID,tblmls_tulsa_Listings.listingid,tblmls_tulsa_Listings.PropertyType,tblmls_tulsa_Listings.PublicID AS LA_PublicID,tblmls_tulsa_Listings.CompanyID,tblmls_tulsa_Listings.StatusCode,tblmls_tulsa_Listings.Area,tblmls_tulsa_Listings.DisplayAddress,tblmls_tulsa_Listings.DisplayRemarks,tblmls_tulsa_Listings.DisplayCMA,tblmls_tulsa_Listings.Lat,tblmls_tulsa_Listings.Lon,tblmls_tulsa_Listings.List_Price,tblmls_tulsa_Listings.LO_Name,tblmls_tulsa_Listings.LA_Name,tblmls_tulsa_Listings.ML_Number,tblmls_tulsa_Listings.PublicID,tblmls_tulsa_Listings.SecondPublicID,tblmls_tulsa_Listings.StreetAddress,tblmls_tulsa_Listings.City,tblmls_tulsa_Listings.State,tblmls_tulsa_Listings.Zip_Code,tblmls_tulsa_Listings.County,tblmls_tulsa_Listings.SchoolDistrict,tblmls_tulsa_Listings.ElementarySchool,tblmls_tulsa_Listings.JRHighSchool,tblmls_tulsa_Listings.HighSchool,DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() ) AS DaysOnSite,tblmls_tulsa_Listings.ReducedDateTime,tblmls_tulsa_Listings.AddDateTime,tblmls_tulsa_Listings.Prev_List_Price,tblmls_tulsa_Listings.VirtualTourID,tblmls_tulsa_Listings.Images,tblmls_tulsa_Listings.SubType,tblmls_tulsa_Listings.Optional_01,tblmls_tulsa_Listings.Optional_02,tblmls_tulsa_Listings.Optional_03,tblmls_tulsa_Listings.Optional_04,tblmls_tulsa_Listings.Optional_05,tblmls_tulsa_Listings.Optional_06,tblmls_tulsa_Listings.Optional_07,tblmls_tulsa_Listings.Optional_08,tblmls_tulsa_Listings.Optional_09,tblmls_tulsa_Listings.Optional_10,tblmls_tulsa_Listings.Optional_11,tblmls_tulsa_Listings.Optional_12,tblmls_tulsa_Listings.Optional_13,tblmls_tulsa_Listings.Optional_14,tblmls_tulsa_Listings.Optional_15,tblmls_tulsa_Listings.Optional_16,tblmls_tulsa_Listings.Optional_17,tblmls_tulsa_Listings.Optional_18,tblmls_tulsa_Listings.Optional_19,tblmls_tulsa_Listings.Optional_20,tblmls_tulsa_Listings.VideoTour,tblmls_tulsa_Listings.MLS_Remarks,tblmls_tulsa_Listings.Description,tblmls_tulsa_Listings.MLS_StatusCode,tblmls_tulsa_Listings.Orig_List_Price,tblmls_tulsa_Listings.SalePrice,tblmls_tulsa_Listings.ListingDateTime,tblmls_tulsa_Listings.DateTime,tblmls_tulsa_Listings.ClosingDateTime,tblmls_tulsa_Listings.ContractDateTime,tblmls_tulsa_Listings.DOM,tblmls_tulsa_Listings.REO,tblmls_tulsa_Listings.ShortSale,tblmls_tulsa_Listings.LO_ID,tblmls_tulsa_Listings.LA_ID,tblmls_tulsa_Listings.BO_ID,tblmls_tulsa_Listings.BA_ID,tblmls_tulsa_Listings.BO_Name,tblmls_tulsa_Listings.BA_Name,tblmls_tulsa_Listings.Image_List,tblmls_tulsa_Listings.DeleteFlag,tblmls_tulsa_Listings.isprivate,'' AS OpenHouseSchedule,'' AS BathsString,tblmls_tulsa_Listings.Baths,tblmls_tulsa_Listings.FullBaths,tblmls_tulsa_Listings.HalfBaths,tblmls_tulsa_Listings.ThreeQuarterBaths,tblmls_tulsa_Listings.Beds,tblmls_tulsa_Listings.Garage,tblmls_tulsa_Listings.Style,tblmls_tulsa_Listings.sq_foot,tblmls_tulsa_Listings.Year_Built,tblmls_tulsa_Listings.Pool,tblmls_tulsa_Listings.Acreage,tblmls_tulsa_Listings.Story,tblmls_tulsa_Listings.Previews,tblmls_tulsa_Listings.Featured,tblmls_tulsa_Listings.CommunityName,tblmls_tulsa_Listings.PropertyView,tblmls_tulsa_Listings.Waterfront,tblmls_tulsa_Listings.Golfcourse,tblmls_tulsa_Listings.Basement,tblmls_tulsa_Listings.Carport,tblmls_tulsa_Listings.PatioSQ_Foot,tblmls_tulsa_Listings.BuildingName,tblmls_tulsa_Listings.UnitFloor,tblmls_tulsa_Listings.HOA,tblmls_tulsa_Listings.HoaDues,tblmls_tulsa_Listings.Zoning,tblmls_tulsa_Listings.sq_foot_Office,tblmls_tulsa_Listings.Units,tblmls_tulsa_Listings.AskingPricePersq_foot, tblmls_tulsa_Listings.SalesTerms,tblmls_tulsa_Listings.SaleType,tblmls_tulsa_Listings.sq_foot_Vacant,tblmls_tulsa_Listings.SuiteNumber,tblmls_tulsa_Listings.SuiteFloor,tblmls_tulsa_Listings.GrossBuildingArea, tblmls_tulsa_Listings.GrossLeaseArea, tblmls_tulsa_Listings.BuildingClass,tblmls_tulsa_Listings.LegalDescription, tblmls_tulsa_Listings.Occupancy,tblmls_tulsa_Listings.TenantOccupancyBasis, tblmls_tulsa_Listings.ConstructionStatus,tblmls_tulsa_Listings.YearRenovated, tblmls_tulsa_Listings.LeedCertification, tblmls_tulsa_Listings.Buildings, tblmls_tulsa_Listings.ParkingType, tblmls_tulsa_Listings.ParkingSpaces, tblmls_tulsa_Listings.PotentialRentalIncome, tblmls_tulsa_Listings.NetOperatingIncome, tblmls_tulsa_Listings.CapRate, tblmls_tulsa_Listings.InternalRateOfReturn, tblmls_tulsa_Listings.CashOnCash, tblmls_tulsa_Listings.PotentialRentalIncomeRemarks, tblmls_tulsa_Listings.NoiRemarks, tblmls_tulsa_Listings.CapRateRemarks, tblmls_tulsa_Listings.LoanBalance, tblmls_tulsa_Listings.InterestRate, tblmls_tulsa_Listings.AmortizationPeriod, tblmls_tulsa_Listings.MaturityDate,tblmls_tulsa_Listings.secondpublicid as listingagentsecondpublicid,tblmls_tulsa_Listings.publicid as listingagentpublicid,agents.officeid as listingagentofficeid,agents_teams_members.agentteamid as listingagentteamidFROM [data-0].[mls_tulsa].[dbo].listings AS tblmls_tulsa_Listings WITH (NOLOCK)LEFT OUTER JOIN PropertyID WITH (NOLOCK)ON PropertyID.MLSID = 'mls_tulsa'AND PropertyID.ML_Number = tblmls_tulsa_Listings.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 = tblmls_tulsa_Listings.publicidLEFT OUTER JOIN agents WITH (NOLOCK)ON agents.publicid = tblmls_tulsa_Listings.publicidWHERE (tblmls_tulsa_Listings.propertytype IN ('Commercial','Land','MultiFamily','Residential'))) dtUnion) dtDataWHERE dtData.RowNumber BETWEEN 1 AND 25 ORDER BY ID ASC, List_Price desc, ML_Number ASC
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 com.intergral.fusionreactor.jdbc.jdbc42.ResultSetSurrogate2.next(ResultSetSurrogate2.java:869)at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:444)at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:280)at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:218)at lucee.runtime.tag.Query.executeDatasoure(Query.java:820)at lucee.runtime.tag.Query.doEndTag(Query.java:583)at org.lucee.cfml.base_cfc$cf.udfCall1(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc:147)at org.lucee.cfml.base_cfc$cf.udfCall(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:770)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:752)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1579)at org.lucee.cfml.query_cfc$cf.udfCall(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Query.cfc:53)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:210)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1920)at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:793)at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1589)at iqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc:232)at iqquery_cfc$cf.udfCall(C:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1903)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:752)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1579)at iqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc:141)at iqquery_cfc$cf.udfCall(C:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:210)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1920)at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:563)at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:205)at components.listings_cfc$cf.udfCall1_000023(C:\realistiq\production\iqweb\components\listings.cfc:1109)at components.listings_cfc$cf.udfCall1(C:\realistiq\production\iqweb\components\listings.cfc:705)at components.listings_cfc$cf.udfCall(C:\realistiq\production\iqweb\components\listings.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:210)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1916)at lucee.runtime.tag.Invoke.doComponent(Invoke.java:221)at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:194)at components.listing_cfc$cf.udfCall(C:\realistiq\production\iqweb\components\listing.cfc:34)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:210)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1916)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(C:\realistiq\production\iqweb\app\_slw.cfm:9)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:900)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:815)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:810)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:801)at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:87)at lib.iq_cfc$cf.udfCall(C:\realistiq\production\iqweb\lib\iq.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:770)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:752)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1579)at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:53)at lib.iq_cfc$cf.udfCall(C:\realistiq\production\iqweb\lib\iq.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:770)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:752)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1579)at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:38)at lib.iq_cfc$cf.udfCall(C:\realistiq\production\iqweb\lib\iq.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1903)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:752)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1579)at application_cfc$cf.udfCall(C:\realistiq\production\iqweb\application.cfc:263)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:105)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:337)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:697)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:580)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1903)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:2259)at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2251)at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2219)at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:881)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 com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:806)at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:339)at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:215)at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:839)at sun.reflect.GeneratedMethodAccessor31.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:483)at com.intergral.fusionreactor.agent.filter.FusionReactorStaticServlet.service(FusionReactorStaticServlet.java:50)at com.intergral.fusionreactor.agent.pointcuts.ServletPointCut$1.invoke(ServletPointCut.java:41)at javax.servlet.http.HttpServlet.service(HttpServlet.java)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
string145: !---&gt;&lt;cfqueryparam attributecollection=&quot;#item#&quot;&gt;&lt;!---<br>146: !---&gt;&lt;/cfif&gt;&lt;/cfloop&gt;<br><b>147: &lt;/cfquery&gt;</b><br>148: <br>149: &lt;cfset result.setResult(q)&gt;<br>
codePrintPlain
string145: !---><cfqueryparam attributecollection="#item#"><!---146: !---></cfif></cfloop>147: </cfquery>148: 149: <cfset result.setResult(q)>
column
number0
id
string??
line
number147
Raw_Trace
stringorg.lucee.cfml.base_cfc$cf.udfCall1(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc:147)
template
stringC:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc
type
stringcfml
2
Struct
codePrintHTML
string51: <br>52: // invoke the query and return the result<br><b>53: return invokeTag();</b><br>54: }<br>55: <br>
codePrintPlain
string51: 52: // invoke the query and return the result53: return invokeTag();54: }55:
column
number0
id
string??
line
number53
Raw_Trace
stringorg.lucee.cfml.query_cfc$cf.udfCall(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Query.cfc:53)
template
stringC:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Query.cfc
type
stringcfml
3
Struct
codePrintHTML
string230: }<br>231: <br><b>232: local.query = local.queryservice.execute(sql=this['sql']);</b><br>233: <br>234: local.recordset = local.query.getResult();<br>
codePrintPlain
string230: }231: 232: local.query = local.queryservice.execute(sql=this['sql']);233: 234: local.recordset = local.query.getResult();
column
number0
id
string??
line
number232
Raw_Trace
stringiqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc:232)
template
stringC:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc
type
stringcfml
4
Struct
codePrintHTML
string139: this['sql'] = arguments.generatedcontent;<br>140: <br><b>141: local.retQuery = this.query();</b><br>142: <br>143: StructDelete(arguments, &quot;generatedcontent&quot;);<br>
codePrintPlain
string139: this['sql'] = arguments.generatedcontent;140: 141: local.retQuery = this.query();142: 143: StructDelete(arguments, "generatedcontent");
column
number0
id
string??
line
number141
Raw_Trace
stringiqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc:141)
template
stringC:\Lucee\iqweb\lucee-server\context\library\tag\iqquery.cfc
type
stringcfml
5
Struct
codePrintHTML
string1107: UNION ALL<br>1108: &lt;/cfif&gt;<br><b>1109: &lt;/cfloop&gt;</b><br>1110: ) dtUnion<br>1111: &lt;cfif arguments.distance NEQ 0&gt;WHERE (dtUnion.distance between &lt;cfiqqueryparam value=&quot;0&quot; cfsqltype=&quot;cf_sql_numeric&quot;&gt; and &lt;cfiqqueryparam value=&quot;#arguments.distance#&quot; cfsqltype=&quot;cf_sql_numeric&quot;&gt;)&lt;/cfif&gt;<br>
codePrintPlain
string1107: UNION ALL1108: </cfif>1109: </cfloop>1110: ) dtUnion1111: <cfif arguments.distance NEQ 0>WHERE (dtUnion.distance between <cfiqqueryparam value="0" cfsqltype="cf_sql_numeric"> and <cfiqqueryparam value="#arguments.distance#" cfsqltype="cf_sql_numeric">)</cfif>
column
number0
id
string??
line
number1109
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall1_000023(C:\realistiq\production\iqweb\components\listings.cfc:1109)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
6
Struct
codePrintHTML
string703: )dtCounted<br>704: &lt;/cfiqquery&gt;<br><b>705: &lt;/cfoutput&gt;</b><br>706: <br>707: &lt;cfset local.retVal.TotalRowCount = rsCount.TotalRowCount&gt;<br>
codePrintPlain
string703: )dtCounted704: </cfiqquery>705: </cfoutput>706: 707: <cfset local.retVal.TotalRowCount = rsCount.TotalRowCount>
column
number0
id
string??
line
number705
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall1(C:\realistiq\production\iqweb\components\listings.cfc:705)
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(C:\realistiq\production\iqweb\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(C:\realistiq\production\iqweb\app\_slw.cfm:9)
template
stringC:\realistiq\production\iqweb\app\_slw.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;#request.AppMapPath#/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="#request.AppMapPath#/app/_#local.PageName#.cfm" />88: <cfelse>89: <cfset MissingFile = local.PageName>
column
number0
id
string??
line
number87
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:87)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
10
Struct
codePrintHTML
string51: &lt;cfif local.Layout EQ &quot;none&quot;&gt;<br>52: &lt;cfscript&gt;<br><b>53: RenderPage();</b><br>54: &lt;/cfscript&gt;<br>55: &lt;cfelse&gt;<br>
codePrintPlain
string51: <cfif local.Layout EQ "none">52: <cfscript>53: RenderPage();54: </cfscript>55: <cfelse>
column
number0
id
string??
line
number53
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:53)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
11
Struct
codePrintHTML
string36: <br>37: &lt;cfscript&gt;<br><b>38: doLayout();</b><br>39: &lt;/cfscript&gt;<br>40: &lt;/cfif&gt;<br>
codePrintPlain
string36: 37: <cfscript>38: doLayout();39: </cfscript>40: </cfif>
column
number0
id
string??
line
number38
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:38)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
12
Struct
codePrintHTML
string261: local.url.process(cgi.path_info);<br>262: <br><b>263: writeOutput(request.iqLib.RenderContent());</b><br>264: }<br>265: }<br>
codePrintPlain
string261: local.url.process(cgi.path_info);262: 263: writeOutput(request.iqLib.RenderContent());264: }265: }
column
number0
id
string??
line
number263
Raw_Trace
stringapplication_cfc$cf.udfCall(C:\realistiq\production\iqweb\application.cfc:263)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string