This may be related to the thread I started 'Problem with Delete'.
I decided that DELETE {Alias} FROM Table must be non-standard because
you don't normally put {alias} in that position. I posted a bug
report:
#3984 (Delete {alias} from Table - non-standard SQL which stops
Firebird working)
See the 'Problem with Delete' thread or the bug report for my proposed
solution.
On Jan 24, 8:01 pm, stefan <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> i have a Problem with my Models that use HABTM relations (also i'm not
> sure if this causes the trouble)
>
> when using the $model->del($id) i get an sql error:
>
> SQL Error: 1066: Not unique table/alias: 'Company'
>
> the query built by cake is:
> DELETE `Company` FROM `companies` AS `Company` WHERE `Company`.`id` IN
> (11)
>
> why does cake to that?
> i could of course write my own query as this is a very tiny one, but i
> would like to understand why cake does this...
>
> thanks a lot
>
> stefan
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
