|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Searching fields with multiple entries |
|
From: |
Patti Thompson |
|
Date: |
3/22/1999 10:29:56 PM |
|
IP: |
24.0.238.142 |
Help! I have a table with multiple fields (duh!), but three of the fields contain multiple search criteria.
(i.e., Art Categories - Fine Art; High-quality, fine craft; Country craft; Offset Lithograph Prints; Handpainted craft; etc...a given event could have as many as 11 different Art Categories)
My problem is this...I need to be able to search on key phrases within a given field. Using LIKE returns the recordset if the key phrase is the only entry in the field, fails when the field contains more than one category, even if the search criteria is first in the list.
Is it even possible to search for key words or key phrases where there are more than one in a given field? I really don't want to have to set up fields for *every* occurance of a variable in a given record. |
Follow Up - Re: Searching fields with multiple entries - Harlan 3/23/1999 8:44:46 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
