Re: users using &, ", ', and other chars in input fields

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:<R7ednR80wqdRWYfdRVn-sw_at_comcast.com>...
> "Michael Hill" <hillmw_at_charter.net> wrote in message
> news:101krd93fbhpe3d_at_corp.supernews.com...
> | The users will cry, bitch, moan, groan, and other stuff if their
> ampersands
> | gets stripped out.
> |
> | That's what I am asking.
> |
> | Am I hearing that the predominate "fix" is to strip out characters like &,
> | ", and others?
> |
> | Mike
>
>
> no one has bothered to ask what the user interface tool is
>
> SQL*Plus? I sure hope not.
> Forms?
> VB/.Net/etc.
> HTML Forms?
>
> -- mcs

And don't forget, what is the ultimate use of the data. I just had one where they wanted separate Excel files for each of many customers.  And naturally, it has to generate a good filename on both unix and Windows, and based on the customer's names, which naturally have ampersands and possesives, and using a language with different quoting rules than SQL...

jg

--
@home.com is bogus.
http://slashdot.org/articles/04/02/02/2136215.shtml?tid=109&tid=111&tid=126&tid=187