[thelist] [CFMX] How to implement a search feature?

Judah McAuley judah at wiredotter.com
Thu Jun 19 11:02:45 CDT 2003

Chris Johnston wrote:
> 1. Is there something like the java string tokenizer in CF? A simple way
> to take a string and split it into different words.

You can treat it as a space delimited list.  So if the search was for 
"foo bar baa" you could use ListLen(thelist, " ") to get the fact there 
are 3 words and you could use ListGetAt(thelist, 1, " ") to get the 
first search term.

> 2. I know in sql you can do a search using like and the wildcard
> character. Is there a way of doing this with a list.
> i.e. select * from foo where col in ('%word1%', '%word2%', etc...)
> and have it act in the same manner as using like?

Not that I know of.  You'd be better off though using full text search 
anyway.  Full text search is available in MS SQL and Sybase ASE I know 
and I think its available in MySQL and PostGres now.  Its really build 
for what you want to do.  If you tell us your DB we can probably provide 
some pointers to resources.


More information about the thelist mailing list