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