SQL7/2000 allows combination of full-text searches and standard SQL in the same query.
With Verity I find I often need a query to find the list of IDs that match the search text, and then a second query to match the standard SQL constraints. Not that important if your app is not heavily loaded. best, paul At 12:02 PM 12/13/02 -0500, you wrote: >Would love to hear people's feelings and relative advantages/disadvantages >of each.Need to make a decision and I'm vacilating between the two. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com
