Posted by Jon on 04/24/07 17:53

On Apr 23, 6:45 pm, Oliver Grätz <oliver.gra...@gmx.de> wrote:
> Jon schrieb:
>
> > $sqlDeleteVal = sprintf("DELETE table_1 FROM table_1, table_2 WHERE
> > table_1.cost = table_2.cost");
>
> Wrong SQL syntax:http://sqlite.org/lang_delete.html
>
> OLLi
>
> --
> "You see, Mr. President: The worlds hates America. And for good reason.
> (I wont bother going into details)"
> [24 319]


syntax is fixed.

"DELETE * FROM table_1, table_2 WHERE round(table_1.payment,2) =
round(table_2.payment,2)*-1";

Checked it by replacing DELETE with SELECT it and it shows the items I
wanted DELETED but DELETE is still not working. Doesn't do anything
but no warnings/errors.

[Back to original message]