Escape the single quote with '' (2 single quotes).
Depends on what language you are using, some languages like PHP have a
built-in function to do this. others like VFP have things like strtran().
Cal
http://www.calevans.com
-----Original Message-----
From: Warren van der Merwe [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 13, 2001 2:13 PM
To: [EMAIL PROTECTED]
Subject: SQL Statements
Hi there
I have run into a problem, I have changed all my code from using ADO and
MSACCESS to SQL statements using the MYSQL API, however, some of my fields
have a single quotation in them, and now this interfears with my syntax and
I am getting problems, is there a way to overcome this? I know one way is to
not allow the field to contain the single quotation, but now what happens to
fields that contain them already, and alot of my stuff is imported from
third parties and they contain them.
Any help will be appeciated.
Thanks
Warren
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
