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
