> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
> 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 parse
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 co
14 matches
Mail list logo
