thanks again for your hints...i updated to the latest nightly build
which was no good idea because somehow it messed up with my auth
component...so i reverted all and just uses the dbo_.. from that build
and now the query problem is gone...
On 26 Jan., 17:36, villas <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
