@RichardatHome. That's what I figured. But maybe other DBs accept
the 'alias' in the middle?
@davidgregan. Which DB accepts this format? MySQL?
DELETE {$alias} FROM table
FirebirdSQL definitely doesn't like it :-)
On Jan 24, 10:46 am, RichardAtHome <[EMAIL PROTECTED]> wrote:
> I don't know firebirdSQL, but every other version of SQL (and this is
> how the SQL92 spec. has it) I've ever used uses the syntax described
> by villas:
>
> DELETE FROM table WHERE conditions.
>
> On Jan 24, 12:31 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> wrote:
>
> > 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
-~----------~----~----~----~------~----~------~--~---
