checking field content

[nick_endgame]

Hi,

I would like to be able to tell if a field contains a string such as "http" or "www".

How can i do this?

Thanks.

[mattw1]

<cfif FindNoCase('www',myField) OR FindNoCase('http',myField)>

[Stressed_Simon]

Or even better

<cfif reFindNoCase('www|http',myField)>

[Stressed_Simon]

Or even better than that
<cfif listFindNoCase('www,http',myField)>

[mattw1]

or did you mean via SQL?

WHERE myField LIKE '%www%' OR myField LIKE '%http%'

[nick_endgame]

Superb. Thank you both very much.

By the way, i meant by CF not SQL.

Thanks again.

[Dan_Bracuk]

You sure you actually got the right answer? Based on your original question, I don't think so.

[nick_endgame]

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.

Thanks.

[Dan_Bracuk]

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.