Finding all

[mbarnett]

My boss is trying to set up a property location search

He wants to be able to search by 3 fields

state from a pull down menu

square footage from a pull down menu

rate from pull down menu

He has

<SELECT NAME=state>

<OPTION>

<OPTION VALUE=GA>Georgia

<OPTION VALUE=FL>Florida

<OPTION VALUE=AL>Alabama

<OPTION VALUE=VA>Virginia

<OPTION VALUE=WV>West Virginia

<OPTION VALUE=SC>South Carolina

<OPTION VALUE=NC>North Carolina

<OPTION VALUE=TN>Tennessee

<OPTION VALUE=MS>Mississippi

</SELECT><INPUT TYPE="hidden" NAME="-lop" VALUE=AND>

for the state

You can't seem to add

<option value=>All States

It returns no records found.

The <option> leaves a blank line in the pull down but works.

Anyway to set the All State value in the pull down for all three fields?

Platform: Mac OS 9

[jonesy17]

I assume you're doing this through CDML?

Try:

<SELECT NAME=state>

<OPTION VALUE="">ALL STATES

<OPTION VALUE=GA>Georgia

<OPTION VALUE=FL>Florida

...

</SELECT>

[mbarnett]

All ready tried adding <OPTION VALUE="">ALL STATES

but if does not work (No records found)

[Vaughan]

You need to create a calculation field in the database (I call it StateSearch) where

State & "