electofaysal
Posts: 7
|
Posted: 07/26/2004, 3:08 PM |
|
Hi.
In the search form ... when two words are searched .... it doesnt work ... e.g
Search for "Autos" -> gives every thing that contains Autos
Search for "Auto Repair" gives nothing at all ???
help?
|
|
|
Damian
|
Posted: 07/26/2004, 6:16 PM |
|
Thats because it is searching for exactly "Auto repair".
You may need to write your own search routine to get more granular. CCS ones
are not great for more loose searches.
"electofaysal" <electofaysal@forum.codecharge> wrote in message
news:5410580f8c17ff@news.codecharge.com...
> Hi.
>
> In the search form ... when two words are searched .... it doesnt work ...
e.g
>
> Search for "Autos" -> gives every thing that contains Autos
>
> Search for "Auto Repair" gives nothing at all ???
>
> help?
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
Walter Kempees
|
Posted: 07/27/2004, 2:26 AM |
|
Change your SQL syntax to
Select * from [tablename]
where field_searchedon like '%searchparameter1%'
or field_searchedon like '%searchparameter2%'
changing the OR into AND as needed.
Another approach would be to do a text search, if you need an example, reply
"Damian" <codecharge@sydneyit.no.com.junk> schreef in bericht
news:ce4adt$gjb$1@news.codecharge.com...
> Thats because it is searching for exactly "Auto repair".
> You may need to write your own search routine to get more granular. CCS
ones
> are not great for more loose searches.
>
>
> "electofaysal" <electofaysal@forum.codecharge> wrote in message
>news:5410580f8c17ff@news.codecharge.com...
> > Hi.
> >
> > In the search form ... when two words are searched .... it doesnt work
....
> e.g
> >
> > Search for "Autos" -> gives every thing that contains Autos
> >
> > Search for "Auto Repair" gives nothing at all ???
> >
> > help?
> > ---------------------------------------
> > Sent from YesSoftware forum
> > http://forums.codecharge.com/
> >
>
>
|
|
|
electofaysal
Posts: 7
|
Posted: 07/27/2004, 6:38 AM |
|
It would be great if you could give me an example.
I was searching for .... %contains% so shouldnt that pull up everything that contains auto repair ? ... How will i break up a search string into two different words ... might be what i am looking for ... and then search ? .....
|
|
|