not sure about 4, but verity can certainly search within a Database.... I must admit, I have never had to use the full text searches as our server guys dont like the load they cause.
-----Original Message----- From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] Sent: 30 June 2003 10:41 To: CF-Talk Subject: RE: UDF for MSSQL full-text searches Yes, cause verity (at least in CF 4, which we are partly on) can't search things in the database. And the MSSQL full-text indexing seems very good to me! ------------------------------------------------------------- Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project Officer Phone: +46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no ------------------------------------------------------------- | -----Original Message----- | From: Robertson-Ravo, Neil (RX) | [mailto:[EMAIL PROTECTED] | Sent: Monday, June 30, 2003 11:13 | To: CF-Talk | Subject: RE: UDF for MSSQL full-text searches | | | Have you ruled out Verity? | | -----Original Message----- | From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] | Sent: 30 June 2003 10:17 | To: CF-Talk | Subject: UDF for MSSQL full-text searches | | | Hi, | | I am using the MSSQL full-text indexes for searching in a | database from a | webpage. Is there an UDF out there that would 'bake' in data | for that, or | is there a simple way to solve this with regexps... ? If not, | I would have | to look into that myself (if not regexps, the string needs to | be looped). | | If the form contains: | apple pear | I would like the UDF to convert it to: | apple NEAR pear | | If the form contains: | apple AND pear (or instead of AND, NEAR or OR) | I would like the UDF to keep that. | | If the form contains: | "apple pear" | I would like the UDF to keep that. | | Here comes the tricky bit: | If the form contains: | apple "pear peach" | I would like the UDF to convert it to: | apple NEAR "pear peach" | | (i.e. it shouldn't touch anything inside quotes) | | Any help? | | /Hugo | | | | ------------------------------------------------------------- | Hugo Ahlenius E-Mail: [EMAIL PROTECTED] | Project Officer Phone: +46 8 230460 | UNEP GRID-Arendal Fax: +46 8 230441 | Stockholm Office Mobile: +46 733 467111 | WWW: http://www.grida.no | ------------------------------------------------------------- | | | | | ########################################### | | This message has been scanned by F-Secure Anti-Virus for Microsoft | Exchange. | For more information, connect to http://www.F-Secure.com/ | | | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
