Spectra: Searching for Content Items with More than One Searchable Property

Jun 05, 2000

When you have more then one searchable property for a Content Object, you may need to use a self-join to get the appropriate result-set returned. This page gives the piece of SQL that will help when you need to search for content items based on more then one searchable property.

Latest ColdFusion Talk (CF-Talk)

Question for UK List Members
query of query strange error
Files are getting uploaded full of zeros after CF9 upgrade
cfmail to Exchange using TLS
How to prevent cfhtmlhead content from being inserted into cfmail
Excel 2003/2007 Recalculating Interaction
Coldfusion Hosting
Problems verifying integers
CFHIGHCHARTS
Need to get at browser size and Flash support

Latest ColdFusion Jobs (CF-Jobs)

Mid to Sr Level Web Application De veloper – position 3510-1 - CA or NC
Contract to Hire in Irvine, CA
Telecommute Contract Position - Mid to Experienced ColdFusion Programmers Only
Need a Coldfusion Developer at Woodlawn MD for a Long Term Contract
(JOB) ColdFusion Programmer Needed (Ocean Isle Beach, NC) Raleigh,NC
Cold Fusion SQL Server and JavaScript Developer
(JOB) ColdFusion Programmer Needed (Ocean Isle Beach,NC) Wilmington,NC
*** Professional Services Available For Hire
(2) ColdFusion Experts to support FAA Senior Executives
(JOB) ColdFusion Developer in Florida!!!

Want a number like 800-ColdFusion?

My Toll Free 800 Number provides a vanity phone number service to clients who want more than just digits. How would you like 800-coldfusion?