HI, I am about to try:
http://cflib.org/udf.cfm?ID=760 I think I will have to worry about test quotes, and remove them. >>> [EMAIL PROTECTED] 28/01/2005 9:13:12 am >>> Replace all spaces with commas, replace all "AND" and "OR" with blank strings and create a list of terms from that? Quick and dirty :) Are you going to worry about quoted values, e.g. "find exact string" anotherkeyword... Must be some functions on cflib.org for this? ? Darryl Lyons [EMAIL PROTECTED] wrote on 28/01/2005 07:37:10 AM: > Hi, > > I would like to pass a search term to a query, the search term may have > multiple words, and I would like to strip out any AND's and OR's or > commas (or any other character not a letter), and then build the where > clause of the query from a delimited list. > > search terms: "paediatric burns" "paediatric and burns" "paediatric, > burns" > > query: > where > keyword = 'paediatric' or > keyword = 'burns' > > as you can see, I don't want a complicated query. The database search > will complement a Verity search. > > Sooo, the task I need to do is strip out all of the crap and create a > delimited list of values I can CFLOOP over. What is the best way to do > that? > > > > > > > > Scott Thornton, Programmer > Application Development > Information Services and Telecommunications > Hunter-New England Area Health Service > Phone RNH +61 2 49236078 JHH +61 2 49214193 > Fax +61 2 49214191 > > [EMAIL PROTECTED] > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ To unsubscribe from this email please forward this email to [EMAIL PROTECTED] This email message is confidential and may be privileged. If you are not the intended recipient please forward the email to [EMAIL PROTECTED] and delete the original. ABN AMRO Morgans Limited and its associates hold or may hold securities in the companies/trusts mentioned herein. Any general advice included in this email has been prepared without taking into account your objectives, financial situation or needs. Before acting on the advice, you should consider its appropriateness or discuss with one of our investment advisors. ABN AMRO Morgans Limited (ABN 49 010 669 726 AFSL 235410) A Participant of ASX Group. A principal member of the Financial Planning Association. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
