ASP error happened
| Technical information | |
| Error number | -2147217900 |
| Error description | [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'WilliamsonAct'. |
| URL | /planning/building/WedPermit/PermitsHeaderInfo_list.asp |
| SQL query | select [PermitNumber], [Status], [PYear], [PMonth], [PNumber], [ProjectNumber], [Applicant], [ApplicantAddress], [ApplicantCityStateZip], [ApplicantPhone], [Owner], [OwnerAddress], [OwnerCityStateZip], [OwnerPhone], [SiteStreetNumber], [SiteStreetDirection], [SiteStreetName], [SiteStreetPrefix], [SiteAddress], [SiteCityStateZip], [WorkDesc], [Comments], [APNNumber], [Zoning], [Occupancy], [ConstructionType1], [ConstructionDesc1], [ConstructionType2], [ConstructionDesc2], [OccCode1], [OccCodeDesc1], [OccCode2], [OccCodeDesc2], [SFBldg1], [SFBldg2], [AC], [BldgSpnk], [GarageSF], [PatioSF], [ManualVal], [Valuation], [SQFtTotal], [InputBy], [TotalPaid], [TotalFees], [FeesExempt], [DeveloperID], [NameConBldg], [NameConPlumb], [NameConElec], [NameConMech], [NameConArch], [NameConEng], [PlanDateApplied], [PlanDateApproved], [PermitApproveDate], [PermitDateApplied], [PermitDateIssued], [PermitDateExpires], [PermitDateFinaled], [PermitDatelastinspection], [VoidDate], [VoidDesc], [BuildingValuation], [BuildingValuation2], [BuildingValuation3], [BuildingValuation4], [BuildingValuation5], [GarageValuation], [PatioValuation], [PermitType], [ConstructionType], [OccCode1Prefix], [GarageCode], [PatioCode], [OccCode2Prefix], [OccCode3Prefix], [OccCode4Prefix], [OccCode5Prefix], [OccCode3], [OccCode4], [OccCode5], [SFBldg3], [SFBldg4], [SFBldg5], [Receipt], [WaterImpactType], [SewerImpactType], [InspectionZone], [PlanningGraphicFile1], [PlanningGraphicFile2], [PlanningGraphicFile3], [PlanningGraphicFile4], [PlanningGraphicFile5], [PlanningGraphicFile6], [PlanningGraphicFile7], [PlanningGraphicFile8], [PlanningGraphicFile9], [SchoolDistrictHS], [SchoolDistrictELM], [SchoolDistrictHSFee], [SchoolDistrictELMFee], [SchoolDistrictAdminFee], [SchoolDistrictSqFt], [SiteAddressStreet], [RefNumber], [DiscountOrPenaltyType], [DiscountAmount], [Community], [ExpireLetterSent], [PermitDateExpiresActual], [upsize_ts], [WilliamsonAct], [AgPreserveNumber], [AgContractNumber], [AgPreserveDate], [AgPlanningSignOff], [AgPlanningSignOffDate], [AgBuildingSignOff], [AgBuildingsignOffDate], [AgReleaseToIssue], [VestedYear] From [PermitsHeaderInfo] where (1=0) |
| Solution | |