Strange.... I do the same thing, and SQL Server 7
has no problem inserting Form.org_name into a varchar
field when Form.org_name is JOE'S COMPANY
OTOH, Query Analyzer needs JOE''S COMPANY in order
to search (in a SELECT) for JOE'S COMPANY
best, paul
At 01:45 PM 4/27/00 -0700, you wrote:
>I have a form where the user inputs the name of the
>company besides other values. There is a company that
>has an apostrophe in the name. For example: The
>company name is JOE'S COMPANY.
>
>The person is having problem filling out the form
>because whenever he is trying to submit, the database
>is not accepting the input with an apostrophe.
>
>Can someone give me an idea of how to get around it?
>By the way, I am trying to insert the data in SQL
>server database table.
>
>Appreciate.
>A.B.
>
>__________________________________________________
>Do You Yahoo!?
>Talk to your friends online and get email alerts with Yahoo! Messenger.
>http://im.yahoo.com/
>------------------------------------------------------------------------------
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
