FlorisKruger
Technical User
HELP!! I am very new to this and very much lost! What I need to achieve is a property search which lists properties with the search criteria as shown but prices are selected from "from" and "to" fields ranging between 100 000 and 3 000 000.
SELECT Type, CityTown, Suburb, Price, Bedrooms, Bathrooms, EnSuite
FROM Main
WHERE Price BETWEEN varPrice1 AND varPrice2 AND Suburb = 'varSuburb' AND Type = 'varType'
ORDER BY Price
varSuburb % Request.Form("Suburb"
varType % Request.Form("Type"
varPrice1 0 Request.Form("Price1"
varPrice2 0 Request.Form("Price2"
SELECT Type, CityTown, Suburb, Price, Bedrooms, Bathrooms, EnSuite
FROM Main
WHERE Price BETWEEN varPrice1 AND varPrice2 AND Suburb = 'varSuburb' AND Type = 'varType'
ORDER BY Price
varSuburb % Request.Form("Suburb"
varType % Request.Form("Type"
varPrice1 0 Request.Form("Price1"
varPrice2 0 Request.Form("Price2"