After updating to the latest 'nightly' version, my problem with
'delete' in firebird appeared to have been resolved.
Maybe that will work for you too.
However, I am still curious about the SQL 'delete {alias} from'
because I cannot see why the {alias} would be required in that
position by any SQL database?
On Jan 25, 12:44 pm, stefan <[EMAIL PROTECTED]> wrote:
> thanks for your tips.
>
> i'm using 1.2.0.6311 beta right now, hopefully there are no other
> problems when updating
>
> On 25 Jan., 11:37, villas <[EMAIL PROTECTED]> wrote:
>
> > 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
-~----------~----~----~----~------~----~------~--~---
