ASP error happened
| Technical information | |
| Error number | -2147217900 |
| Error description | Syntax error (missing operator) in query expression 'PropertyId='. |
| URL | /mysites/Realestate/retblresults_view.asp |
| SQL query | select [PropertyID], [MLS_Number], [House_Number], [Street_Name], [Apartment/Unit], [City], [State], [Zip], [Country], [Price], [sType], [Style], [Bedrooms], [Bathrooms], [Year], [Foundation], [Sq_Ft], [Garage], [Acres], [Kitchen], [Kitchen_Dimension1], [Kitchen_Dimension2], [Living_Room], [Living_Room_Dimension1], [Living_Room_Dimension2], [Family_Room], [Family_Room_Dimension1], [Family_Room_Dimension2], [Rec_Room], [Rec_Room_Dimension1], [Rec_Room_Dimension2], [Study_Room], [Study_Room_Dimension1], [Study_Room_Dimension2], [Sun_Room], [Sun_Room_Dimension1], [Sun_Room_Dimension2], [Loft], [Loft_Dimension1], [Loft_Dimension2], [Dinning_Room], [Dinning_Room_Dimension1], [Dinning_Room_Dimension2], [Amusement_Room], [Amusement_Room_Dimension1], [Amusement_Room_Dimension2], [Foyer], [Foyer_Dimension1], [Foyer_Dimension2], [Office], [Office_Dimension1], [Office_Dimension2], [Den], [Den_Dimension1], [Den_Dimension2], [FullBaths], [s3/4Baths], [s1/2Baths], [Fireplaces], [Wood_Burning_Fireplace], [Gas_Burning_Fireplace], [Range], [Cooktop], [Dishwasher], [Disposal], [Dryer], [Exhaust_Fan/Hood], [Microwave], [Refrigerator], [Wall_Oven], [Water_Softener], [Eat_In_Kitchen], [Kitchen/Dining_Room], [Separate/Formal_Dining_Room], [Basement], [Finished_Basement], [Drain_Tiled], [Sum_Pump], [Walkout], [Daylight/Lookout_Windows], [Cooling], [Heating], [Lot], [Lot_Dimension1], [Lot_Dimension2], [Lot_Dimension3], [Lot_Dimension4], [Lot_Dimension5], [Lot_Dimension6], [Lot_Dimension7], [Lot_Dimension8], [Tax_Amount], [Tax_Year], [Remarks], [PhotoListing], [Photo1], [Photo2], [Photo3], [Photo4], [Photo5], [Photo6], [Photo7], [Photo8], [Photo9], [Photo10], [Photo1] as vPhoto1, [Photo2] as vPhoto2, [Photo3] as vPhoto3, [Photo4] as vPhoto4, [Photo5] as vPhoto5, [Photo6] as vPhoto6, [Photo7] as vPhoto7, [Photo8] as vPhoto8, [Photo9] as vPhoto9, [Photo10] as vPhoto10 From [retblresults] where [PropertyID] is null |
| Solution | |