cfif and like

[jazz823]

I have a data collection that uses verity, I want to eliminate any results that contain the word footer in them. This is my code< i am overlooking something and I feel it is due to lack of sleep. Any thoughts? thanks

[brianism]

Try changing this
<cfif #key# is not "">
and #key# is LIKE '%footer%'

to this

<cfif #key# NEQ "" AND #key# LIKE '%footer%'>

[jazz823]

Iget the following error

Invalid CFML construct found on line 34 at column 30.
ColdFusion was looking at the following text:

LIKE

The CFML compiler was processing:

* a cfif tag beginning on line 34, column 2.

[Dan_Bracuk]

"like" is an sql keyword. The equivalent cf function is contains. Usage is described in the cfml reference manual and livedocs.

[Newsgroup_User]

On Fri, 19 Sep 2008 18:49:11 +0000 (UTC), brianism wrote:

> Try changing this
> <cfif #key# is not "">
> and #key# is LIKE '%footer%'
>
> to this
>
> <cfif #key# NEQ "" AND #key# is LIKE '%footer%'>

Can you please talk us through why you made this post / suggestion?

--
Adam

[brianism]

quote:

---

Originally posted by: Newsgroup User
On Fri, 19 Sep 2008 18:49:11 +0000 (UTC), brianism wrote:

> Try changing this
> <cfif #key# is not "">
> and #key# is LIKE '%footer%'
>
> to this
>
> <cfif #key# NEQ "" AND #key# is LIKE '%footer%'>

Can you please talk us through why you made this post / suggestion?

--
Adam

---

That would be because I could not remember if it should have been LIKE or CONTAIN. This coding stuff turns my mind into mush sometimes.

[Newsgroup_User]

> That would be because I could not remember if it should have been LIKE or
> CONTAIN. This coding stuff turns my mind into mush sometimes.

Heh. At least you're honest. ;-)

--
Adam

[gdemaria]

Here is the syntax...

<cfif key contains 'footer'>

<cfelseif len(foundResults.title) EQ 0>
<a href="interior.cfm?Cid=#key#">- Result - </a>
<cfelse>
<a href="#foundResults.URL#" target="_blank"> #foundResults.title#</a>
</cfif>



You don't need to check if key is not "" because it will not contain footer if it's empty.

You also don't need the # signs inside the CFIF