Friday, March 07, 2008

delete issues in firebird in cake php

seems that delete statement is not correct

SQL Error: Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 8 "POST" [CORE/cake/libs/model/datasources/dbo_source.php, line 440]

and the delete statement is here

DELETE "POST" FROM "POSTS" "POST" WHERE "POST"."ID" IN ('5')

the correct form that works in flamerobin for example is

DELETE FROM "POSTS" "POST" WHERE "POST"."ID" IN ('5')

No comments: