Same issue here with Postgres after updating 1.2 alpha to beta. I
don't see that Postgres supports alias's nor joins in an UPDATE
statement.
Postgres 8.2.5
PHP 5.2.5
Cakephp 1.2 beta 6311
On Jan 6, 11:19 am, Lauwens <[EMAIL PROTECTED]> wrote:
> Installed new beta (was using the pre-beta) today!
>
> Is there a change in the Save method, or just in the dbo source, when
> I try toupdatea model now, the query uses a join with his
> 'belgonsTo' models.
> Generating a query like:UPDATEposts Post LEFT JOIN blogs Blog on
> (Post.blog_id = Blog.id) SET ... WHERE Post.id IN(id);
>
> Oracle is complaining that there is no SET keyword ?
> Warning (2): ociexecute() [function.ociexecute]: ORA-00971: missing
> SET keyword [CORE/cake/libs/model/datasources/dbo/dbo_oracle.php, line
> 290]
>
> so is this an error on my or cakephp's with oracle behalve ?
>
> as quick fix is just changed
>
> line 1245 of dbo_source
> case 'update':
> return "UPDATE{$table} {$this->alias}{$alias} {$joins} SET {$fields}
> {$conditions}";
>
> case 'update':
> return "UPDATE{$table} {$this->alias}{$alias} SET {$fields}
> {$conditions}";
>
> and yes i know, probably only oracle has this
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
