lucene is another option. http://jakarta.apache.org/lucene/docs/index.html AFAIK there is a cf tag in the DRK that using lucene
-----Original Message----- From: Ryan Emerle [mailto:[EMAIL PROTECTED] Sent: 22 August 2003 16:45 To: CF-Talk Subject: RE: Arrrgh, this is driving me crazy, and I know it's so simple t o do... This is precisely why we created our own search engine. We can actually index arbitrary field names (removing the need for anything like CUSTOM1/2) and have them returned with the search results. We have a very powerful suite of tags based on an opensource project that replaces verity and extends the searching abilities of CF 10-fold (with about 3 times the speed). This suite of tags will be publicly released relatively soon, free of charge. It should prove to be an extremely potent, FREE, replacement for Verity. Example, We have an index of 75,000 articles. Most searches take about 200ms at most, AND we dont need to parse out the additional information (such as articleIDs, headlines, release dates, etc) as they have their respective fields in the search result recordset. Sorry for the ~OT, but i felt it was relevant. -Ryan -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, August 22, 2003 11:19 AM To: CF-Talk Subject: RE: Arrrgh, this is driving me crazy, and I know it's so simple t o do... Then, within your display code, you could parse the key - in the above case, using the colon as a separator - to find both the table and the primary key within the table. Alternatively, you could store information in the CUSTOM1 and CUSTOM2 fields - that might be a little easier, but wouldn't allow you to index more than one table within the same collection if you're using surrogate keys generated by identity columns or the like. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
