troubleshooting Question

cf ListAppend?

Avatar of pigmentarts
pigmentartsFlag for United Kingdom of Great Britain and Northern Ireland asked on
Web Servers
2 Comments1 Solution366 ViewsLast Modified:
hi, hope someone can help me on this...


this pull out all my words...

<cfloop index="i" list="#subject#" delimiters=" .,?!:<>">
                         <cfif Len(i) GT 3>
                               <cfif listFindNoCase(goodlist, i) eq 0>
                                <cfset goodlist = ListAppend(goodlist, "%#i#%' OR subject LIKE '", " ") />
                                </cfif>
                         </cfif>
                  </cfloop>

goodlist is now this...
'%What%' OR subject LIKE ' %methodology%' OR subject LIKE '

i want to now take my words and search...

SELECT *
FROM articles
WHERE subject LIKE '#goodlist#'

but as you can see the sql is wrong, i get one too many OR subject LIKE and at the end 2x '

anh help to make the string vailed sql?
ASKER CERTIFIED SOLUTION
js_vaughan

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros