Database Wizrd Problem

Hi, thanks for reading! I am using Frontpage 2000 Database wizard to set up a search table for my database. It works fine when I set up values like:

Last Name = Last Name or
Insert Name = Insert Name or
Year = Year or
Make = Make or

But I want the user to be able to fill in more then one field! So, by putting 1997 Topps (make) it should show only 1997 Topps cards, etc. I thought maybe setting up like this was the answer, but it did not work as planned:

Lastname = Lastname and
Insert = Insert or (THUS GIVING ME Matches to all with the same lastname and insert name as entered)
Lastname = Lastname and
Make = Make or (THUS GIVING ME matches to all cards with the same Lastname and make)

Continuing with AND AND OR, etc so if one or more fields are filled it works accordingly.

Thanks for help!!!!

Mike
Wed Feb 04 16:04:33 CST 2004

Use the LIKE operator.

Example:
Lastname LIKE '%::Lastname::%' and Insert LIKE '%::insert::%' and
etc.....

So if you put a last name in and no Insert name it will display all matches
with the last name. Or if you put both is it will display matches that meet
the criteria for both.

Hope This Helps,

Mikeal


"Chris J" <chriscardz@aol.com> wrote in message
news:318F5C85-06A7-4913-AB9E-99B2F78CB94F@microsoft.com...
> Hi, thanks for reading! I am using Frontpage 2000 Database wizard to set
up a search table for my database. It works fine when I set up values like:
>
> Last Name = Last Name or
> Insert Name = Insert Name or
> Year = Year or
> Make = Make or
>
> But I want the user to be able to fill in more then one field! So, by
putting 1997 Topps (make) it should show only 1997 Topps cards, etc. I
thought maybe setting up like this was the answer, but it did not work as
planned:
>
> Lastname = Lastname and
> Insert = Insert or (THUS GIVING ME Matches to all with the same
lastname and insert name as entered)
> Lastname = Lastname and
> Make = Make or (THUS GIVING ME matches to all cards with the same Lastname
and make)
>
> Continuing with AND AND OR, etc so if one or more fields are filled it
works accordingly.
>
> Thanks for help!!!!

Chriscardz
Wed Feb 04 19:36:08 CST 2004

Hi, thanks for the reply. It did not work. When i put and after each, it requires every field to be filled out. I want it so one field or 2 field , etc can be done and it fine tunes the search according to how many are filled out. Right now I use Like and or so only one field can be done to get it right. Kinda a pain. Please let me know, thanks, CHRIS

Mike
Wed Feb 04 22:47:55 CST 2004

I must not fully understand your problem....

I understand it as that you have a dbase of trading cards. You want to set
up a search page for users to search the database for a brand, a players
name, etc .....

If this is the case, you would set up a search form with many fields on it.

Field 1 = Name
Field 2 = Brand
Field 2 = Make

Then you need to pass those fields to the dbase query and use the LIKE
operator to narrow your search.

Select * From table_name Where Name LIKE '::%Name%::' and Brand LIKE
'::%Brand%::' and Make LIKE '::%Make::%'

Then the user would enter the following into the search form:

Field 1 = Name
Field 2 =
Field 3 = Make

This would return all matches of Name and Make. Brand was left blank so it
is ignored.

Mikeal

"Chris J" <Chriscardz@aol.com> wrote in message
news:D00B63E8-BAC1-49F5-99C1-6B540F300133@microsoft.com...
> Hi, thanks for the reply. It did not work. When i put and after each, it
requires every field to be filled out. I want it so one field or 2 field ,
etc can be done and it fine tunes the search according to how many are
filled out. Right now I use Like and or so only one field can be done to
get it right. Kinda a pain. Please let me know, thanks, CHRIS

anonymous
Thu Feb 05 10:56:05 CST 2004

Exactly, but it does not work when i do it with and, it makes me have to fill out ALL Fields to get the EXACT card. I have it set up as or right now, but only one field can be filled out You can see it at www.CHRISBASEBALLCARDS.com. Thanks again for your time!!!

Mike
Thu Feb 05 14:49:12 CST 2004

I am doing the exact same thing on my site. Could you please post you exact
query so I can look at it.

Mike


"Chris J" <anonymous@discussions.microsoft.com> wrote in message
news:8F4BD095-C071-422A-B030-F90F0F5BE94B@microsoft.com...
> Exactly, but it does not work when i do it with and, it makes me have to
fill out ALL Fields to get the EXACT card. I have it set up as or right
now, but only one field can be filled out You can see it at
www.CHRISBASEBALLCARDS.com. Thanks again for your time!!!