Thanks for the info I'll give it a try. Ya, I suppose I should have
mentioned my front end. It
just happens to be ASP and VBSCRIPT so your method should work fine. I did
look through the
manual but was really sure what to look for.
I'll have to try this out though...thanks
again.
-Nick
> Hi Nick
>
> What has worked for me is using VBScript and doing a
>
Replace(variablename, ', '') for example this replaces ' in the first
> name so that they
can be added to the database:
> fname = Replace(Request.Form("fname"),"'","''").
Ignore the
> Request.Form, it is just requesting the variable from the previous
>
page.
You can use the variable name in the table in place of fname and
> then all ' should be
replaced
with ''. Remember to do a reversal when
> the data is called from the database to
be displayed
or the '' will
> show up in place of a '. You did not say what you were using as
your
> front end
to insert the text into the database so I am hoping this will
> help you.
If you look in the
MySQL documentation under escape
> characters (use the online manual
and look under E is
the fastest way)
> you can learn more about problem character in
regards to insertion
into
> a database.
>
> Regards,
> Loretta
>
> -----Original
Message-----
> From: Nick
Stuart [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April
03, 2002 10:59 PM
> To:
[EMAIL PROTECTED]
> Subject: Text Field Inserts
>
>
> I'm having a problem with
trying to come up with a work around for this
> common(?)
problem. I'mnew to using MySQL but
have gotten a handle on it
> pretty easily. My
>
problem is that I'm using itto develop a
simple message board and of
> course message
boards have a lot
> of text in them.
>
> My
problem is when a user types in a word like
can't or it's or
> something similar.
> You
>
can see the problem in that ' will stop the
current string and the next
> characters will be a
newone, which of course wrecks havoc on
the
> statement.
>
> Also haven't experimented
with
> other punctuation but
anything else to look out for would be nice as
> well.
>
>
Thanks for the
> help in
advance.
> -Nick
>
>
>
> ---------------------------------------------------------------------
> Before posting, please
check:
>
http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/
(the list
archive)
>
> To request this thread, e-mail <mysql-
[EMAIL PROTECTED]>
To
> unsubscribe, e-mail
> <mysql-unsubscribe-
[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
