Keyword search

[skc]

I have a Access2000 database as a backend on my website
created in FP2000.

I want to create a keyword search for any word typed in.
The site is to do with cars,
so "Ford", "BMW", "Automatic", "Leather" etc... are all
valid keywords.

The fields in my database are Make, Model, Description...

e.g.

Make: BMW
Model: 328i SE
Transmission: Auto
Description: Black, leather interior, alloy wheels, radio
cassette

How do I create a keyword search that scans the entire
database and returns to me rowsets that find matching
words - or better still a partial match?

Thanks,

skc

 

[Jim Buyens]

-----Original Message-----

I have a Access2000 database as a backend on my website
created in FP2000.

I want to create a keyword search for any word typed in.
The site is to do with cars,
so "Ford", "BMW", "Automatic", "Leather" etc... are all
valid keywords.

The fields in my database are Make, Model, Description...

1. On page 3 of the DRW, click More Options and then
Criteria.
2. Click Add, then specify:
Field Name: Make
Comparison: Like
Value: keyword
Use This Search Form Field: selected
And/Or: Or
3. Repeat step 2 for Model and Description. Be sure to
keep specifying Value: keyword.
4. Click OK, OK, Next, Next.
5. On page 5 of the DRW, select the Add Search Form
check box, and then click Finish.
6. Double-click any yellow area in the database results
region.
7. On page 2 of the DRW, click Custom Query and Edit.
This should reveal a SQL statement that includes this
code:
WHERE (Make LIKE '::keyword::'
OR Model LIKE '::keyword::'
OR Description LIKE '::keyword::')
8. Add percent signs around each occurrence of the
the word "keyword". Here are some samaple results.
WHERE (Make LIKE '::%keyword%::'
OR Model LIKE '::%keyword%::'
OR Description LIKE '::%keyword%::')
9. Click OK, Next, Next, Next, and Finish.
10. Save the page, and test it using an http:// URL.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------