this is not correct SQL, it should be:
DELETE "CURRENCY" FROM "CURRENCIES" AS "CURRENCY" WHERE
"CURRENCY"."ID"
so I'm guessing the line in dbo_source.php should be:
return "DELETE {$alias} FROM {$table} {$this->alias} AS {$alias}
{$joins}
{$conditions}";
Does this fix the problem as well? If so, you should probably change
it to that, as a $conditions array will likely cause it to bomb again
without AS {$alias}, since CakePHP will try to use the alias
"CURRENCY" on any conditions instead of using the actual table name
"CURRENCIES".
On Jan 23, 4:21 pm, villas <[EMAIL PROTECTED]> wrote:
> Cake 1.2 beta WindowsXP FirebirdSQL Code baked
>
> I notice on deleting a record I get a SQL error
> e.g.
> DELETE "CURRENCY" FROM "CURRENCIES" "CURRENCY" WHERE
> "CURRENCY"."ID" ...
>
> Is this SQL correct -- why does the second word exist? ("CURRENCY"),
> shouldn't it just be Delete From CURRENCIES....
>
> I notice that everything seems to be OK if I edit dbo_source.php and
> comment out the first {alias} in this line:
>
> return "DELETE {$alias} FROM {$table} {$this->alias}{$alias} {$joins}
> {$conditions}";
>
> ...maybe it's just a FirebirdSQL thing?
>
> If it's a bug I could report it, but I would appreciate advice
> because I am often wrong about these things :-)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
