> Other than converting to "Lauren* Closet" and searching for "Lauren*
> Closet", how do I automagically search and find: "Lauren's
> Closet" using
> SQL7 full text search?
Escape single quotes by replacing them with two single quotes prior to
submitting the search query. You would then be searching for "Lauren''s
Closet". You can do this programmatically, of course, on the search action
template. Escaping single quotes is also a good security precaution (along
with removing pipe characters), so malicious users don't create a little
subquery that drops a database or table from your search form.
Ron Hornbaker
President/CTO
Humankind Systems, Inc.
http://humankindsystems.com
mailto:[EMAIL PROTECTED]
..�_�.���) http://www.BookCrossing.com ~ Read and Release! (�`�.�_�.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
