Hi ... i am a newbie to CF ... I was wondering if some one could help me
figure out how to make a search box that can do a "contains" search ... i
can get the begins with and the equals, but not contains ... see below
thanks!
<cfset WhereClause = "0=0">
<cfif Form.titleValue GT "">
<cfif Form.titleOperator EQ "EQUALS">
<cfset WhereClause = WhereClause & "and Title ='" &
form.titleValue & "'">
</cfif>
<cfif Form.titleOperator EQ "BEGINS_WITH">
<cfset WhereClause = WhereClause & " and Title like '" &
form.titleValue & "%'">
<cfelse>
<cfset WhereClause = WhereClause & " and Title like '" &
form.titleValue & WHAT DO I PUT HERE TO MAKE CONTAINS
WORK?>
</cfif>
</cfif>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
