Thanks! That's what I tried first. Didn't work. Now it does. Go figure.
best, paul
At 03:39 PM 6/5/01 -0500, you wrote:
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists