%%%%%%%%%%%%%% SQL Error Occurred IN getReadOnlyRS() %%%%%%%%%%%%%%%
Incorrect syntax near ')'.
SELECT o.Owner_ID, o.First_Name, o.Last_Name, o.Business_Name, o.Business_Display_Active, o.Last_Name_Display_Active, o.First_Name_Display_Active, o.Email_Display_Active, r.Rental_ID, r.Rental_Title, r.List_City, r.List_State, r.List_Zip, r.Rental_Bedrooms, r.Rental_Bathrooms, r.Rental_Bedding, r.Rental_Sleeps, r.Rental_Alt_Link, r.Rental_Alt_Link_Text, r.Rental_Alt_Link_2, r.Rental_Alt_Link_Text_2, r.List_Phone, r.List_Alt_Phone, r.Airport_Distance, r.Airport_Abbrev, r.Shopping_Distance, r.Shopping_1, r.Shopping_2, r.Restaurant_Distance, r.Restaurant_1, r.Restaurant_2, r.Cleaning, r.Sales_Tax, r.Payment_Visa, r.Payment_Mastercard, r.Payment_Discover, r.Payment_Amex, r.Payment_MoneyOrder, r.Payment_Cashier, r.Payment_Check, r.Payment_Transfer, r.Check_In, r.Check_Out, r.Required_Stay, r.List_Dwelling, r.Beach_Proximity, r.Skiing_Proximity, r.Theme_Park_Proximity, r.Sport_Complex_Proximity, r.Rates_Info, r.Feedback_Average, r.Date_Added, r.Rentors_Number, r.Rental_Active, r.Avail_Active, r.Rentors_Avail_Active, r.Guest_Active, r.Photo_Active, r.PropMgr_Active, r.PropMgrID, r.Golf_Proximity, r.Other_Fees, r.Rental_Cancellations, r.Rental_Deposit, r.Rental_Attractions, r.Amen_Other, r.Rental_Description, r.AskForContact, r.Tier, r.PaypalEmail, r.CountryID,r.List_Region,c.CountryName,p.No_Pets,r.communityName FROM Owners o INNER JOIN Rental r ON o.Owner_ID = r.Owner_ID INNER JOIN Property p ON r.Rental_ID=p.Rental_ID INNER JOIN tblCountry c ON r.CountryID=c.CountryID WHERE (r.Rental_Active=1) AND (r.Rental_ID = )