SQL OR operator question
Posted on 2014-03-14
On my real estate search page form I have a distinct query that pulls in all the property types, "type", and it's quite a few in my dropdown select! I'd like to group some of the property types together to make the select dropdown more user friendly. Such as I'd like to group the type "condo" with "townhouse" and "zero lot line" in my form select dropdown, instead of having :
Zero Lot Line
Condo / Townhouse / Zero Lot Line
My form submits to results page query:
<cfif StructKeyExists(form,"Type") and len(trim(form.Type))>
AND Type = (
<cfqueryparam value="#form.Type#" cfsqltype="cf_sql_varchar" list="true">
So on my search form select I tried to hard code the property type like this:
<option value="Townhouse" OR Type="Condominium" OR Type="Zero Lot Line">Condo / Townhouse / Zero Lot Line</option>
It does not throw an error, but it only queries the first type "Townhouse" and not condominium or zero lot line.
Can someone show me a better way to code this?