Can someone tell me how to parse a string. Like if the
user inputs JOE'S COMPANY in the text box, how do I
search for the apostrophe and then use the following
code to insert in the database.
Appreciate.
A.B.
--- Larry Meadors <[EMAIL PROTECTED]> wrote:
> I use <cfset fld = replace(fld, "'", "''")> to
> replace a single quote with two quotes, then insert
> that value into the database.
>
> This works for both SQLServer and Oracle.
>
> Larry
>
> >>> [EMAIL PROTECTED] 04/27/00 02:45PM >>>
> 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.
>
>
>
------------------------------------------------------------------------------
> 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.
__________________________________________________
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.
