Access db search result behaviour

Hi all.

The following search was built with frontpage 2002 to query an
Access table. At the moment it insists on a value in both
fields or returns an error. How do I write this so an answer
in either one or none or all fields produces an answer.
i.e. if no fields of the search form are completed the entire
table is the result, and if one or more fields are completed
it simply 'narrows' the search?

AGE
"
size="20">

CITY
"
size="20">

These are only two of the fields here for illustration but there
are more in the search

Many thanks for any pointers

Re: Access db search result behaviour

"Richard Rosser" wrote in message
news:5cBHg.13390$_06.2806@newsfe4-gui.ntli.net...
> Hi all.
>
> The following search was built with frontpage 2002 to query an
> Access table. At the moment it insists on a value in both
> fields or returns an error. How do I write this so an answer
> in either one or none or all fields produces an answer.
> i.e. if no fields of the search form are completed the entire
> table is the result, and if one or more fields are completed
> it simply 'narrows' the search?
>
> AGE
> "
> size="20">
>
> CITY
> "
> size="20">
>
> These are only two of the fields here for illustration but there
> are more in the search

How does "it insist"? Show us that code.

I'm not familiar with "Request()"; I have heard of "Request.Cookies()"
"Request.Form()", "Request.QueryString()", Request.ServerVariables()".

URL:http://www.w3schools.com/asp/asp_ref_request.asp

URL:http://www.netzone.ch/caspdoc/Ch9_ASPBuiltIn30.html

Re: Access db search result behaviour

"McKirahan" wrote in message
news:vcmdnd5Wyft-e3PZnZ2dnUVZ_oqdnZ2d@comcast.com...
> "Richard Rosser" wrote in message
> news:5cBHg.13390$_06.2806@newsfe4-gui.ntli.net...
> > Hi all.
> >
> > The following search was built with frontpage 2002 to query an
> > Access table. At the moment it insists on a value in both
> > fields or returns an error. How do I write this so an answer
> > in either one or none or all fields produces an answer.
> > i.e. if no fields of the search form are completed the entire
> > table is the result, and if one or more fields are completed
> > it simply 'narrows' the search?
> >
> > AGE
> > "
> > size="20">
> >
> > CITY
> > "
> > size="20">
> >
> > These are only two of the fields here for illustration but there
> > are more in the search
>
> How does "it insist"? Show us that code.
>
> I'm not familiar with "Request()"; I have heard of "Request.Cookies()"
> "Request.Form()", "Request.QueryString()", Request.ServerVariables()".

It is the standard search script code written by MS FrontPage when you
generate a page containing DB Table results from an Access Table.
The whole scrit is very long - do you want to see the entire thing?

Here is the entire code

Re: Access db search result behaviour

"Richard Rosser" wrote in message
news:7eCHg.13395$_06.3625@newsfe4-gui.ntli.net...

[snip]

> It is the standard search script code written by MS FrontPage when you
> generate a page containing DB Table results from an Access Table.
> The whole scrit is very long - do you want to see the entire thing?

I'd recommend a Frontpage newsgroup such as microsoft.public.frontpage.

Re: Here is the entire code

Richard wrote on Fri, 25 Aug 2006 12:45:22 GMT:

>