This content has been marked as final. Show 8 replies
<cfif FindNoCase('www',myField) OR FindNoCase('http',myField)>
or did you mean via SQL?
WHERE myField LIKE '%www%' OR myField LIKE '%http%'
Or even better
Or even better than that
Superb. Thank you both very much.
By the way, i meant by CF not SQL.
You sure you actually got the right answer? Based on your original question, I don't think so.
Thanks for the post Dan. You're right, I didn't get the right answer based on my original question. Just done some testing.
My own fault, didn't explain my aim properly. I would like to be able to submit a form textarea and check the content of the textarea for instances of strings such as "www" and "http". I am actually trying to stop people from entering links and html in form fields.
I hope this is a more specific post.
The function you want to use is called contains. Usage is described in the cfml reference manual. If you don't have one, the internet does.