In my restaurant database I give people the opportunity to search by neighborhood, and/or cuisine.

Also, they can do a search on the actual NAME of the restaurant.

If a restaurant is called Cathy's Cafe
and they just enter Cathy, the name won't come up unless they also check Match Any it won't bring it up.

Is there a way to make it a "Match Any" search everytime? Are there disadvantages to this?

Thanks in advance!

Lenny

------------------
Catalyst for the new millenium

Try adding the following code to your search form:


Haven't tested this, but logically it should work.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us

You wrote:
<<No, the Value="on" should not be in your INPUT TYPE=TEXT statement.
Also, is the "name" the exact NAME you have for the Name variable in the default.db?
>>

"Name" is the exact name of the variable (Input) in my Main Page where the search field is and it searches default.db (it is also the name of the FIELD that the restaurant name is in in default.db).

Please see:

www.bestweb.net/~cyborgny/tob/cgi-bin/dbman/main.html

and

www.bestweb.net/~cyborgny/tob/cgi-bin/dbman/default.db

for more info.
Thanks again!

Lenny

Sorry but this doesn't seem to work.

<INPUT TYPE="HIDDEN" NAME="ma" VALUE="on">
<FONT FACE="verdana">FIND A RESTAURANT BY NAME</font>
<INPUT TYPE="TEXT" NAME="name" SIZE=25 MAXLENGTH=255 VALUE="on"> Name Search

Should I put it within the text input field? or should I in the Match Any checkbox put in "Value="on"?

I tried it both ways.

Thanks!

No, the Value="on" should not be in your INPUT TYPE=TEXT statement.

Also, is the "name" the exact NAME you have for the Name variable in the default.db?

Please post your full form codes, so that we can help you. Also, if you could post the URL where you have the database installed, it may help us to see a visual of your project.



Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us

[This message has been edited by Eliot (edited July 21, 1999).]

Your form is NOT correctly formatted.

Here are some lines that you should edit.

Your original codes:

Try this:


Notice the bolded text.

Also, try taking out the Keyword search field in your form.

See what happens.

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us