This content has been marked as final. Show 4 replies
You can filter out and, or, etc. by using the REReplaceNoCase( ) function. I'm not sure what you mean "filter on word length." Could you give an example?
hi thx for your answer, the replace and rereplace you use after executing the cfquery, i want to filter within the query itselve, directly from the database and nt first pull everything and then filter.
The word length i mean word length the length of a word, so i wat to filter out al words that are smaller then 6 characters for example
If you are storing one word per record and your db has a length function, it becomes something like
where length(thefield) >= 6
hi thx again, but it's more then one word :)
So i'll give a more clear vision:
I have a text in one column,i need to filter true that whole text to not select words that are bigger then 6 characters, that's one
Then i need to filter on specific words like: (and, or,this) i know about the find and replace functions, but how do i give filter criteria in one list, so filter with find and replace function all the given words in a list, i dont want a whole page of find and replace rules...