Database results page not using 'Defaults'

[Bill Bailey]

I am using FrontPage 2002 and the Database Results Wizard
to enable users to view results from a database. I've
added a dropdown list with two values to filter the
database results based on the list item they select. This
works great. However, when the page initially displays,
it only shows a subset of the database records. I would
like for the page to show ALL records when the page is
initially displayed and only filter the results when the
user selects an item from the dropdown list and clicks
the "Submit" button. I tried setting the "Default Value"
for "Input Parameters" (in the DRW Step 3 | More Options |
Defaults dialog box) to the "%" wildcard but the page
still does not show all records.

I would appreciate any thoughts about how to implement
this feature. Thanks in advance!

 

[Mike Stumpo]

Under DRW, go to More Options.. and make sure that "Limit
number of returned records to:" is NOT checked. If you
have more than 256 records, this will limit the returned
records.

HTH