Database search fields

[Nicki]

I tried to add the '::hiddenfield::' into my html, but
FrontPage kept overwriting it. Is there a way I can stop
FrontPage from overwriting my changes or am I just doing
something wrong?


Nicki, the easiest way to do this is to add a hidden form
field in your search form and change the query to test
for a blank entry
('' is two single quotes)....

SELECT * FROM TableName Where (... your query...)
OR '::hiddenfield::' = ''

<input type="hidden" name="hiddenfield" value="true">

If your form has only one search field, you can use it to
test for a blank.

OR '::searchfield::' = ''


--

Stephen Travis
Microsoft MVP - FrontPage

Can I display all the records in a database and include a
search field? I already have a search field, but it
doesn't show any records until you enter text to search
for. I want to start with a view of the whole database,
and have users narrow down the options by using the
search fields. Can I do that?

..

 

[Stephen Travis]

The SELECT statement is entered as a custom query in the DRW. FP will not allow you to edit the 'maroon' text in HTML mode.