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