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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
