Try cflib for a UDF. LiveDocs will have a list of the reserved words I think.
"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Jason Herbolsheimer To: CF-Talk Sent: Fri Jan 12 19:46:17 2007 Subject: RE: cfsearch issue Is there a set list of reserved words that I can/should use? Is there a udf out there that I could use/modify to replace and surround these reserved words with single quotes? -----Original Message----- From: Everett, Al (NIH/NIGMS) [C] [mailto:[EMAIL PROTECTED] Sent: Friday, January 12, 2007 1:18 PM To: CF-Talk Subject: RE: cfsearch issue If you want to use a reserved word as part of the Verity search, you need to put it in quotes. Criteria="Why $50 per Barrel Oil is 'Not' Out of the Question" -----Original Message----- From: Jason Herbolsheimer [mailto:[EMAIL PROTECTED] Sent: Friday, January 12, 2007 2:06 PM To: CF-Talk Subject: cfsearch issue Hello, I have run into a problem using a verity index and cfsearch. The problem I'm having is that the search string that is being used has the word "Not" in it. The search string is listed below, with the error I'm getting. The cfsearch code is listed below that. Does anyone know how I get around this issue? Thanks in advance. Search string: Why $50 per Barrel Oil is Not Out of the Question Error: Invalid search CRITERIA specified: Why AND $50 AND per AND Barrel AND Oil AND is AND Not AND Out AND of AND the AND Question. Code: <cfset thekeyword = "<MANY><STEM>" & replace(trim(keyword),' ',' AND ','ALL')> <cfsearch name = "newsSearch" collection = "mycollection" criteria ="#thekeyword#" type="explicit" startrow=1 maxrows = "5000"> Jason Herbolsheimer 11204 Davenport, Suite 200b Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 Ext 102 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266488 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
