Not so much the SQL searching capability (we use Oracle), but definitely direct SQL either from CF or with stored procedures directly into the properties (and occasionally, objects) tables. They do result in some significant joins, and you'll need to be careful with your SQL, but it is quick and effective.
Steve
--
Stephen Collins
Web Development Section
eBusiness Division
__________________________________________________
Department of Industry, Tourism and Resources
Level 12, 20 Allara Street, Canberra City ACT 2600
GPO Box 9839, Canberra ACT 2601
E [EMAIL PROTECTED]
P +61 2 62137193
C +61 410 680722
F +61 2 62136227
-----Original Message-----
From: Derek Westfall [mailto:[EMAIL PROTECTED]
Sent: Saturday, 27 March 2004 4:47 AM
To: Spectra-Talk
Subject: SQL Full-text search on Spectra content?
Has anyone used MS SQL's full-text search functionality to replace the
Verity searching in Spectra?
I'd be interested in how that works.
Derek
**********************************************************************
The information contained in this e-mail, and any attachments to it, is
intended for the use of the addressee and is confidential. If you are not the intended recipient you must not use, disclose, read, forward, copy or retain any of the information. If you have received this e-mail in
error, please delete it and notify the sender by return e-mail or telephone.
The Commonwealth does not warrant that any attachments are free from viruses or any other defects. You assume all liability for any loss, damage or other consequences which may arise from opening or using the attachments.
***********************************************************************************
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
