My apologies.
query << "UPDATE clienttransfer SET isCompleted=1
> > WHERE isCompleted=0" << endl;
Ahh, ok when I use:
query << "UPDATE clienttransfer SET isCompleted=1
WHERE isCompleted=0";
your right no error. However I then wanted to preview
it which was "maybe" misleading me into thinking that
there was an error in the update statement. I think in
the recent emails somebody pointed a problem with
"preview" and termination.
I would see:
UPDATE clienttransfer SET isCompleted=1 WHERE
isCompleted=0
You have an error in MySQL syntax;check the manual
that corresponds toyour MySQL server version for the
right syntax to use near '' at line 1.
Thanks,
Garyc
--- Warren Young <mysqlpp@stripped> wrote:
> gary clark wrote:
> >
> > query << "UPDATE clienttransfer SET isCompleted=1
> > WHERE isCompleted=1" << endl;
>
> The problem here is the endl, not something in
> MySQL. The exception was
> MySQL telling you that it doesn't know what to do
> with that newline
> character. You could have just taken it out,
> instead of changing over
> to SSQLS.
>
> That aside, why is this query useful...isn't it a
> no-op?
>
> --
> MySQL++ Mailing List
> For list archives: http://lists.mysql.com/plusplus
> To unsubscribe:
>
http://lists.mysql.com/plusplus?unsub=1
>
>