ksa
Posts: 27
|
| Posted: 02/01/2004, 10:21 AM |
|
I'm using CCS 2.056 and I'm trying to build a search form where the resulting database query doesn't automatically truncate the search string.
For example, doing a search for the word "promise" not only finds that word, but also "promised", "promises", etc. Is there anything I can do about that?
|
 |
 |
peterr
Posts: 5971
|
| Posted: 02/01/2004, 3:07 PM |
|
The question is why doesn't this work for you already?
The database should find all records that contain the word you're searching for, regardless of what is around it. Which database are you using? Also, did you specify "contains (like '%...%')" in your grid's Data Source parameters?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
DonB
|
| Posted: 02/02/2004, 8:15 AM |
|
You might find that searching for "% promise %" (note the spaces) will work.
If this is searching a text where punctuation is possible (containing text
like "promise.") then it becomes more difficult and my suggestion won't work
100%. You probably would need to look for a more sophisticated
text-indexing engine rather than trying to query your data table directly.
--
DonB
http://www.gotodon.com/ccbth
"ksa" <ksa@forum.codecharge> wrote in message
news:5401d43bd6c415@news.codecharge.com...
> I'm using CCS 2.056 and I'm trying to build a search form where the
resulting database query doesn't automatically truncate the search string.
>
> For example, doing a search for the word "promise" not only finds that
word, but also "promised", "promises", etc. Is there anything I can do about
that?
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
ksa
Posts: 27
|
| Posted: 02/02/2004, 12:38 PM |
|
Thanks for the reply thanks to which I figured out what was wrong. I wasn't aware I was going to look for the problem in the grid containing the search results. When I looked at the data source for that, there was both a left and right truncation per default. When I removed that everything was fine. I had been focusing on the search form rather than the search results grid.
|
|
|
|
|
