Searching range for single field: best practice

Hello,

I am wondering what is the best practice for creating a search form that will search a single field for a range?

Specifically, I have a database column for "age." It shows up as an available option for a search page but, I'm not sure how to search that single field for both >= and <=.

DataAssist allows me to add "age" twice, but each time it is called "age" and I don't see a way to edit one as "minimum age" (>=) and the other as maximum age (>=).

What is the best way to search for a range on a single database column?

In the Data Assist Create pages wizard, when setting up the search page, you can define a criteria for each filed, see the attached screen shot

Thank you for the reply, Jason. That's the screen I've been using, but as I said, each time I add "age," once for the minimum and once for the maximum, it just uses the name of the database column "age" for both.

Can I edit the label for each age, so that I have "min age" and "max age" both searching on the column "age" through the DataAssist interface or do I have to dig into the HTML?

You would need to change the labels after the search page is created.

OK, thanks.

It wasn't that simple.

One must edit the DataAssist search server behavior for the results page with Dreamweaver to give the fields that are searching the same column (age, in my example) a unique value. (I did MinAge and MaxAge.)

Then one must change the label, ID and name for those fields on the search page and, additionally, change the PHP that echos the values of those if set. Like this:

---------------------
<div class="lineGroup"> <label for="MinAge" class="sublabel" > Minimum Age:</label>
<div class="errorGroup">
<span>
<input id="MinAge" name="MinAge" type="text" value="<?php echo((isset($_GET["MinAge"])?$_GET["MinAge"]:"")); ?>" class="formTextfield_Medium" tabindex="6">
</span>
</div>
</div>

I have logged a bug for this in our system so it can be corrected in a future update.