Re: Strange error when to use MySQL++ 2.2.0 inplace of MySQL++ 2.1.1

[Jonathan Wakely]

On 08/02/07, Bassam A. Al-Khaffaf <bassam@stripped> wrote:
>
> Query error: You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> ';' at line 4
>

IIRC you do not want ';' in the SQL string.  That is used on the
command line or in scripts to indicate the end of a query, but when
you pass a query to the API it knows when the end of the SQL statement
is (the end of the string)

Just remove the last character of yiour SQL.

jon