|
|
Posted by Jon on 04/24/07 17:36
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]
Thanks OLLi, yes I updated but forgot to post: this is the current
fixed syntax.
$sqlDeleteVal = "DELETE * FROM table_1, table_2 WHERE
round(table_1.payment,2) = round(table_2.payment,2)*-1";
With switching DELETE with SELECT, it yields exactly the results I
want to delete. However, with the above fix to my code, no deletion
occurs. I'm very confused!
Navigation:
[Reply to this message]
|