Help with Database Search Form

[kdstratton]

I am at my wits end and need some assistance getting results from a database
search result to work properly.
I want to allow visitors to enter a search word in a database results form
that will return a table which will only show the Database items that contain
their search word.
Text box on form is labeled "Search"
Access Table name is "products"
Field to be searched is "Full Desc"

I have tried every combination of options through the DRW but all I get is
the NO RESULTS message.

TIA
Kelle

 

[Stefan B Rusynko]

Don't use the DBR
See http://www.asp101.com/samples/db_search.asp




|I am at my wits end and need some assistance getting results from a database
| search result to work properly.
| I want to allow visitors to enter a search word in a database results form
| that will return a table which will only show the Database items that contain
| their search word.
| Text box on form is labeled "Search"
| Access Table name is "products"
| Field to be searched is "Full Desc"
|
| I have tried every combination of options through the DRW but all I get is
| the NO RESULTS message.
|
| TIA
| Kelle

 

[Jon Spivey]

Hi,
doesn't
SELECT * FROM Table
WHERE FullDesc LIKE '%::Search::%;
work for you?

If Full Desc really has a space surround it with [ ] eg WHERE [Full Desc]

 

[kdstratton]

Stefan,
Thank you for the link. I will check it out.

 

[kdstratton]

Jon,
Thanks for the input. I tried this statement and received a Database Results
Error message.

Hi,
doesn't
SELECT * FROM Table
WHERE FullDesc LIKE '%::Search::%;
work for you?

If Full Desc really has a space surround it with [ ] eg WHERE [Full Desc]
--
Cheers,
Jon
Microsoft MVP

I am at my wits end and need some assistance getting results from a
database
search result to work properly.
I want to allow visitors to enter a search word in a database results form
that will return a table which will only show the Database items that
contain
their search word.
Text box on form is labeled "Search"
Access Table name is "products"
Field to be searched is "Full Desc"

I have tried every combination of options through the DRW but all I get is
the NO RESULTS message.

TIA
Kelle