[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-27 13:45:10
[Download RAW message or body]

Thank you, this the case...(web app)

For the archive, I don't understand the e-mail @ you provided me.
I ask for what ?

thanx

-----Message d'origine-----
De : Glenn Wearen [mailto:glenn.wearen@columba.com]
Envoyé : vendredi 27 juillet 2001 15:39
À : 'Ismael Touama'; Jim Michaels; Joel Hughes; win32
Objet : RE: INSERT ...Values('l\avion',...)


>I just replace ' by > &#039;.

This is fine if your DB will only be accessed by a web-app, if an app other
than a web-app reads this database it will be out of data.

Glenn

PS: search general@lists.mysql.comn archive, I found a lot of threads
devoted to this subject.

> -----Original Message-----
> From: Ismael Touama [mailto:ismael.touama@install.fr]
> Sent: Friday, July 27, 2001 8:14 AM
> To: Jim Michaels; Joel Hughes; win32
> Subject: RE: INSERT ...Values('l\avion',...)
>
>
> Hi !
>
> I guessed that the MySQL standard is to escape single quotes with \'
> In fact it works for the insert (to place in the right place...bizar
> componenent of host language!)
> But if I select after the insert my strings are cutted!
>
> Someone gave me the solution. As i dev an e_site, I just replace ' by
> &#039;.
>
> And all works fine...
>
> Thank you
>
> Ismaël
>
> -----Message d'origine-----
> De : Jim Michaels [mailto:jimm2@integrity.com]
> Envoyé : vendredi 27 juillet 2001 02:18
> À : Joel Hughes; Ismael Touama; win32
> Objet : Re: INSERT ...Values('l\avion',...)
>
>
> Actually, the SQL standard is to escape single quotes with another
> single-quote.
> 'hasn''t a hammer' or '''ouch!'' he said.'
> Jim Michaels
> ----- Original Message -----
> From: "Joel Hughes" <jhughes@tentendigital.com>
> To: "Ismael Touama" <ismael.touama@install.fr>; "win32"
> <win32@lists.mysql.com>
> Sent: Thursday, July 26, 2001 4:36 AM
> Subject: RE: INSERT ...Values('l\avion',...)
>
>
> looks like your escaping the nested quote...
>
>
>
> -----Original Message-----
> From: Ismael Touama [mailto:ismael.touama@install.fr]
> Sent: 26 July 2001 12:32
> To: win32
> 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-thread6921@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]