Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
Spectra-Talk
SQL Full-text search on Spectra content?
Author: Collins, Steve
Short Link: http://www.houseoffusion.com/groups/spectra-talk/thread.cfm/threadid:1831#5601
Derek
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 steve.collins@industry.gov.au
P +61 2 62137193
C +61 410 680722
F +61 2 62136227
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.
***********************************************************************************
|
June 18, 2013
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
