How do you go about doing Boolean search with CF and SQL statement?
The search needs to be able to use AND, AND NOT, and OR.
So if a user types in Boston AND Bruins, the application would search for
the matches that have both Boston and Bruins.
If a user types in Boston OR Burins, the application would search for the
matches that have either Boston OR Bruins.
If a user types in Boston AND NOT Bruins, the application would search for
the matches that have Boston but not Bruins.
Is there a custom tag that's already built somewhere for this kind of thing?
Thank you for any help!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
