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

List:       mysql-win32
Subject:    Re: INSERT ...Values('l\avion',...)
From:       "Jim Michaels" <jimm2 () integrity ! com>
Date:       2001-07-27 0:18:04
[Download RAW message or body]

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-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.


_____________________________________________________________________
For your protection, this email has been further checked for all known
viruses by tenten digitals service provider Message Labs. Please see
disclaimer for further information.

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail win32-thread6908@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-thread6917@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]