|
|
|
|
|
| | |
| |
Active Server Pages ASP control controls class classes module script Scripts applet CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Searching fields with multiple entries |
|
From: |
Harlan |
|
Date: |
3/23/1999 8:44:46 AM |
|
IP: |
206.222.20.2 |
well, your post was a little confusing at least to me. But I'll give it a shot. What it seems to me your saying is.. you have a drop down list, containing some types of art. You want people to be able to select multiples, and search on them all (if thats wrong, I'll try again if you try and clearify, also you have code??) Anyway, you can't just use "field like %whatever, whatever2%" you want "field like %whatever% and field like %whatever2%" So if your using a drop down box (you didn't say, and didn't post code) you can use split() to build a dynamic sql statement that adds like %" & aryNewSplitArray(someCounter) & "%
for each of the values passed from the drop down list.
hth,
Harlan |
Previous Message
Follow Up - Re: Searching fields with multiple entries - Patti Thompson 3/23/1999 1:22:31 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
