[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-win32
Subject:    RE: INSERT ...Values('l\avion',...)
From:       "Ismael Touama" <ismael.touama () install ! fr>
Date:       2001-07-26 11:53:00
[Download RAW message or body]

Hi!
thanks

The source is an HTML entity, it is not to display.
Display seems working all alone (not sure)

I've got ' in my HTML page and want to insert it in the base,
so I think MySQL doesn't identify &#039;

I bieleved that putting \ before ' was enough!!

Ism

-----Message d'origine-----
De : Henrik Lantz [mailto:h.o.lans@chello.nl]
Envoyé : jeudi 26 juillet 2001 13:42
À : Ismael Touama; win32
Objet : Re: INSERT ...Values('l\avion',...)


Ismaël,
  The mysql syntax doesn't like the ' whether it's escaped or not.

If your purpose is to display the data in HTML, try replacing the ' with
&#039; instead - this is the HTML entity for the apostrophe.

Good luck,
    Henrik
----- Original Message -----
From: "Ismael Touama" <ismael.touama@install.fr>
To: "win32" <win32@lists.mysql.com>
Sent: Thursday, July 26, 2001 13:31
Subject: INSERT ...Values('l\avion',...)


> HELLo list!
>
> I make a replace in my ASP app to ...replace ' by \'
> The replace works but not the INSERT!!
>
> Can someone explain me that please?
>
> Thanx
>
> Ismaël
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread6907@lists.mysql.com
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail win32-unsubscribe@lists.mysql.com instead.
>


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail win32-thread6910@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@lists.mysql.com instead.


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail win32-thread6911@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]