I don't think that MSSQL full text causes any more of a load than Verity does.
- Calvin ----- Original Message ----- From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, June 30, 2003 5:37 AM Subject: RE: UDF for MSSQL full-text searches > 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
