Frontpage wishlist

R

R Keck

Maybe one of the MS Mods can direct this to the appropriate place ...

I'd like to see the ability to change a result forms' criteria input box
from a text input box to a drop-down (or other type list) box.

I'm speaking of the webbot created text boxes. But a better solution might
be to ask the user when running the results wizard, what type of criteria
input form field would you prefer.

P.S. If someone knows of a relatively simple way to remove the webbot's
text input field and replace with a drop-down box, and have the criteria
inputs and results STILL work, I'd like to know.

Thanks
 
A

Andrew Murray

You can do that now.....

Make up your main results page with the DBRW, in the Criteria use a query
like Select * from Table RESULTS where Name CONTAINS [name] and use the
search field option. (yes, it will generate the normal text box), then when
the page is generated, do another results region *inside* the search form
created by the first results region. Make the output the drop down box -
this becomes the basis for your query - it will be populated by a field from
your db eg postcodes or cities or countries; and clicking the "Submit Query"
button will search the db and return the results to the main results region.

See here for an example

http://www.cursillo.perth.anglican.org/announcements.asp

In the above example, the results all come up at once initially; but you can
"filter" the results with the drop down/search box at the top of the page.
 
Top