Hi,
where a1="Here's"
You need to escape the ' character with a backslash before you send the
query to the server.
If you develope with C this link might be useful:
http://www.mysql.com/doc/en/mysql_real_escape_string.html
If you develope wit perl + DBI there comes a quote methode with the DBI
pa
Hi,
Following statement was working fine untill recently when someone entered specail
characters in insert statement.
eg
insert in db (col1,col2) values('a1','a2');
where a1="Here's"
a2="Your's"
thats is when apostrope is applied.
Thanks
Adamji
