Hello,i was wondering if someone could help.
I have a search page on my website with 3 drop down boxes:
I have a database behind it with a table called Houses and field names in the table called Beds and Price.
So i want it to bring back results by number of beds and price range.
i got this but it doesnt work:
sql_srch = "SELECT * FROM Houses WHERE Beds like '%"& request("list_beds")&"%' AND Price BETWEEN '%"&request("min_p")&"%' AND '%"&request("max_p")&"%'"
i get this error: Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
I'd be so greatfull if anyone could help.