It's fixed now.
On Jan 12, 2:42 pm, jasonL <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
