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,'' 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.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
string11.00.5058
DriverName
stringMicrosoft JDBC Driver 4.1 for SQL Server
DriverVersion
string4.1.5605.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,'' 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.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,'' 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.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
stringat com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216):216at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:4869):4869at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1781):1781at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1034):1034at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:445):445at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:259):259at lucee.runtime.tag.Query.executeDatasoure(Query.java:802):802at lucee.runtime.tag.Query.doEndTag(Query.java:604):604at org.lucee.cfml.base_cfc$cf.udfCall1(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc:163):163at org.lucee.cfml.base_cfc$cf.udfCall(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:766):766at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593at org.lucee.cfml.query_cfc$cf.udfCall(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Query.cfc:53):53at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1778):1778at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1603):1603at iqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc:222):222at iqquery_cfc$cf.udfCall(C:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593at iqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc:127):127at iqquery_cfc$cf.udfCall(C:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1778):1778at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:562):562at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:204):204at components.listings_cfc$cf.udfCall1_000023(C:\realistiq\production\iqweb\components\listings.cfc:1079):1079at components.listings_cfc$cf.udfCall1(C:\realistiq\production\iqweb\components\listings.cfc:688):688at components.listings_cfc$cf.udfCall(C:\realistiq\production\iqweb\components\listings.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1774):1774at lucee.runtime.tag.Invoke.doComponent(Invoke.java:221):221at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:194):194at components.listing_cfc$cf.udfCall(C:\realistiq\production\iqweb\components\listing.cfc:33):33at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1774):1774at lucee.runtime.tag.Invoke.doComponent(Invoke.java:221):221at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:194):194at iqweb.app._slw_cfm$cf.call(C:\realistiq\production\iqweb\app\_slw.cfm:9):9at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:954):954at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:858):858at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:80):80at lib.iq_cfc$cf.udfCall(C:\realistiq\production\iqweb\lib\iq.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:766):766at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:46):46at lib.iq_cfc$cf.udfCall(C:\realistiq\production\iqweb\lib\iq.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:766):766at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593at lib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:33):33at lib.iq_cfc$cf.udfCall(C:\realistiq\production\iqweb\lib\iq.cfc):-1at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593at application_cfc$cf.udfCall(C:\realistiq\production\iqweb\application.cfc:243):243at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:414):414at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:223):223at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:37):37at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2265):2265at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2228):2228at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:456):456at lucee.loader.servlet.CFMLServlet.service(Unknown Source):-1at javax.servlet.http.HttpServlet.service(HttpServlet.java:848):848at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684):684at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501):501at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137):137at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557):557at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231):231at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086):1086at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:428):428at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193):193at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020):1020at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135):135at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:245):245at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:154):154at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116):116at org.eclipse.jetty.server.Server.handle(Server.java:370):370at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494):494at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:971):971at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1033):1033at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644):644at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235):235at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82):82at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:667):667at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52):52at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608):608at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543):543at java.lang.Thread.run(Thread.java:745):745
TagContext
Array
Rows: 12
1
Struct
codePrintHTML
string161: !---&gt;&lt;cfqueryparam attributecollection=&quot;#item#&quot;&gt;&lt;!---<br>162: !---&gt;&lt;/cfif&gt;&lt;/cfloop&gt;<br><b>163: &lt;/cfquery&gt;</b><br>164: <br>165: &lt;cfset result.setResult(q)&gt;<br>
codePrintPlain
string161: !---><cfqueryparam attributecollection="#item#"><!---162: !---></cfif></cfloop>163: </cfquery>164: 165: <cfset result.setResult(q)>
column
number0
id
string??
line
number163
Raw_Trace
stringorg.lucee.cfml.base_cfc$cf.udfCall1(C:\Lucee\iqweb\contexts\web-inf\0088def3ac3fd1b3165dfdc5385641ee\components\org\lucee\cfml\Base.cfc:163)
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
string220: }<br>221: <br><b>222: local.query = local.queryservice.execute(sql=this['sql']);</b><br>223: <br>224: local.recordset = local.query.getResult();<br>
codePrintPlain
string220: }221: 222: local.query = local.queryservice.execute(sql=this['sql']);223: 224: local.recordset = local.query.getResult();
column
number0
id
string??
line
number222
Raw_Trace
stringiqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc:222)
template
stringC:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc
type
stringcfml
4
Struct
codePrintHTML
string125: this['sql'] = arguments.generatedcontent;<br>126: <br><b>127: local.retQuery = this.query();</b><br>128: <br>129: StructDelete(arguments, &quot;generatedcontent&quot;);<br>
codePrintPlain
string125: this['sql'] = arguments.generatedcontent;126: 127: local.retQuery = this.query();128: 129: StructDelete(arguments, "generatedcontent");
column
number0
id
string??
line
number127
Raw_Trace
stringiqquery_cfc$cf.udfCall1(C:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc:127)
template
stringC:\Lucee\iqweb\lib\ext\lucee-server\context\library\tag\iqquery.cfc
type
stringcfml
5
Struct
codePrintHTML
string1077: UNION ALL<br>1078: &lt;/cfif&gt;<br><b>1079: &lt;/cfloop&gt;</b><br>1080: ) dtUnion<br>1081: &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
string1077: UNION ALL1078: </cfif>1079: </cfloop>1080: ) dtUnion1081: <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
number1079
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall1_000023(C:\realistiq\production\iqweb\components\listings.cfc:1079)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
6
Struct
codePrintHTML
string686: )dtCounted<br>687: &lt;/cfiqquery&gt;<br><b>688: &lt;/cfoutput&gt;</b><br>689: <br>690: &lt;cfset local.retVal.TotalRowCount = rsCount.TotalRowCount&gt;<br>
codePrintPlain
string686: )dtCounted687: </cfiqquery>688: </cfoutput>689: 690: <cfset local.retVal.TotalRowCount = rsCount.TotalRowCount>
column
number0
id
string??
line
number688
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall1(C:\realistiq\production\iqweb\components\listings.cfc:688)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
7
Struct
codePrintHTML
string31: &lt;cfinvokeargument name=&quot;propertytype&quot; value=&quot;#arguments.propertytype#&quot;&gt;<br>32: &lt;cfinvokeargument name=&quot;view_from&quot; value=&quot;#arguments.view_from#&quot;&gt;<br><b>33: &lt;/cfinvoke&gt;</b><br>34: <br>35: &lt;cfif retListing.Status EQ 1&gt;<br>
codePrintPlain
string31: <cfinvokeargument name="propertytype" value="#arguments.propertytype#">32: <cfinvokeargument name="view_from" value="#arguments.view_from#">33: </cfinvoke>34: 35: <cfif retListing.Status EQ 1>
column
number0
id
string??
line
number33
Raw_Trace
stringcomponents.listing_cfc$cf.udfCall(C:\realistiq\production\iqweb\components\listing.cfc:33)
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
string78: &lt;cfelse&gt;<br>79: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/app/_#local.PageName#.cfm&quot;)&gt;<br><b>80: &lt;cfsavecontent variable=&quot;local.retVal&quot;&gt;&lt;cfinclude template=&quot;#request.AppMapPath#/app/_#local.PageName#.cfm&quot; /&gt;&lt;/cfsavecontent&gt;</b><br>81: &lt;cfelse&gt;<br>82: &lt;cfset MissingFile = local.PageName&gt;<br>
codePrintPlain
string78: <cfelse>79: <cfif FileExists("#request.AppAbsolutePath#/app/_#local.PageName#.cfm")>80: <cfsavecontent variable="local.retVal"><cfinclude template="#request.AppMapPath#/app/_#local.PageName#.cfm" /></cfsavecontent>81: <cfelse>82: <cfset MissingFile = local.PageName>
column
number0
id
string??
line
number80
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:80)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
10
Struct
codePrintHTML
string44: <br>45: &lt;cfif local.Layout EQ &quot;none&quot;&gt;<br><b>46: &lt;cfsavecontent variable=&quot;local.retVal&quot;&gt;#RenderPage()#&lt;/cfsavecontent&gt;</b><br>47: &lt;cfelse&gt;<br>48: &lt;cfif FileExists(&quot;#request.CustomAbsolutePath#/layouts/_#local.Layout#.cfm&quot;)&gt;<br>
codePrintPlain
string44: 45: <cfif local.Layout EQ "none">46: <cfsavecontent variable="local.retVal">#RenderPage()#</cfsavecontent>47: <cfelse>48: <cfif FileExists("#request.CustomAbsolutePath#/layouts/_#local.Layout#.cfm")>
column
number0
id
string??
line
number46
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:46)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
11
Struct
codePrintHTML
string31: &lt;/cfif&gt;<br>32: <br><b>33: &lt;cfreturn doLayout()&gt;</b><br>34: &lt;/cfif&gt;<br>35: &lt;/cffunction&gt;<br>
codePrintPlain
string31: </cfif>32: 33: <cfreturn doLayout()>34: </cfif>35: </cffunction>
column
number0
id
string??
line
number33
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(C:\realistiq\production\iqweb\lib\iq.cfc:33)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
12
Struct
codePrintHTML
string241: }<br>242: <br><b>243: writeOutput(request.iqLib.RenderContent());</b><br>244: }<br>245: }<br>
codePrintPlain
string241: }242: 243: writeOutput(request.iqLib.RenderContent());244: }245: }
column
number0
id
string??
line
number243
Raw_Trace
stringapplication_cfc$cf.udfCall(C:\realistiq\production\iqweb\application.cfc:243)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string