Hi,
I am running a query using C APIs to insert a large text item into a MySQL table.
The query is as follows
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata contains a single quote, then that single quote is
taken as the end of the column value by the MySQL parser and the data after the quote
is ignored resulting in an error.
Help is urgently required.
Thanks in advance.
Shambhu kumar Singh.
_____________________________________________________
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com
---------------------------------------------------------------------
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